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 147
Examples
The following code displays the text Processing input... when a carriage return is entered:
If [ Code ( Get(TriggerKeystroke) ) = 13 ]
Show Custom Dialog [“Processing input...”]
End If
Note For information on how functions evaluate differently on the host versus the client, search the
FileMaker Knowledge Base available at
http://help.filemaker.com.
Related topics
Contents
Functions reference (alphabetical list)
Get(TriggerModifierKeys)
Purpose
Returns the state of the keyboard modifier keys as they were when a script trigger was activated.
Format
Get(TriggerModifierKeys)
Parameters
None
Data type returned
number
Originated in
FileMaker Pro 10.0
Description
Returns a value only when called from a script activated by a script trigger or from a sub-script
called from the triggered script; otherwise returns an empty string.
• See Get(ActiveModifierKeys) for a description of the values assigned to the keyboard
modifier keys.
• See the Code function for a list of navigational keys and the codes returned to a script
activated by this trigger.
Time might elapse between when the keys that activated a script trigger are pressed and the script
asks for information on the modifier keys. Use Get(TriggerKeystroke) and Get(TriggerModifierKeys)
to capture the keys that were active when the script trigger was activated. Use
Get(ActiveModifierKeys) to capture any current keys being pressed.
Notes
• Windows: Alt and Ctrl key combinations do not activate script triggers.