Appendix C. Script Commands

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.

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.

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

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)

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.143.4.181