Functions Reference
Table Of Contents
- Contents
- Functions reference (alphabetical list)
- About functions
- 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(ApplicationArchitecture)
- Get(ApplicationLanguage)
- Get(ApplicationVersion)
- Get(CalculationRepetitionNumber)
- Get(ConnectionAttributes)
- Get(ConnectionState)
- Get(CurrentDate)
- Get(CurrentExtendedPrivileges)
- Get(CurrentHostTimestamp)
- Get(CurrentPrivilegeSetName)
- Get(CurrentTime)
- Get(CurrentTimestamp)
- Get(CurrentTimeUTCMilliseconds)
- Get(CustomMenuSetName)
- Get(DesktopPath)
- Get(Device)
- Get(DocumentsPath)
- Get(DocumentsPathListing)
- Get(EncryptionState)
- 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(MenubarState)
- Get(ModifiedFields)
- Get(MultiUserState)
- Get(NetworkProtocol)
- Get(NetworkType)
- 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(ScreenScaleFactor)
- Get(ScreenWidth)
- Get(ScriptAnimationState)
- 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(TouchKeyboardState)
- Get(TriggerCurrentPanel)
- Get(TriggerExternalEvent)
- Get(TriggerGestureInfo)
- Get(TriggerKeystroke)
- Get(TriggerModifierKeys)
- Get(TriggerTargetPanel)
- 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(WindowOrientation)
- 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
- Furigana
- 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
- Glossary
Get functions
F
ILEMAKER FUNCTIONS REFERENCE 99
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.
This function Returns