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 100
Get(ScreenHeight) The height, in points, of the screen in which the window of the
current file is open.
Get(ScreenScaleFactor) The scale factor of the screen in which the current file is open.
Get(ScreenWidth) The width, in points, of the screen in which the window of the
current file is open.
Get(ScriptAnimationState) 1 (true) if animations are enabled for the current script; otherwise,
returns 0 (false).
Get(ScriptName) The name of the script that is currently running or is paused.
Get(ScriptParameter) The script parameter passed into the current script.
Get(ScriptResult) The script result from a performed sub-script.
Get(SortState) A value representing the current sort state.
Get(StatusAreaState) A number representing the current status toolbar state.
Get(SystemDrive) The drive letter (Windows) or volume name (OS X) where the
running operating system is located.
Get(SystemIPAddress) A list of the IP addresses of all computers connected to an active
NIC (Network Interface Controller) card.
Get(SystemLanguage) The language currently set on the current system.
Get(SystemNICAddress) The hardware addresses of all NIC (Network Interface Controller)
cards connected to the computer.
Get(SystemPlatform) A number representing the current platform.
Get(SystemVersion) The version of the current operating system.
Get(TemporaryPath) The path to the temporary folder FileMaker Pro uses for the
current user, or the path FileMaker
Server uses on the system.
Get(TextRulerVisible) 1 (true) if the text ruler is displayed; otherwise, returns 0 (false).
Get(TotalRecordCount) The total number of records in the current table.
Get(TouchKeyboardState) 1 (true) if the touch keyboard is set to display automatically when
needed; otherwise, returns 0 (false).
Get(TriggerCurrentPanel) The index and object name of the panel to switch from when the
OnPanelSwitch
script trigger is activated.
Get(TriggerExternalEvent) A number representing the event that activated an
OnExternalCommandReceived script trigger.
Get(TriggerGestureInfo) Details about the gesture that activated an OnGestureTap script
trigger.
Get(TriggerKeystroke) The characters that activated an OnObjectKeystroke or
OnLayoutKeystroke script trigger.
Get(TriggerModifierKeys) The state of the keyboard modifier keys when an
OnObjectKeystroke or OnLayoutKeystroke script trigger was
activated.
Get(TriggerTargetPanel) The index and the object name of the panel to switch to when the
OnPanelSwitch script trigger is activated.
Get(UserCount) The number of clients currently accessing the file.
Get(UserName) The name of the FileMaker user, as specified in the General tab
of the Preferences dialog box.
This function Returns