Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Getting value from a repeating field

BL Splash

Recommended Posts

Is there a way to verify a value (text) from a repeating cell? Here is my example:


First field - "Game Played" either "JV" or "V". (repeating field)

Second Field - "Assists" with numeric vaule

Third field - "Total assists JV" - Needs to erify "Game Played" = "JV" then does sum of "assists" field

Fourth Field - "JV Points assists" - "Total assists JV" * 1.5


Then same thing for the "V" value in the first field. What I get right now is it only looks at the first value of the "Game Played" and does the calcs...so I have some players that play both and I only get a value in the Varsity side...help?



Link to comment
Share on other sites

First thing. You probably should think about breaking away from repeating fields and separate the into single fields. Much easier to manipulate.



have you tried using the

GetRepetition (repeating field, number) Statement. This go to the repeating field and the repetition field number.



GetRepetition (datafield, 3)


Wil go to DataField and the 3rd Rep.

Link to comment
Share on other sites

The only reason not to break apart the repeating field is because for the 10 catagories, i have 31 repetitions each...plus a ton of calculating functions to cut and paste.


I had thought of that "GetRep..", but the "Total" field gets all of the total from all 31 fields, would I have to have a clarifier of number location for each of the repetitions of the Assists first to then look at the repetions of the game played? Does that make sense?



Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

Terms of Use