Looping in filemaker using a local variable

Posted by Mike Davis on Stack Overflow See other posts from Stack Overflow or by Mike Davis
Published on 2013-10-20T03:49:17Z Indexed on 2013/10/20 3:53 UTC
Read the original article Hit count: 151

Filed under:

Been programming in C# for a little bit - trying to use file maker and I cant believe it but I cant even get a simple for loop to work.

What I want to do is simple: loop through for the amount of entries in my "amountOfRooms" field and create an entry in a table for each room.

Sounds so simple, but I cant get it to work. Right now I have this:

Set Variable[$cnt[Customers::AmountOfRooms]; value:1]

Go to Layout["rooms"(Rooms)]

Loop

Exit Loop If[$cnt = Customers::AmountOfRooms]

New Record / Request

Set Variable[$cnt; Value: $cnt + 1]

End Loop

Exit Script

No new records are created. I know the script is running because it does go to my layout, but doesnt create any new records. There is a "Repetition" field for my local variable - not sure how to use that or what it means? Any thoughts on how to do this simple loop? Thanks.

© Stack Overflow or respective owner

Related posts about filemaker