I need to perform repetitive finds. Basically, it's like this.

I need to perform finds based upon the contents of a value list. The number of items in that list is going to be subject to change. Currently there are 10 items, but that number will almost certainly increase and I can't know in advance what the newly added items will be.

I need to perform a find and on several iterations of the find I need to set a field to (Item 1 of value list), after the search has been completed several times I need to do similar searches based on (Item 2 of value list) and so on.

I need to know if there is a method for accessing the Nth item in a value list via scriptmaker.

Does anyone have any idea?

Set your field to:

Substitute (

MiddleValues ( ValueListItems ( Get ( FileName ) ; "yourValueList" ) ; N ; 1 ) ;

This is perfect. I just tested this out and with the use of an iterator, I can get every value in the list automatically.

Set your field to:

Substitute (

MiddleValues ( ValueListItems ( Get ( FileName ) ; "yourValueList" ) ; N ; 1 ) ;