Creating and editing scripts
After you have planned your scripts, you are ready to create, edit, and manage them.
|
1.
|
You can also choose Empty Script or Default Script from the New list. If you choose Default Script, FileMaker Pro includes default script steps that you can edit or delete in the Edit Script window.
|
Type a name for the new script in the Script Name text box.
|
|||||||||||||
|
Select it from the list of available steps and click Move. Typing the first few letters of the script step scrolls the list to that script step.
|
|||||||||||||
|
Specify script step options
|
A step with square brackets after it has options you can set. Double-click the step, or select it and click Specify. In the next dialog box, specify options, and click OK.
When specifying options for some script steps, you might see the parameter “Restore”. Restore indicates that the criteria you specified when the script step was last edited is used when the script step is executed.
|
||||||||||||
|
Select it in the list on the right and click Duplicate.
|
|||||||||||||
|
Select it in the list on the right, then choose Edit menu > Copy. Click in the list where you want the script step to appear, and choose Edit menu > Paste. You can also copy and paste script steps into other scripts, copy and paste scripts, or copy and paste into other files. See Copying and pasting scripts.
|
|||||||||||||
|
View available script steps by category or name
|
|||||||||||||
|
See which script steps are not supported in FileMaker Server schedules, web publishing, or FileMaker Go
|
Choose an option from the Show Compatibility list:
This option refers to scripts running in a FileMaker Server schedule. When a FileMaker Pro or FileMaker Go client runs a script in a database that is hosted by Server, the script steps are run on the client. The steps that are compatible with Desktop or iOS are executed.
|
||||||||||||
|
Perform the script with full access privileges
|
Select Run script with full access privileges. See the Note below for additional information.
|
||||||||||||
|
Reorder the script steps
|
|||||||||||||
|
For information on each script step and its options, see Script steps reference (alphabetical list) and Script steps reference (category list).
|
4.
|
When you are finished, close the Edit Script window, then click Save to save it. Or choose File menu > Save Script (Windows) in the Edit Script window, or choose Scripts menu > Save Script (Mac OS) in the FileMaker Pro menu bar.
|
|
6.
|
To include the script in the Scripts menu, select the checkbox next to the script, or select the script and select Include in menu.
|
|
•
|
Use Ctrl+click (Windows) or Command-click (Mac OS) to select multiple script steps. You can add, duplicate, or delete multiple steps.
|
|
•
|
You can use operators to concatenate text, perform mathematical functions, and do logical comparisons. For more information, see Using operators in formulas.
|
|
•
|
Add comments to your scripts with the Comment script step. Using comments in your script helps others who might want to look at or modify it.
|
|
•
|
To build scripts quickly, duplicate (or copy and paste) an existing script that does something similar to what you want to do and modify the copy. To create a duplicate script with the same name as the original, select it in the list and press Shift+Duplicate in the Edit Script window. (Or, in the Manage Scripts dialog box, press Shift as you click
 .) |
|
•
|
.|
1.
|
|
2.
|
In the Manage Scripts dialog box, select the script you want to change, then click Edit or double-click the script name.
|
Tip You can open multiple Edit Script windows at the same time. In the Manage Scripts dialog box, use Ctrl+click (Windows) or Command-click (Mac OS) to select non-contiguous scripts, or Shift-click to select contiguous scripts, then click Edit. A separate Edit Script window opens for each script. Double-clicking with multiple scripts selected only opens the script that you clicked. To close all windows, press Alt (Windows) or Option (Mac OS) and click the Close button in any window.
|
4.
|
To perform your script, select it in the Manage Scripts dialog box and click Perform. Make any changes to your script as needed.
|
|
•
|
You can also create, edit, duplicate, and delete scripts from the Specify Script dialog box when you create a button or script trigger.
|
|
•
|
Use Run script with full access privileges to enable a script to run with the full access privilege set, even if the current user has logged in with a privilege set that does not have full access. Using this feature enables users with limited access and privileges to perform scripted tasks that they would otherwise be unable to execute, such as exporting or deleting records. Access privileges do not change, but the script can do more privileged work for them. Furthermore, full access does not carry over to any subsequent sub-script, unless this feature has been enabled in that script as well.
|
|
•
|
The Run script with full access privileges feature can only be enabled or modified by users with full access privileges. Therefore, only users with full access privileges can edit or delete scripts for which this feature has been enabled.
|
|
•
|
The Run script with full access privileges feature only functions in the file in which the script is defined. This command will not override access restrictions on external files. For example, a script to delete records in File A that has the Run script with full access privileges option enabled will not delete records in an access-restricted external file File B.
|
|
•
|
Users without full access privileges can be given permission to edit scripts that are marked as modifiable in their assigned privilege set. Full access privileges are required to create, duplicate, import, and/or delete scripts.
|
|
•
|
If you are using FileMaker Pro Advanced, you can disable script steps for testing. To disable a script step, select it, then click Disable. To enable a script step, select it, then click Enable. Disabled script steps are preceded by “//”. For more information, see Disabling script steps (FileMaker Pro Advanced).
|
|
•
|
If a script step specifies a field in a tab panel that is not in front, the specified field is selected and the tab panel it is in moves to the front of the tab control. If, however, the same field appears elsewhere on the layout and the script finds that field first, the tab panel with that same field will not come forward. Instead, assign an object name to the field and use the Go to Object script step to move to that instance of the field.
|