phanh

Loop and If condition

Discussion created by phanh on Aug 3, 2012
Latest reply on Aug 15, 2013 by Stephen Huston

New to FileMaker scripting and need some help troubleshooting the logic :-)

We have a script to loop through all records to determine whether the new username (which is a calculation of first name and last name) matches with existing records. Here is our script but the logic isn't working out correctly. When it hits the Else statement, rather than looping through the remaining records, it exists the If statement. Any help is appreciate.

 

Set variable ($temp, value:volunteer::username)

GO to record/page/request [first]

 

Loop

IF(volunteer::username = $temp)

SHow custom dialog

Else

GO to record/request/page [next, exit after last]

GO to layout[print]

ENd if

ENd loop

Outcomes