4 Replies Latest reply on Nov 8, 2013 5:05 PM by ChrisJohnston

    Field of values, Script using loop

    ChrisJohnston

      Title

      Field of values, Script using loop

      Post

           Field of values using loop.

           Does anybody have an example of a Script using a field of values and looping through it? I had found the FileMaker article here http://help.filemaker.com/app/answers/detail/a_id/2403 and added the good advice, that this is not currently the best way to do this from the moderator, and other advice to not use copy and paste (a better way is to set variables and retrieve them was the advice of many knowledgeable people). In this article it show a way to use a loop to run through the records in a portal, and send the useful data to another field. It works but does not seem to be that efficient. One thing that makes me wonder about it is, this is the only script that show and hour glass in my solution.  So what if you had the list of values in field and wanted to check if some condition was true or anything else on the values. If these values are in a field how can you loop through and perform condition checks and such. I have already determined that you have to use ValueCount() instead of Count to count them, I was sitting 15 minutes wondering why Count was always 1. Pic shows type of result I am referring to.

      http://pctechtv.com/show/listscript.png