Extracting Values from Value Lists / Check Boxes

[evancooney]

Hello,

I have a value list of items with checkboxes. I want a script to cycle through that value list and operate individually on each item that is checked. What is the best way to do this?

Thank you.

Evan Cooney

[jasonwood]

Check boxes are simply a way of entering data into fields, so you work with them in the same way.

eg:

If [checkboxfield = "Yes"]

do this

End If

[evancooney]

I understand. Then let me try a different question:

If I have a text field with values (seperated by a new line):

BILL

BOB

GEORGE

ALAN

How can I cycle through those values and perform an operation on each entry? Example: Create a new record with each one of those names as a field value.

Thanks

E

[BobWeaver]

* Set a global text field gTempList to the contents of your list

Set Field [gTempList, TheListfield]

* Now loop for each item in the list

loop

* If no more items in list, then we are done

Exit Loop If [Length(Substitute(gTempList,"

[evancooney]

I plugged in this script and it results in an endless loop.

[BobWeaver]

Put a pause step inside the loop so you can check to see what is happening to the contents of gTempList. Each time through the loop it should have one less item in it. I'm assuming that the items are separated by a line break since that is how valuelist items are normally separated. If not, then you will have to change the delimiter character from "

[evancooney]

Does it matter that the value is generated from all of another file's values? For example, this value list is composed of all the discIDs from the CoreDisc database. Will this script only work if it is a user defined value list?

Thanks so far.

[BobWeaver]

It shouldn't matter where you get the values from. However, I noticed an error in the script that I posted. It will get into an endless loop if the list doesn't have a line break at the very end. I edited my previous post to correct the error.

Also, I have attached a sample file.

Process.fp5.zip