Function of the Day

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

TableIDs Returns a list of all table occurrence IDs in fileName.   Direct Link

ScriptNames Returns a list of the names of all scripts in fileName.   Direct Link

ScriptIDs Returns a list of all script IDs in fileName.   Direct Link

RelationInfo Returns a list of four values for each relationship directly related to tableName.   Direct Link

LayoutObjectNames Returns a list of the names of all named objects on layoutName in fileName.   Direct Link

LayoutNames Returns a list of the names of all layouts in fileName.   Direct Link

LayoutIDs Returns a list of all layout IDs in fileName.   Direct Link

GetNextSerialValue Returns the next serial number of fieldName in fileName.   Direct Link

FieldType Returns information about fieldName.   Direct Link

FieldStyle Returns the field formatting applied to fieldName on layoutName in fileName.   Direct Link

FieldRepetitions Returns the number and orientation of repetitions of a repeating field as formatted on a layout.   Direct Link

FieldNames Returns a list of the names of all fields on layoutName in fileName.   Direct Link

FieldIDs Returns a list of all field IDs in fileName and layoutName.   Direct Link

FieldComment Returns the specified field's comment.   Direct Link

FieldBounds Returns the location, in points, of each field boundary and the field's rotation in degrees.   Direct Link

DatabaseNames Returns a list of the names of all files open on the computer.   Direct Link

Year Returns a number representing the year in which a date occurs.   Direct Link

WeekOfYearFiscal Returns a number from 1 to 53, representing the week containing a date, from a starting day.   Direct Link

WeekOfYear Returns the number of weeks after January 1 of the year of a date.   Direct Link

MonthName Returns the full name of the month for a date.   Direct Link

Month Returns a number from 1 to 12, representing the month of the year in which a date occurs.   Direct Link

DayOfYear Returns the number of days from the beginning of the year of a date.   Direct Link

DayOfWeek Returns a number representing the day of the week on which a date occurs.   Direct Link

DayName Returns text that is the full name of the weekday for a date.   Direct Link

Day Returns a number from 1 to 31, for the day of the month on which a date occurs.   Direct Link

Date Returns the calendar date for a month, day, and year.   Direct Link

VerifyContainer Returns 0 (false) if container data was changed or deleted outside the FileMaker Platform; otherwise, returns 1 (true).   Direct Link

TextEncode Returns a text file as container data from text using the specified character encoding and line endings.   Direct Link

TextDecode Returns text decoded from container data using the specified character encoding.   Direct Link

HexEncode Returns data as text in hexadecimal format.   Direct Link

HexDecode Returns either container or text content from text encoded in hexadecimal format.   Direct Link

GetWidth Returns the width, in pixels, of the content in a container field that holds images.   Direct Link

GetThumbnail Returns a thumbnail image of the content in a container field, according to a specified height and width.   Direct Link

GetHeight Returns the height, in pixels, of the content in a container field that holds images.   Direct Link

GetContainerAttribute Returns the file metadata of the specified container field.   Direct Link

CryptVerifySignature Verifies whether a digital signature is valid for the data.   Direct Link

CryptGenerateSignature Generates the digital signature of the data.   Direct Link

CryptEncryptBase64 Encrypts data with the specified key and returns text in Base64 format.   Direct Link

CryptEncrypt Encrypts data with the specified key and returns container data.   Direct Link

CryptDigest Returns a binary hash value generated by the specified cryptographic hash algorithm.   Direct Link

CryptDecryptBase64 Decrypts Base64-encoded text with the specified key and returns text or container data.   Direct Link