Function of the Day

Get(SystemAppearance) Returns the name of the current operating system appearance.   Direct Link

Get(StatusAreaState) Returns a number representing the current status toolbar state.   Direct Link

Get(SortState) Returns a value representing the current sort state.   Direct Link

Get(SessionIdentifier) Returns the value set by the Set Session Identifier script step.   Direct Link

Get(ScriptResult) Returns the script result from a performed sub-script.   Direct Link

Get(ScriptParameter) Returns the script parameter passed into the current script.   Direct Link

Get(ScriptName) Returns the name of the script that is currently running or is paused.   Direct Link

Get(ScriptAnimationState) Returns 1 (true) if animations are enabled for the current script; otherwise, returns 0 (false).   Direct Link

Get(ScreenWidth) Returns the width, in points, of the screen in which the window of the current file is open.   Direct Link

Get(ScreenScaleFactor) Returns the scale factor of the screen in which the current file is open.   Direct Link

Get(ScreenHeight) Returns the height, in points, of the screen in which the window of the current file is open.   Direct Link

Get(ScreenDepth) Returns the number of bits needed to represent the color or shade of gray of a pixel on the main screen.   Direct Link

Get(RequestOmitState) Returns 1 (true) if Omit is selected in the current find request; otherwise, returns 0 (false).   Direct Link

Get(RequestCount) Returns the total number of find requests defined for the current table.   Direct Link

Get(RegionMonitorEvents) Returns events that caused the script specified in the Configure Region Monitor Script script step to run.   Direct Link

Get(RecordOpenState) Returns a number representing the state of the current record.   Direct Link

Get(RecordOpenCount) Returns the total number of open records in the current found set that haven‚Äôt been saved.   Direct Link

Get(RecordNumber) Returns a number representing a record‚Äôs position in the current found set.   Direct Link

Get(RecordModificationCount) Returns the total number of times changes to the current record have been committed.   Direct Link

Get(RecordID) Returns the unique ID number of the current record.   Direct Link

Get(RecordAccess) Returns a number representing the current record's access privileges, assigned through the Custom Record Privileges dialog box.   Direct Link

Get(QuickFindText) Returns the text that is stored in the quick find box.   Direct Link

Get(PrinterName) Returns text identifying the default printer name.   Direct Link

Get(PreferencesPath) Returns the path to the preferences and default options folder for the current user.   Direct Link

Get(PersistentID) Returns text representing a unique identifier of the computer or device running a FileMaker client.   Direct Link

Get(PageNumber) Returns a number representing the current page being printed or previewed.   Direct Link

Get(PageCount) Returns a number representing the total page count in the current print job while it‚Äôs printing.   Direct Link

Get(OpenDataFileInfo) Returns the file ID and path of each open data file.   Direct Link

Get(NetworkType) In FileMaker Go, returns a number representing the type of network being used to access the current file.   Direct Link

Get(NetworkProtocol) Returns the name of the network protocol (TCP/IP) that a FileMaker client is using on this machine.   Direct Link

Get(MultiUserState) Returns a number representing the level of sharing for the file using FileMaker Network.   Direct Link

Get(ModifiedFields) Returns a list of fields that have been modified in the current record of the current table.   Direct Link

Get(MenubarState) Returns a number representing the current menu bar state.   Direct Link

Get(LayoutViewState) Returns a number representing the currently active file view.   Direct Link

Get(LayoutTableName) Returns the name of the table occurrence displaying records in the current layout.   Direct Link

Get(LayoutNumber) Returns the number of the layout (specified in the Manage Layouts dialog box) currently displayed.   Direct Link

Get(LayoutName) Returns the name of the layout currently being displayed.   Direct Link

Get(LayoutCount) Returns the total number of layouts in the file.   Direct Link

Get(LayoutAccess) Returns a number based on record access privileges available through the current layout.   Direct Link

Get(LastMessageChoice) Returns a number corresponding to the button clicked in an alert message displayed by the Show Custom Dialog script step.   Direct Link

Get(LastExternalErrorDetail) Returns text about errors external to the FileMaker Platform that are returned by Get(LastError).   Direct Link

Get(LastError) Returns a number for the error that occurred in the execution of the most recently executed script step.   Direct Link

Get(InstalledFMPluginsAsJSON) Returns a JSON object with the attributes of installed plug-ins.   Direct Link

Get(InstalledFMPlugins) Returns the name, version number, and enabled state of installed plug-ins.   Direct Link

Get(HostName) Returns the name of the current host.   Direct Link

Get(HostIPAddress) Returns the IP address of the host computer for the current file.   Direct Link

Get(HostApplicationVersion) Returns the FileMaker host‚Äôs product name and version.   Direct Link

Get(HighContrastState) Returns 1 (true) if high contrast is available and active; otherwise, returns 0 (false).   Direct Link

Get(FoundCount) Returns the number of records in the current found set.   Direct Link

Get(FileSize) Returns the size, in bytes, of the currently active file.   Direct Link

Get(FilePath) Returns the full path of the location of the currently active file.   Direct Link

