8 Replies Latest reply on Sep 8, 2011 12:29 PM by philmodjunk

    Use values from repeating field in a text calculation?

    FMNewbie

      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