Virtually any script step you can think of has been predefined within FileMaker. You build scripts within ScriptMaker’s Script Definition dialog box where all the available script steps are listed in the left-hand column (Figure C.1). Use this appendix as you work within the dialog box to quickly look up what actions each script step will trigger. The appendix is arranged in the same order and groups as the steps displayed in the left-hand column. For more on using FileMaker’s ScriptMaker, see Using Templates and Scripts on page 209.
Figure C.1. Use the Script Definition dialog box to build scripts by selecting script steps on the left-hand list and building your script in the right-hand window.
Table . Control Script Steps
USE | TO |
---|---|
Perform Script | Run another script, specified by options, within a script |
Pause/Resume Script | Pause (or resume) script, based on option chosen |
Exit Script | Exit the current script |
Halt Script | Stop current script (allowing for user inputs) |
If | Perform script if calculation is True |
Else | Perform another step if calculation is False |
End If | Mark end of script started by If script |
Loop | Repeat a set of steps |
Exit Loop If | Exit a loop if a calculation is True |
End Loop | Mark end of Loop script |
Allow User Abort | Let user stop (or not stop) script, based on option chosen |
Set Error Capture | Move (or not move) error messages to Status function, based on option chosen |
Table . Navigation Script Steps
USE | TO |
---|---|
Go to Layout | Move to layout specified by option |
Go to Record, Request, Page | Move to record, request, or page specified by option |
Go to Related Record | Move to record in related database specified by option |
Go to Portal Row | Move to portal row or field in portal row specified by option |
Go to Field | Move to field specified by option |
Go to Next Field | Move to next field in current layout |
Go to Previous Field | Move to previous field in current layout |
Enter Browse Mode | Switch to Browse mode with option to pause |
Enter Find Mode | Switch to Find mode |
Enter Preview Mode | Switch to Preview mode |
Table . Sort, Find, Print Script Steps
USE | TO |
---|---|
Sort | Sort records in found set based on current sort settings |
Unsort | Restore records to unsorted state |
Show All Records | Find all records in database |
Show Omitted | Find records not in found set |
Omit Record | Omit current record from found set |
Omit Multiple | Omit number of records from found set, starting with current record |
Perform Find | Find records matching current find request |
Modify Last Find | Change find request |
Page Setup/Print Setup | Open Page Setup dialog box (Mac); Open Print Setup dialog box (Windows) |
Print current record |
Table . Editing Script Steps
USE | TO |
---|---|
Undo | Undo last action |
Cut | Delete contents of field specified by option and place in Clipboard |
Copy | Copy contents of field specified by option and place in Clipboard |
Paste | Paste Clipboard contents into field specified by option |
Clear | Delete contents of field specified by option |
Select All | Select all items in layout |
Perform Find/Replace | Find or replace data based on options selected in Specify Find/Replace dialog box |
Table . Field Script Steps
USE | TO |
---|---|
Set Field | Replace contents of field specified by option with results of calculation, also specified by option |
Insert Text | Paste text specified by option into field specified by option |
Insert Calculated Result | Paste result of calculation specified by option into field specified by option |
Insert from Index | Paste contents of field specified by option |
Insert from Last Record | Paste contents of field, specified by option, from last active record |
Insert Current Date | Paste current system date into field specified by option |
Insert Current Time | Paste current system time into field specified by option |
Insert Current User Name | Paste current user name into field specified by option |
Insert Picture | Paste graphic into active container field |
Insert QuickTime/Insert Movie | Paste movie into active container field |
Insert Object | Insert embedded or linked object into container field (Windows only) |
Update Link | Update an OLE link in container field (Windows only) |
Table . Record Script Steps
USE | TO |
---|---|
New Record/Request | Add a new record or find request |
Duplicate Record/Request | Duplicate a record or find request |
Delete Record/Request | Delete current record or find request |
Delete Portal Row | Delete current portal row |
Revert Record/Request | Revert current record or find request to state before most recent action |
Exit Record/Request | Leave current record or find request, with no field selected |
Copy Record | Copy contents of current record to Clipboard |
Copy All Records | Copy contents of records in found set to Clipboard |
Delete All Records | Delete all records in found set |
Replace | Replace contents of field, specified by options, within current record |
Relookup | Update current record from lookup value |
Import Records | Import records, specified by options, to current field |
Export Records | Export records, specified by options, to another database format |
Table . Window Script Steps
USE | TO |
---|---|
Freeze Window | Hide action from user |
Refresh Window | Update screen |
Scroll Window | Scroll window to position specified by options |
Toggle Window | Toggle window size to choice specified by options |
Toggle Status Area | Toggle status area to choice specified by options |
Toggle Text Ruler | Show or hide text ruler based on options |
Set Zoom Level | Change window’s zoom based on options |
View As | Show single record or list of records, based on options |
Table . File Script Steps
USE | TO |
---|---|
New | Create new database |
Open | Open a database specified by options |
Close | Close a database specified by options |
Change Password | Change existing password |
Set Multi-User | Allow or block network access to current file |
Set Use System Formats | Use date, time, number formats of current file or use system formats |
Save Copy As | Save a database specified by options |
Recover | Recover a damaged database specified by options |
Table . Spelling Script Steps
USE | TO |
---|---|
Check Selection | Check spelling in field specified by options |
Check Record | Check spelling in record specified by options |
Check Found Set | Check spelling in all records within found set |
Correct Word | Display Spelling dialog box so user can correct misspelled word |
Spelling Options | Display Spelling Options dialog box |
Set Dictionaries | Display Select Dictionaries dialog box |
Edit User Dictionary | Display Edit User Dictionary dialog box |
Table . Open Menu Item Script Steps
USE | TO |
---|---|
Open Application Preferences | Display Application Preferences dialog box |
Open Document Preferences | Display Document Preferences dialog box |
Open Define Fields | Display Define Fields dialog box |
Open Define Relationships | Display Define Relationships dialog box |
Open Define Value Lists | Display Define Value Lists dialog box |
Open Find/Replace | Display a Find/Replace dialog box when user is not allowed access to menus |
Open Help | Display FileMaker’s Help contents window |
Open Hosts | Open the Hosts dialog box to select and open shared database over network |
Open ScriptMaker | Display Define Scripts dialog box and halt current script |
Open Sharing | Display File Sharing dialog box |
Table . Miscellaneous Script Steps
USE | TO |
---|---|
Show Message | Display specified text message for user |
Show Custom Dialog | Define a custom dialog box with user input fields |
Allow Toolbars | Hide or show FileMaker’s toolbars and related menu items |
Beep | Play system alert sound |
Speak | Generate speech from text specified by options (Mac only) |
Dial Phone | Dial phone number specified by options |
Open URL | Open a Web URL specified by options |
Send Mail | Send email with To, Cc, Subject, and Message fields specified by options (not available in Mac OS X) |
Set Next Serial Value | Update next value in an auto-enter serial number value field |
Send Apple Event | Start Apple Event specified by options (Mac only) |
Perform AppleScript | Run AppleScript specified by options (Mac only) |
Send DDE Execute | Send a Dynamic Data Exchange command to application specified by options (Windows only) |
Execute SQL | Execute any SQL statement to control interaction with ODBC data source |
Send Message | Start or print using another application specified by options (Windows only) |
Comment | Add explanatory note to a script |
Flush Cache to Disk | Save FileMaker internal cache to disk |
Exit Application | Close all files and exit FileMaker (Windows only) |
Quit Application | Close all files and quit FileMaker (Mac only) |
3.143.4.181