AnsweredAssumed Answered

Use values from repeating field in a text calculation?

Question asked by FMNewbie on Sep 8, 2011
Latest reply on Sep 8, 2011 by philmodjunk

Title

Use values from repeating field in a text calculation?

Post

Hey folks...

First off, I know repeating fields are evil, but they happen to fit the application in question. What I'm curious about is whether there is a way to assemble the values found in a repeating field into a calculated text string?  For example if FRUIT[1]="apples", FRUIT[2]="oranges" and FRUIT[3]="bananas"... is there a way to complile them into a text string: "apples, oranges and bananas." 

Also... is there a way to have it skip any blank entries so if FRUIT[4], FRUIT[5] AND FRUIT[6] are empty it will still return "apples, oranges and bananas"... or for that matter if FRUIT[2] is empty, just "apples and banans"??

Suddenly I'm strangely hungry... anyway, any thoughts... or better ideas?? 

Cheers  Laughing

Outcomes