The Original FileMaker Community
Business Templates - Demo Apps - Video Tutorials -Samples - Help - 46000 Member Forum

The Leading Filemaker Developer Tools

The FileMaker (Exit Loop If) Script Step – FileMaker Today


Used to determine what set of conditions need to be met to exit out of an established ScriptMaker looping routine. This is based upon using the calculation dialog box to establish those “end loop” parameters. Here is a brief example


Go To First Record

Loop

If (this record has this quality)

Set This Field Equal To That

Else

Set This Other Field To Something Else

End If

Go To Next Record

Exit Loop If The Next Record Has (this, that or the other quality)


 


HOW IT IS USED

All loops need to have a way to exit out of the loop. Loops normally will go from record to record … or … field to field in a particular record. In either case, the Exit Loop can be used to exit the loop based upon any calculation such as …


Customers Name, Address, Payment Status, etc…

The current record contains duplicate values, unique values, etc…

Counter ( using a method to increment a global ) has reached a value of …


It is also possible to have loops inside of loops. The Exit Loop If script step is one of the most popular ways to exit out of sub-looping routines based upon a fulfilling a set of criteria.


COOL IMPLEMENTATIONS OF IT

There are some cool ways to have FileMaker count. You can have an Exit Loop If step activate when the counter reaches a predetermined number.


=

More info about the author and FileMaker in general, contact me at This email address is being protected from spambots. You need JavaScript enabled to view it..

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Accept Read More