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(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(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
162 FileMaker Functions Reference
KanjiNumeral, page
172
Kanji numerals converted from Arabic numerals.
Katakana, page 172 Zenkaku Katakana converted from Hiragana.
Left, page 173 The specified number of characters in the text, counting from the left.
LeftValues, page
173
The specified number of values in the text, counting from the left.
LeftWords, page
174
The specified number of words in the text, counting from the left.
Length, page 175 The number of characters in the specified text, including all spaces, numbers, and
special characters.
Lower, page 175 All letters in the specified text as lowercase.
Middle, page 176 The specified number of characters in the text, starting at a specified character
position.
MiddleValues, page
176
The specified number of values in the text, starting with a specified value.
MiddleWords, page
177
The specified number of words in the text, starting with a specified word.
NumToJText, page
178
Roman numbers converted from Japanese text.
PatternCount, page
179
The number of occurrences of a search string in the specified text.
Position, page 179 The specified occurrence of a search string, starting from a specified position.
Proper, page 180 The first letter of each word in the specified text as uppercase, and all other letters
as lowercase.
Quote, page 181 The specified text surrounded by quotation marks (“ ”).
Replace, page 181 A new string of characters consisting of the specified text as modified by the
specified replacement text.
Right, page 182 The specified number of characters in the text, counting from the right.
RightValues, page
182
The specified number of values in the text, counting from the right.
RightWords, page
183
The specified number of words in the text, counting from the right.
RomanHankaku,
page 184
Hankaku (alphanumeric & symbols) converted from Zenkaku (alphanumeric &
symbols).
RomanZenkaku,
page 184
Zenkaku (alphanumeric & symbols) converted from Hankaku (alphanumeric &
symbols).
SerialIncrement,
page 185
The combined text and numbers in a specified value, with the numbers
incremented by the specified amount.
Substitute, page 186 A text string with every occurrence of a specified search string in the text replaced
by a specified replacement string.
Trim, page 186 Text stripped of all leading and trailing spaces.
TrimAll, page 187 Text with full width spaces between non-Roman and Roman characters removed.
Upper, page 188 All letters in the specified text as uppercase.
This function Returns