Function of the Day

LayoutObjectUUID Returns the Universally Unique Identifier (UUID) of the layout object in which the calculation is defined.   Direct Link

GetModelAttributes Returns metadata in JSON format about a named model that's currently loaded.   Direct Link

GetLayoutObjectOwnerInfo Returns a JSON object with ownership information about a layout object.   Direct Link

GetLayoutObjectAttribute Returns the specified attributes of the layout object given by the objectName currently active in the calculation.   Direct Link

GetFieldName Returns the fully qualified name of a field reference.   Direct Link

GetAddonInfo Returns a JSON object with information about an add-on.   Direct Link

ConvertToFileMakerPath Converts a path in a standard format to FileMaker format.   Direct Link

ConvertFromFileMakerPath Converts a path in FileMaker format to a standard format.   Direct Link

ComputeModel Returns a JSON object containing the result of the Core ML model evaluation.   Direct Link

While Repeats logic while the condition is true, then returns the result.   Direct Link

SetRecursion Sets the maximum number of iterations for recursion and loops within an expression.   Direct Link

Self Returns the content of the object in which the calculation is defined.   Direct Link

LookupNext Returns the next lower or higher value in sourceField when there isn't a matching related value.   Direct Link

Lookup Returns the value specified in sourceField, using the relationships in the relationships graph.   Direct Link

Let Sets a variable or variables to the result of the specified expression(s) for the duration of the calculation, or until the script exits or the file is closed.   Direct Link

IsValidExpression Returns 1 (true) if an expression syntax is correct; otherwise, returns 0 (false).   Direct Link

IsValid Returns 0 (false) if the data is invalid; otherwise, returns 1 (true).   Direct Link

IsEmpty Returns 1 (true) if a field is empty or if other errors occur; otherwise, returns 0 (false).   Direct Link

If Returns result1 if the test is true; returns result2 if the test is false.   Direct Link

GetSummary Returns the value of summaryField for the current range of records when the file is sorted by breakField.   Direct Link

GetNthRecord Returns the contents of a field from the specified record number.   Direct Link

GetField Evaluates fieldName and returns the contents of the specified field.   Direct Link

GetAsBoolean Returns 1 (true) if data converts to a non-zero numeric value or a container field holds data; otherwise, returns 0 (false).   Direct Link

ExecuteSQL Executes an SQL query statement for the specified table occurrence in a FileMaker Pro file.   Direct Link

EvaluationError Returns an error code, if any, from an expression.   Direct Link

Evaluate Evaluates an expression as a calculation.   Direct Link

Choose Returns one result value, according to the integer value of a test.   Direct Link

Case Returns one of several possible results based on a series of tests.   Direct Link

JSONSetElement Adds or modifies an element in JSON data specified by an object name, an array index, or a path.   Direct Link

JSONListValues Lists the values in JSON data for an element specified by an object name, an array index, or a path.   Direct Link

JSONListKeys Lists the object names (keys) or array indexes in JSON data for an element specified by an object name, an array index, or a path.   Direct Link

JSONGetElement Queries JSON data for an element specified by an object name, an array index, or a path.   Direct Link

JSONFormatElements Formats elements in JSON data to make them easier to read.   Direct Link

JSONDeleteElement Deletes a JSON data element specified by an object name, an array index, or a path.   Direct Link

YearName Returns the Japanese year name of a date, in the specified format.   Direct Link

RomanZenkaku Converts hankaku alphanumeric and symbols to zenkaku alphanumeric and symbols.   Direct Link

RomanHankaku Converts zenkaku alphanumeric and symbols to hankaku alphanumeric and symbols.   Direct Link

NumToJText Converts arabic numerals to Japanese text.   Direct Link

MonthNameJ Returns the name of the month of a date in Japanese.   Direct Link

Katakana Converts hiragana to zenkaku katakana.   Direct Link

KanjiNumeral Converts arabic numerals to kanji numerals.   Direct Link

KanaZenkaku Converts hankaku katakana to zenkaku katakana.   Direct Link

KanaHankaku Converts zenkaku katakana to hankaku katakana.   Direct Link

