Should the script work on all records in the database, the current found set, or a specific set of records? (Use the Found Sets script steps to include only the records that you want to work with in the found set.).Use the Go to Layout script step to change layouts. Do you want the script to run in a particular layout? Because scripts are defined at the file level and can be called from any layout, you should make sure the script will operate in the layout or layouts you expect.See Control script steps for more information on creating scripts with conditional steps. What script steps should be run under what conditions? Should every script step always be run? Should some be run a number of times until a certain condition is met? Should the script call other scripts and sub-scripts? You can control the progression of the script in a number of different ways.(Use Perform Script script step to perform a sub-script inside another script.) You can also reuse sub-scripts in other areas. It's easier to design and test several small scripts than one complex one. Can you separate the task into smaller tasks? You can define sub-scripts for each small task, and then define a script that performs the sub-scripts.

As you plan, ask yourself these questions: The more time you spend planning your script, the more likely that it will accomplish what you want. See About running scripts on FileMaker Server and FileMaker Cloud products. Scripts normally run on the client, but you may want to run some scripts on FileMaker Server or FileMaker Cloud products to improve performance or to automatically run on a schedule. You build scripts by selecting from a list of FileMaker Pro Advanced commands, called script steps, specifying options (if necessary), and arranging the steps in the correct order to perform the task.

The whole task is initiated by clicking a button on the Sales Entry layout. The script switches to Preview mode and pauses so you can see what the message looks like before it is sent. The script composes an email tailored to each client. Scripts can do simple tasks like setting print orientation, or complex tasks like preparing a customized mailing to each client.įor example, you could define a complex set of tasks that creates a thank you email to clients in your Clients database who have made purchases in the last week.

Filemaker server