AnsweredAssumed Answered

filtervalues location

Question asked by gethappy@happypc.com on Aug 3, 2017
Latest reply on Aug 3, 2017 by philmodjunk

I'm trying to get the NEXT (or PREVIOUS) value in a return separated list of values.

 

So I have a global text field displaying a list of key values like

43

45

46

47

 

and in a separate global field I have one of these values (i.e. '45').  I want to find a way to the next value ('46')

 

I could use position to find the position of the 1st value ('45') and then the next "¶" ... but I have to think there's a better way since sometimes there wont be a paragraph (If the last value) and other complexities.

 

In a perfect world, I could find that '45' is the 2nd value and then I could use getvalue to find the 3rd value ... but how to find out which value '45' is??

Outcomes