Return to FileMaker.com
Perform Find Script for non-empty fields
Looking to add a find to my "OnLayoutOpen" script to omit (not sure Im using that term correctly) any empty fields in my layout. Actually I need two finds...
Priority is not empty and Status does not equal complete
You can specify a single * find operator in a field to find all records where Priority is not empty. You can also add an "omit" request that specifies "complete" in the status field to then omit all records where status is complete.
This can be done manually or scripted.
Retrieving data ...