Functions Reference

FILEMAKER FUNCTIONS REFERENCE 136
Examples
In the following example, the Find Customers script returns the results of a find request when it is
called from the Do Reports script. Script Find Customers uses the optional script result of the Exit
Script script step. Script Do Reports then uses
Get(ScriptResult) to determine what other
script steps should be performed based on the returned result stored in
Get(ScriptResult).
Find Customers
Set Error Capture [On]
Perform Find [Restore]
New Record/Request
Exit Script [Result: Get(FoundCount) < 10]
Do Reports
Perform Script [Find Customers]
If [Get(ScriptResult) = 0]
Show Custom Dialog [“You have created 10 records already.”]
End If
Related topics
Contents
Functions reference (alphabetical list)
Get(SortState)
Purpose
Returns a value representing the current sort state.
Format
Get(SortState)
Parameters
None
Data type returned
number
Originated in
FileMaker Pro 6.0 or earlier
Description
Returns:
• 0 if the records in the active table are not sorted
• 1 if the records in the active table are sorted
• 2 if the records in the active table are partially sorted (semi-sorted)