Hello,

I am starting with Filemaker and I would like to build a simple script. Exemple : In a layout I have many record with a field called "Number of room". I would like to list all fields with no room. How can build this script ? Where should I put this script ?

Your help will be greatly appreciate.

You can attach scripts to a button, allow them to be accessed from the Scripts menu, or allow them only to be accessed from another script.

Enter Find Mode, using Ctrl-F, and type an equals sign (=) into your Number of rooms field. Click the Find button on the Status Area to the left or press Enter.

Now create a script to hold the criteria for the find just performed.

Set Error Capture [On]

Perform Find [Restore]

If [not Status(CurrentFoundCount)]

Show Message ["All records have Number of rooms specified."]

End If

I tried what you said.

I Entered Find Mode, using Ctrl-F, and type an equals sign (=) into my Number of rooms field. I press Enter.

Now you said : "Now create a script to hold the criteria for the find just performed." I don't know where to do this. I tried the ScriptMaker but can't find any place to enter :

Set Error Capture [On]

Perform Find [Restore]

If [not Status(CurrentFoundCount)]

Show Message ["All records have Number of rooms specified."]

End If

Thank you!

The find is saved in the "restore" part of the "Perform Find [Restore]" script step.

If you ever need to change the saved find information, open the script in Scriptmaker, close it, then click the "replace" option in the dialog that follows.

Set Error Capture, Perform Find, If, and Show Message are script steps that you select from the list on the left once you have created a new script.