Get(FileName) Returns the name of the currently active file, without the filename extension.   Direct Link

Get(FileMakerPath) Returns the path to the folder of the currently running copy of a FileMaker product.   Direct Link

Get(FileLocaleElements) Returns a JSON object with information about the current file's locale.   Direct Link

Get(ErrorCaptureState) Returns 1 (true) if the Set Error Capture script step is on; otherwise, returns 0 (false).   Direct Link

Get(EncryptionState) Returns a value representing the file's current encryption state.   Direct Link

Get(DocumentsPathListing) Returns a list of all files and folders in the Documents folder returned by the Get(DocumentsPath) function.   Direct Link

Get(DocumentsPath) Returns the path to the Documents folder for the current user.   Direct Link

Get(Device) Returns a number representing the type of computer or mobile device running the FileMaker product.   Direct Link

Get(DesktopPath) Returns the path to the desktop folder for the current user.   Direct Link

Get(CustomMenuSetName) Returns the name of the active custom menu set.   Direct Link

Get(CurrentTimeUTCMilliseconds) Returns the current time in Coordinated Universal Time (UTC) to the nearest millisecond.   Direct Link

Get(CurrentTimestamp) Returns the current date and time (to the nearest second) according to the system clock.   Direct Link

Get(CurrentTime) Returns the current time (to the nearest second) according to the system clock.   Direct Link

Get(CurrentPrivilegeSetName) Returns the name of the privilege set being used to evaluate this calculation in the file.   Direct Link

Get(CurrentHostTimestamp) Returns the host's current date and time (to the nearest second) according to the system clock.   Direct Link

Get(CurrentExtendedPrivileges) Returns a list of keywords, based on the account used to evaluate this calculation, for the enabled extended privileges.   Direct Link

Get(CurrentDate) Returns the current date according to the system calendar.   Direct Link

Get(ConnectionState) Returns a number representing the security state of the network connection for the current file.   Direct Link

Get(ConnectionAttributes) Returns the name of the current file's host, and the certificate authority that issued the SSL certificate used to secure the connection.   Direct Link

Get(CalculationRepetitionNumber) Returns a number representing the repetition of the calculation field being calculated.   Direct Link

Get(ApplicationVersion) Returns the FileMaker client‚Äôs product name and version.   Direct Link

Get(ApplicationLanguage) Returns text representing the current application language.   Direct Link

Get(ApplicationArchitecture) Returns the current application architecture.   Direct Link

Get(AllowFormattingBarState) Returns 1 (true) if the formatting bar is allowed to be visible; otherwise, returns 0 (false).   Direct Link

Get(AllowAbortState) Returns 1 (true) if the Allow User Abort script step is on; otherwise, returns 0 (false).   Direct Link

Get(ActiveSelectionStart) Returns a number representing the starting character of the selected text.   Direct Link

Get(ActiveSelectionSize) Returns a number representing how many characters are selected.   Direct Link

Get(ActiveRepetitionNumber) Returns a number representing the repetition that has the focus in a repeating field.   Direct Link

Get(ActiveRecordNumber) Returns a number representing the record that has focus in the current found set.   Direct Link

Get(ActivePortalRowNumber) Returns a number representing the portal row that has the focus.   Direct Link

Get(ActiveModifierKeys) Returns a number for the keyboard modifier keys being pressed.   Direct Link

Get(ActiveLayoutObjectName) Returns the name of the layout object that has the focus in the calculation's current window.   Direct Link

Get(ActiveFieldTableName) Returns the name of the table occurrence that contains the field that has the focus.   Direct Link

Get(ActiveFieldName) Returns the name of the field that has the focus.   Direct Link

Get(ActiveFieldContents) Returns the contents of the field that has the focus.   Direct Link

Get(AccountType) Returns the current account's authentication type.   Direct Link

Get(AccountPrivilegeSetName) Returns the privilege set name being used by the account used to open the file.   Direct Link

Get(AccountName) Returns the authenticated account name being used by the file's current user.   Direct Link

Get(AccountGroupName) Returns the current account‚Äôs group name.   Direct Link

Get(AccountExtendedPrivileges) Returns a list of keywords, based on the account used to open the file, for the enabled extended privileges.   Direct Link

PV Returns the present value (PV) of a series of equal payments made at regular intervals, assuming a fixed interest rate per interval.   Direct Link

PMT Returns the payment (PMT) required by the term, interest rate, and principal.   Direct Link

NPV Returns the net present value (NPV) of a series of unequal payments made at regular intervals, assuming a fixed interest rate per interval.   Direct Link

FV Returns the future value (FV) of an initial investment, based on a constant interest rate and payment amount for the number of periods in months.   Direct Link

WindowNames Returns a list of the names of windows that are currently open.   Direct Link

ValueListNames Returns a list of the names of all value lists in fileName.   Direct Link

ValueListItems Returns a list of the values in a value list.   Direct Link

ValueListIDs Returns a list of all value list IDs in fileName.   Direct Link

TableNames Returns a list of all table occurrences in the relationships graph for fileName.   Direct Link