Get functionsUse Get in scripts for error checking and prevention, or to capture information about the status of a or elements in it, or an action being performed.Many Get functions return information that changes on a regular basis. For example, when the Get(CurrentTime) function is placed in a stored , the time will only update when a new record is created. If the calculation has other fields in it, but the calculation result still returns the current time, then the stored calculation result will only update when those other fields have been modified in the current record. If either of these calculations are , the time will update as needed. For performance reasons, making a calculation field unstored is not always the best idea. Get functions are best used in a script where the status information from a Get function is up to date at the moment that the calculation is run.To access the list of Get functions, in the Specify Calculation dialog box, choose View all functions by type or View Get functions. When you choose View all functions by name, you see only Get(flag).Note For information on how functions evaluate differently on the host versus the client, search the FileMaker Knowledge Base available at .
A list of keywords for the enabled , separated by carriage returns. The list that is returned is based on the account used to open the database file. The authenticated account name being used for the active database file. The name of the that is being used by the account used to open the database file. The contents of the that has the focus. The name of the that contains the active field (the field that has the focus). A number representing the keyboard modifier keys (for example, Shift) that are being pressed. The number of the row containing the focus. A number representing the active repetition of a (the repetition that has the focus). A value representing the current state of Allow user abort script step. A number representing the repetition of the calculation field that is currently being calculated. A number representing the security state of the network connection for the current file. A list of keywords for the enabled extended privileges of the account that is being used to evaluate the calculation. The host's current date and time (to the nearest second) according to the system clock. The name of the privilege set that is being used to evaluate this calculation in the database. The current date and time (to the nearest second) according to the system clock. A list of all the files and folders in the Documents folder returned by the Get(DocumentsPath) function. A Boolean value representing the state of Error capture script step. The path to the folder of the currently running copy of FileMaker Pro. The name of the current high contrast default color scheme if Use High Contrast is selected in the Windows operating system Accessibility Options dialog box. A Boolean value representing the state of the Use High Contrast checkbox on the Accessibility Options dialog box. The version of FileMaker Pro or FileMaker Server running on the computer that is hosting the current database. The registered name of the computer that is the database file. The display name, version number (if available), and enabled state of installed . A number representing the error, if any, in the execution of the most recently executed script step. A number corresponding to the button clicked in an alert message displayed by the Show Custom Dialog script step. A string that shows the error state published by standards, based on ISO/IEF standards. A number corresponding to the layout assigned through the Manage Security dialog box. The total number of in the database file. The number of the layout currently displayed, according to the list in the Manage Layouts dialog box. A number representing the current multi-user state of the database file. The name of the that FileMaker Pro is using on this machine. Text representing a unique identifier of the computer or device on which FileMaker is running. The total number of times changes to the current record have been committed. The total number of open records in the current found set that haven’t yet been saved. A Boolean value representing the state of the Omit checkbox in Find mode. The number of bits needed to represent the color or shade of gray of a pixel on the main screen. The number of pixels displayed vertically on the screen in which the window of the current file is open. The number of pixels displayed horizontally on the screen in which the window of the current file is open. A number representing whether the is hidden, visible, visible and locked, or hidden and locked. The drive letter (Windows) or the volume name (Mac OS) where the currently running operating system is located. The of all the machines connected to a NIC (Network Interface Controller) card. The hardware addresses of all the Network Interface Controller cards connected to the machine. The version of the operating system of the machine on which the function is executed. The path to the current user’s temporary folder used by FileMaker Pro. The index number and object name of the tab panel to be switched from when the OnTabSwitch is activated. The state of the keyboard modifier keys as they were when the script trigger was activated. The index number and object name of the tab panel to be switched to when the OnTabSwitch script trigger is activated. The name of the FileMaker Pro user, as specified in the General tab of the Preferences dialog box. A Boolean value representing the state of the Use System Formats menu command. A number representing the height, in pixels, of the current window of the file in which the calculation is defined. A number representing the horizontal distance, in pixels, of the outer edge of the current window relative to the left-most edge of the screen. A number representing whether FileMaker Pro is in , , , or printing when the function is evaluated. A number indicating whether the top-most open window is a document window, a floating document window, or a dialog window. A number representing the vertical distance, in pixels, of the outer edge of the current window relative to the bottom edge of the menu bar. A number representing the width, in pixels, of the current window of the file in which the calculation is defined. 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.