Home > Reference > Functions reference > Get functions

Get functions

 

Get functions monitor errors in scripts, or capture information about file status or actions 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 calculation field, the time will update only when a new record is created. If the calculation has other fields in it but the calculation result still returns the current time, the stored calculation result will update only when those other fields have been modified in the current record. If either of these calculations are unstored, 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.

Note  For information on how functions evaluate differently on the host versus the client, search the FileMaker Knowledge Base available at http://help.filemaker.com.

Click a function name for details.

 

This function	Returns
Get(AccountExtendedPrivileges)	A list of keywords, based on the account used to open the file, for the enabled extended privileges.
Get(AccountName)	The authenticated account name being used by the file’s current user.
Get(AccountPrivilegeSetName)	The privilege set name being used by the account used to open the file.
Get(ActiveFieldContents)	The contents of the field that has the focus.
Get(ActiveFieldName)	The name of the field that has the focus.
Get(ActiveFieldTableName)	The name of the table that contains the field that has the focus.
Get(ActiveLayoutObjectName)	The name of the layout object that has the focus in the calculation's current window.
Get(ActiveModifierKeys)	A number for the keyboard modifier keys being pressed.
Get(ActivePortalRowNumber)	The number of the portal row that has the focus.
Get(ActiveRepetitionNumber)	A number representing the repetition that has the focus in a repeating field.
Get(ActiveSelectionSize)	A number representing how many characters are selected.
Get(ActiveSelectionStart)	A number representing the starting character of the selected text.
Get(AllowAbortState)	1 (true) if the Allow User Abort script step is on; otherwise, returns 0 (false).
Get(AllowFormattingBarState)	1 (true) if the formatting bar is allowed to be visible; otherwise, returns 0 (false).
Get(ApplicationArchitecture)	The current application architecture.
Get(ApplicationLanguage)	Text representing the current application language.
Get(ApplicationVersion)	Text representing the FileMaker product and version.
Get(CalculationRepetitionNumber)	A number representing the repetition of the calculation field being calculated.
Get(ConnectionAttributes)	The name of the current file’s host, and the certificate authority that issued the SSL certificate used to secure the connection.
Get(ConnectionState)	A number representing the security state of the network connection for the current file.
Get(CurrentDate)	The current date according to the system calendar.
Get(CurrentExtendedPrivileges)	A list of keywords, based on the account used to evaluate this calculation, for the enabled extended privileges.
Get(CurrentHostTimestamp)	The host's current date and time (to the nearest second) according to the system clock.
Get(CurrentPrivilegeSetName)	The name of the privilege set being used to evaluate this calculation in the file.
Get(CurrentTime)	The current time (to the nearest second) according to the system clock.
Get(CurrentTimestamp)	The current date and time (to the nearest second) according to the system clock.
Get(CurrentTimeUTCMilliseconds)	The current time in Coordinated Universal Time (UTC) to the nearest millisecond.
Get(CustomMenuSetName)	The name of the active custom menu set.
Get(DesktopPath)	The path to the desktop folder for the current user.
Get(Device)	A number representing the type of computer or mobile device running the FileMaker product.
Get(DocumentsPath)	The path to the Documents folder for the current user.
Get(DocumentsPathListing)	A list of all files and folders in the Documents folder returned by the Get(DocumentsPath) function.
Get(EncryptionState)	A value representing the file’s current encryption state.
Get(ErrorCaptureState)	1 (true) if the Set Error Capture script step is on; otherwise, returns 0 (false).
Get(FileMakerPath)	The path to the folder of the currently running copy of FileMaker Pro.
Get(FileName)	The name of the currently active file, without the filename extension.
Get(FilePath)	The full path of the location of the currently active file.
Get(FileSize)	The size, in bytes, of the currently active file.
Get(FoundCount)	The number of records in the current found set.
Get(HighContrastColor)	The current high contrast default color scheme name.
Get(HighContrastState)	1 (true) if high contrast is available and active; otherwise, returns 0 (false).
Get(HostApplicationVersion)	The version of FileMaker Pro or FileMaker Server running on the computer hosting the current file.
Get(HostIPAddress)	The IP address of the host computer for the current file.
Get(HostName)	The registered name of the computer that is hosting the file.
Get(InstalledFMPlugins)	The name, version number, and enabled state of installed plug-ins.
Get(LastError)	A number for the error that occured in the execution of the most recently executed script step.
Get(LastMessageChoice)	A number corresponding to the button clicked in an alert message displayed by the Show Custom Dialog script step.
Get(LastODBCError)	Text that shows the error state published by ODBC standards, based on ISO/IEF standards.
Get(LayoutAccess)	A number based on record access privileges available through the current layout.
Get(LayoutCount)	The total number of layouts in the file.
Get(LayoutName)	The name of the layout currently being displayed.
Get(LayoutNumber)	The number of the layout (specified in the Manage Layouts dialog box) currently displayed.
Get(LayoutTableName)	The name of the table displaying records in the current layout.
Get(LayoutViewState)	A number representing the currently active file view.
Get(MenubarState)	A number for the current menu bar state.
Get(ModifiedFields)	A list of fields that have been modified in the current record of the current table.
Get(MultiUserState)	A number representing the level of sharing for the file using FileMaker Network.
Get(NetworkProtocol)	The name of the network protocol (TCP/IP) that FileMaker is using on this machine.
Get(NetworkType)	A number representing the type of network being used to access the current file.
Get(PageNumber)	A number representing the current page being printed or previewed.
Get(PersistentID)	Text representing a unique identifier of the computer or device running FileMaker.
Get(PreferencesPath)	The path to the preferences and default options folder for the current user.
Get(PrinterName)	Text identifying the default printer name.
Get(QuickFindText)	The text that is stored in the quick find box.
Get(RecordAccess)	A number based on the current record’s access privileges, assigned through the Custom Record Privileges dialog box.
Get(RecordID)	The unique ID number of the current record.
Get(RecordModificationCount)	The total number of times changes to the current record have been committed.
Get(RecordNumber)	The number of the current record in the current found set.
Get(RecordOpenCount)	The total number of open records in the current found set that haven’t been saved.
Get(RecordOpenState)	A number representing the state of the current record.
Get(RequestCount)	The total number of find requests defined for the current table.
Get(RequestOmitState)	1 (true) if Omit is selected in the current find request; otherwise, returns 0 (false).
Get(ScreenDepth)	The number of bits needed to represent the color or shade of gray of a pixel on the main screen.
Get(ScreenHeight)	The height, in points, of the screen in which the window of the current file is open.
Get(ScreenScaleFactor)	The scale factor of the screen in which the current file is open.
Get(ScreenWidth)	The width, in points, of the screen in which the window of the current file is open.
Get(ScriptAnimationState)	1 (true) if animations are enabled for the current script; otherwise, returns 0 (false).
Get(ScriptName)	The name of the script that is currently running or is paused.
Get(ScriptParameter)	The script parameter passed into the current script.
Get(ScriptResult)	The script result from a performed sub-script.
Get(SortState)	A value representing the current sort state.
Get(StatusAreaState)	A number representing the current status toolbar state.
Get(SystemDrive)	The drive letter (Windows) or volume name (OS X) where the running operating system is located.
Get(SystemIPAddress)	A list of the IP addresses of all computers connected to an active NIC (Network Interface Controller) card.
Get(SystemLanguage)	The language currently set on the current system.
Get(SystemNICAddress)	The hardware addresses of all NIC (Network Interface Controller) cards connected to the computer.
Get(SystemPlatform)	A number representing the current platform.
Get(SystemVersion)	The version of the current operating system.
Get(TemporaryPath)	The path to the temporary folder FileMaker Pro uses for the current user, or the path FileMaker Server uses on the system.
Get(TextRulerVisible)	1 (true) if the text ruler is displayed; otherwise, returns 0 (false).
Get(TotalRecordCount)	The total number of records in the current table.
Get(TouchKeyboardState)	1 (true) if the touch keyboard is set to display automatically when needed; otherwise, returns 0 (false).
Get(TriggerCurrentPanel)	The index and object name of the panel to switch from when the OnPanelSwitch script trigger is activated.
Get(TriggerExternalEvent)	A number representing the event that activated an OnExternalCommandReceived script trigger.
Get(TriggerGestureInfo)	Details about the gesture that activated an OnGestureTap script trigger.
Get(TriggerKeystroke)	The characters that activated an OnObjectKeystroke or OnLayoutKeystroke script trigger.
Get(TriggerModifierKeys)	The state of the keyboard modifier keys when an OnObjectKeystroke or OnLayoutKeystroke script trigger was activated.
Get(TriggerTargetPanel)	The index and the object name of the panel to switch to when the OnPanelSwitch script trigger is activated.
Get(UserCount)	The number of clients currently accessing the file.
Get(UserName)	The name of the FileMaker user, as specified in the General tab of the Preferences dialog box.
Get(UseSystemFormatsState)	1 (true) if Use System Formats in the Format menu is on; otherwise, returns 0 (false).
Get(UUID)	Text representing a Universally Unique Identifier (UUID).
Get(WindowContentHeight)	The height, in points, of the window content area.
Get(WindowContentWidth)	The width, in points, of the window content area.
Get(WindowDesktopHeight)	The height, in points, of the desktop space.
Get(WindowDesktopWidth)	The width, in points, of the desktop space.
Get(WindowHeight)	The height, in points, of the window on which the script is acting.
Get(WindowLeft)	The horizontal distance, in points, of the outer edge of the window on which the script is acting, relative to the left-most edge of the screen.
Get(WindowMode)	A number representing the mode the FileMaker product is in when the function is evaluated.
Get(WindowName)	The name of the window on which the script is acting.
Get(WindowOrientation)	A value representing the orientation of the window on which the script is acting.
Get(WindowStyle)	The style of the window on which the script is acting.
Get(WindowTop)	The vertical distance, in points, of the outer edge of the window on which the script is acting, relative to the bottom edge of the menu bar.
Get(WindowVisible)	1 (true) if the window is visible; returns 0 (false) if the window is hidden using Hide Window.
Get(WindowWidth)	The width, in points, of the window on which the script is acting.
Get(WindowZoomLevel)	The zoom percentage of the current window.

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]

Related topics 

About functions

About formulas