Functions Reference
Table Of Contents
- Contents
- About functions
- Functions reference (alphabetical list)
- Aggregate functions
- Container functions
- Date functions
- Design functions
- External functions
- Financial functions
- Get functions
- Get(AccountExtendedPrivileges)
- Get(AccountName)
- Get(AccountPrivilegeSetName)
- Get(ActiveFieldContents)
- Get(ActiveFieldName)
- Get(ActiveFieldTableName)
- Get(ActiveLayoutObjectName)
- Get(ActiveModifierKeys)
- Get(ActivePortalRowNumber)
- Get(ActiveRepetitionNumber)
- Get(ActiveSelectionSize)
- Get(ActiveSelectionStart)
- Get(AllowAbortState)
- Get(AllowFormattingBarState)
- Get(ApplicationLanguage)
- Get(ApplicationVersion)
- Get(CalculationRepetitionNumber)
- Get(ConnectionState)
- Get(CurrentDate)
- Get(CurrentExtendedPrivileges)
- Get(CurrentHostTimestamp)
- Get(CurrentPrivilegeSetName)
- Get(CurrentTime)
- Get(CurrentTimestamp)
- Get(CustomMenuSetName)
- Get(DesktopPath)
- Get(DocumentsPath)
- Get(DocumentsPathListing)
- Get(ErrorCaptureState)
- Get(FileMakerPath)
- Get(FileName)
- Get(FilePath)
- Get(FileSize)
- Get(FoundCount)
- Get(HighContrastColor)
- Get(HighContrastState)
- Get(HostApplicationVersion)
- Get(HostIPAddress)
- Get(HostName)
- Get(InstalledFMPlugins)
- Get(LastError)
- Get(LastMessageChoice)
- Get(LastODBCError)
- Get(LayoutAccess)
- Get(LayoutCount)
- Get(LayoutName)
- Get(LayoutNumber)
- Get(LayoutTableName)
- Get(LayoutViewState)
- Get(MultiUserState)
- Get(NetworkProtocol)
- Get(PageNumber)
- Get(PersistentID)
- Get(PreferencesPath)
- Get(PrinterName)
- Get(QuickFindText)
- Get(RecordAccess)
- Get(RecordID)
- Get(RecordModificationCount)
- Get(RecordNumber)
- Get(RecordOpenCount)
- Get(RecordOpenState)
- Get(RequestCount)
- Get(RequestOmitState)
- Get(ScreenDepth)
- Get(ScreenHeight)
- Get(ScreenWidth)
- Get(ScriptName)
- Get(ScriptParameter)
- Get(ScriptResult)
- Get(SortState)
- Get(StatusAreaState)
- Get(SystemDrive)
- Get(SystemIPAddress)
- Get(SystemLanguage)
- Get(SystemNICAddress)
- Get(SystemPlatform)
- Get(SystemVersion)
- Get(TemporaryPath)
- Get(TextRulerVisible)
- Get(TotalRecordCount)
- Get(TriggerCurrentTabPanel)
- Get(TriggerKeystroke)
- Get(TriggerModifierKeys)
- Get(TriggerTargetTabPanel)
- Get(UserCount)
- Get(UserName)
- Get(UseSystemFormatsState)
- Get(UUID)
- Get(WindowContentHeight)
- Get(WindowContentWidth)
- Get(WindowDesktopHeight)
- Get(WindowDesktopWidth)
- Get(WindowHeight)
- Get(WindowLeft)
- Get(WindowMode)
- Get(WindowName)
- Get(WindowStyle)
- Get(WindowTop)
- Get(WindowVisible)
- Get(WindowWidth)
- Get(WindowZoomLevel)
- Logical functions
- Mobile functions
- Number functions
- Repeating functions
- Summary functions
- Text functions
- Char
- Code
- Exact
- Filter
- FilterValues
- GetAsCSS
- GetAsDate
- GetAsNumber
- GetAsSVG
- GetAsText
- GetAsTime
- GetAsTimestamp
- GetAsURLEncoded
- GetValue
- Hiragana
- KanaHankaku
- KanaZenkaku
- KanjiNumeral
- Katakana
- Left
- LeftValues
- LeftWords
- Length
- Lower
- Middle
- MiddleValues
- MiddleWords
- NumToJText
- PatternCount
- Position
- Proper
- Quote
- Replace
- Right
- RightValues
- RightWords
- RomanHankaku
- RomanZenkaku
- SerialIncrement
- Substitute
- Trim
- TrimAll
- Upper
- ValueCount
- WordCount
- Text formatting functions
- Time functions
- Timestamp functions
- Trigonometric functions
FILEMAKER FUNCTIONS REFERENCE 76
Get(LastError) A number representing the error, if any, 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) A string that shows the error state published by ODBC standards,
based on ISO/IEF standards.
Get(LayoutAccess) A number corresponding to the layout access privileges assigned
through the Manage Security dialog box.
Get(LayoutCount) The total number of layouts in the database file.
Get(LayoutName) The name of the layout currently displayed.
Get(LayoutNumber) The number of the layout currently displayed, according to the list
in the Manage Layouts dialog box.
Get(LayoutTableName) The name of the table that the layout is displaying records from.
Get(LayoutViewState) Information about how the database file is being viewed.
Get(MultiUserState) A number representing the current multi-user state of the
database file.
Get(NetworkProtocol) The name of the network protocol that FileMaker Pro is using on
this machine.
Get(PageNumber) A number representing the current page being printed or
previewed.
Get(PersistentID) Text representing a unique identifier of the computer or device on
which FileMaker is running.
Get(PreferencesPath) The path to the preferences folder for the current user.
Get(PrinterName) A string identifying the default printer name.
Get(QuickFindText) The text that was entered in the Quick Find box.
Get(RecordAccess) A number indicating the access privileges of the current record.
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 yet been saved.
Get(RecordOpenState) A number representing the state of the current record.
Get(RequestCount) The total number of find requests currently defined for the current
table.
Get(RequestOmitState) A Boolean value representing the state of the Omit checkbox in
Find mode.
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 number of pixels displayed vertically on the screen in which
the window of the current file is open.
Get(ScreenWidth) The number of pixels displayed horizontally on the screen in
which the window of the current file is open.
This function Returns