Hiragana Converts katakana (hankaku and zenkaku) in text to hiragana.   Direct Link

Furigana Converts Japanese text to hiragana, katakana, or roman text.   Direct Link

DayNameJ Returns text in Japanese that is the full name of the weekday for a date.   Direct Link

Get(WindowZoomLevel) Returns the zoom percentage of the current window.   Direct Link

Get(WindowWidth) Returns the width, in points, of the window on which the script is acting.   Direct Link

Get(WindowVisible) Returns 1 (true) if the window is visible; returns 0 (false) if the window is hidden using Hide Window.   Direct Link

Get(WindowTop) Returns the vertical distance, in points, of the outer edge of the window on which the script is acting, relative to the top edge of the screen in Windows, or the bottom edge of the menu bar in macOS.   Direct Link

Get(WindowStyle) Returns the style of the window on which the script is acting.   Direct Link

Get(WindowOrientation) Returns a value representing the orientation of the window on which the script is acting.   Direct Link

Get(WindowName) Returns the name of the window on which the script is acting.   Direct Link

Get(WindowMode) Returns a number representing the mode the FileMaker product is in when the function is evaluated.   Direct Link

Get(WindowLeft) Returns the horizontal distance, in points, of the outer edge of the window on which the script is acting, relative to the leftmost edge of the screen.   Direct Link

Get(WindowHeight) Returns the height, in points, of the window on which the script is acting.   Direct Link

Get(WindowDesktopWidth) Returns the width, in points, of the desktop space.   Direct Link

Get(WindowDesktopHeight) Returns the height, in points, of the desktop space.   Direct Link

Get(WindowContentWidth) Returns the width, in points, of the window content area.   Direct Link

Get(WindowContentHeight) Returns the height, in points, of the window content area.   Direct Link

Get(UUIDNumber) Returns a number representing a large Universally Unique Identifier (UUID) value.   Direct Link

Get(UUID) Returns text representing a Universally Unique Identifier (UUID).   Direct Link

Get(UserCount) Returns the number of clients currently accessing the file.   Direct Link

Get(TriggerTargetPanel) Returns the index and the object name of the panel to switch to when the OnPanelSwitch script trigger is activated.   Direct Link

Get(TriggerModifierKeys) Returns the state of the keyboard modifier keys when an OnObjectKeystroke or OnLayoutKeystroke script trigger was activated.   Direct Link

Get(TriggerKeystroke) Returns the characters that activated an OnObjectKeystroke or OnLayoutKeystroke script trigger.   Direct Link

Get(TriggerGestureInfo) Returns details about the gesture that activated an OnGestureTap script trigger.   Direct Link

Get(TriggerExternalEvent) In FileMaker Go, returns a number representing the event that activated an OnExternalCommandReceived script trigger.   Direct Link

Get(TriggerCurrentPanel) Returns the index and object name of the panel to switch from when the OnPanelSwitch script trigger is activated.   Direct Link

Get(TouchKeyboardState) Returns 1 (true) if the touch keyboard is set to display automatically when needed; otherwise, returns 0 (false).   Direct Link

Get(TotalRecordCount) Returns the total number of records in the current table.   Direct Link

Get(TextRulerVisible) Returns 1 (true) if the text ruler is displayed; otherwise, returns 0 (false).   Direct Link

Get(TemporaryPath) Returns the path to the current FileMaker temporary folder.   Direct Link

Get(SystemVersion) Returns the version of the current operating system.   Direct Link

Get(SystemPlatform) Returns a number representing the current platform.   Direct Link

Get(SystemNICAddress) Returns the hardware addresses of all NIC (Network Interface Controller) cards connected to the computer.   Direct Link

Get(SystemLocaleElements) Returns a JSON object with information about the client system's locale.   Direct Link

Get(SystemLanguage) Returns the language currently set on the current system.   Direct Link

Get(SystemIPAddress) Returns a list of the IP addresses of all computers connected to an active NIC (Network Interface Controller) card.   Direct Link

Get(SystemDrive) Returns the drive letter (Windows) or volume name (macOS) where the running operating system is located.   Direct Link

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