Functions Reference
Table Of Contents
- Chapter 1 Introduction
- Chapter 2 Aggregate functions
- Chapter 3 Date functions
- Chapter 4 Design functions
- Chapter 5 External functions
- Chapter 6 Financial functions
- Chapter 7 Get functions
- Get(AccountName)
- Get(ActiveFieldContents)
- Get(ActiveFieldName)
- Get(ActiveFieldTableName)
- Get(ActiveLayoutObjectName)
- Get(ActiveModifierKeys)
- Get(ActiveRepetitionNumber)
- Get(ActiveSelectionSize)
- Get(ActiveSelectionStart)
- Get(AllowAbortState)
- Get(AllowToolbarState)
- Get(ApplicationLanguage)
- Get(ApplicationVersion)
- Get(CalculationRepetitionNumber)
- Get(CurrentDate)
- Get(CurrentHostTimestamp)
- Get(CurrentTime)
- Get(CurrentTimestamp)
- Get(CustomMenuSetName)
- Get(DesktopPath)
- Get(DocumentsPath)
- Get(ErrorCaptureState)
- Get(ExtendedPrivileges)
- Get(FileMakerPath)
- Get(FileName)
- Get(FilePath)
- Get(FileSize)
- Get(FoundCount)
- Get(HighContrastColor)
- Get(HighContrastState)
- Get(HostApplicationVersion)
- Get(HostIPAddress)
- Get(HostName)
- 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(PortalRowNumber)
- Get(PreferencesPath)
- Get(PrinterName)
- Get(PrivilegeSetName)
- 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(UserCount)
- Get(UserName)
- Get(UseSystemFormatsState)
- Get(WindowContentHeight)
- Get(WindowContentWidth)
- Get(WindowDesktopHeight)
- Get(WindowDesktopWidth)
- Get(WindowHeight)
- Get(WindowLeft)
- Get(WindowMode)
- Get(WindowName)
- Get(WindowTop)
- Get(WindowVisible)
- Get(WindowWidth)
- Get(WindowZoomLevel)
- Chapter 8 Logical functions
- Chapter 9 Number functions
- Chapter 10 Repeating functions
- Chapter 11 Summary functions
- Chapter 12 Text functions
- 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
- Chapter 13 Text formatting functions
- Chapter 14 Time functions
- Chapter 15 Timestamp functions
- Chapter 16 Trigonometric functions
- Appendix A Glossary
Chapter 7
|
Get functions 57
Chapter 7
Get functions
Use Get functions in scripts for error checking and prevention, or to capture information
about the status of a database file or elements in it, or an action being performed.
Many Get functions return information that changes on a regular basis. For example,
when the Get(CurrentTime) function is placed in a stored calculation field, the time will
only update when a new record is created. If the calculation has other fields in it, but the
calculation result still returns the current time, then the stored calculation result will only
update when those other fields have been modified in the current record. If either of these
calculations are unstored, the time will update as needed. For performance reasons,
making a calculation field unstored is not always the best idea. Get functions are best
used in a script where the status information from a Get function is up to date at the
moment that the calculation is run.
To access the list of Get functions, in the Specify Calculation dialog box, choose View all
functions by type or View Get functions. When you View all functions by name, you
see only Get(flag).
Note See FileMaker Pro Help for information about running scripts in client/server and
peer-to-peer environments.
Click a function name for details.
This function Returns
Get(AccountName), page 62 The authenticated account name being used for the active
database file.
Get(ActiveFieldContents), page 62 The contents of the field containing the cursor.
Get(ActiveFieldName), page 63 The name of the field currently containing the cursor.
Get(ActiveFieldTableName), page 64 The name of the table that contains the active field (the field that
currently contains the cursor).
Get(ActiveLayoutObjectName), page
64
The name of the active layout object in the calculation's active
window.
Get(ActiveModifierKeys), page 65 A number representing the keyboard modifier keys (for example,
Shift) that are being pressed.
Get(ActiveRepetitionNumber), page
65
A number representing the current (active) repetition of a
repeating field
.
Get(ActiveSelectionSize), page 66 A number representing how many characters are selected.
Get(ActiveSelectionStart), page 66 A number representing the starting character of the selected text.
Get(AllowAbortState), page 67 A Boolean value representing the current state of Allow user
abort script step.
Get(AllowToolbarState), page 67 A Boolean value representing whether toolbars are allowed to be
visible.
Get(ApplicationLanguage), page 68 Text representing the current application language (for example,
English).