Functions Reference

FILEMAKER FUNCTIONS REFERENCE 71
Get functions example
This script uses the function Get(CurrentDate) to check each record in the found set to see if an
account is past due. If an account is past due, the script shows a message and prompts the user to
click a button labeled Ignore, Send Letter, or Send Mail (set up through the Show Custom Dialog
script step). The script captures the user's response using
Get(LastMessageChoice). Then,
based on the user's response, the script performs an action: it cancels the rest of the script, prints a
"payment is late" letter, or sends email to the associated account.
Go to Layout ["LayoutName"]
Go to Record/Request/Page [First]
Loop
If [DatabaseName::Date < Get(CurrentDate) - 30]
Show Custom Dialog ["30 or more days late"]
If [Get(LastMessageChoice) = 1]
Halt Script
Else If [Get(LastMessageChoice) = 2]
Go to Layout ["Late Notice"]
Print []
Else
Send Mail [To: DatabaseName::Client; Subject: "Late Notice";
Message: "Your account is past due."]
End If
End If
Go to Record/Request/Page [Exit after last, Next]
End Loop
Go to Layout [original layout]
Get(AccountExtendedPrivileges)
Purpose
Returns a list of keywords for the enabled extended privileges, separated by carriage returns. The
list that is returned is based on the account used to open the database file.
Get(WindowVisible) A Boolean value representing whether or not the current window
is visible.
Get(WindowWidth) A number representing the width, in pixels, of the current window
of the file in which the calculation is defined.
Get(WindowZoomLevel) The zoom level of the current window.
This function Returns