Get next value from value list

[deego55]

Hi All. I have a loop that needs to go through a value list and set a field to the next value (then exit loop after last value).

I think i have it working except the calculation to grab the next value. I assume it uses the GetValue function, but not sure exactly how to script it. Can anyone help? Thanks!

[sbg2]

I would put the Value List in a global text field with - Set Field[MyGlobal; ValueListItems(Get(FileName); "MyValueListName"]. Then create a global counter field (number).

then you can step through each value in the list with the MiddleValues function...

Set Field[MyCounter; 0]

Set Field[MyGlobal; ValueListItems(Get(FileName); "MyValueListName"]

Loop

SetField[MyField; MiddleValues(MyGlobal; MyCounter ; 1 )]

Set Field[MyCounter; MyCounter + 1]

Go To Next (Exit after last)

End Loop

[deego55]

thanks sbg2!