Functions reference (alphabetical list)
A, B, C
Abs
Acos
Asin
Atan
Average
Base64Decode
Base64Encode
Case
Ceiling
Char
Choose
Code
Combination
Cos
Count
D
DatabaseNames
Date
Day
DayName
DayNameJ
DayOfWeek
DayOfYear
Degrees
Div
E
Evaluate
EvaluationError
Exact
ExecuteSQL
Exp
Extend
External
F
Factorial
FieldBounds
FieldComment
FieldIDs
FieldNames
FieldRepetitions
FieldStyle
FieldType
Filter
FilterValues
Floor
FV
G
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(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(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(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(TriggerCurrentPanel)
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)
GetAsBoolean
GetAsCSS
GetAsDate
GetAsNumber
GetAsSVG
GetAsText
GetAsTime
GetAsTimestamp
GetAsURLEncoded
GetContainerAttribute
GetField
GetFieldName
GetHeight
GetLayoutObjectAttribute
GetNextSerialValue
GetNthRecord
GetRepetition
GetSummary
GetThumbnail
GetValue
GetWidth
H, I, J, K
Hiragana
Hour
If
Int
IsEmpty
IsValid
IsValidExpression
KanaHankaku
KanaZenkaku
KanjiNumeral
Katakana
L, M, N, O
Last
LayoutIDs
LayoutNames
LayoutObjectNames
Left
LeftValues
LeftWords
Length
Let
Lg
List
Ln
Location
LocationValues
Log
Lookup
LookupNext
Lower
Max
Middle
MiddleValues
MiddleWords
Min
Minute
Mod
Month
MonthName
MonthNameJ
NPV
NumToJText
P, Q
PatternCount
Pi
PMT
Position
Proper
PV
Quote
R
Radians
Random
RelationInfo
Replace
RGB
Right
RightValues
RightWords
RomanHankaku
RomanZenkaku
Round
S
ScriptIDs
ScriptNames
Seconds
Self
SerialIncrement
SetPrecision
Sign
Sin
Sqrt
StDev
StDevP
Substitute
Sum
T, U
TableIDs
TableNames
Tan
TextColor
TextColorRemove
TextFont
TextFontRemove
TextFormatRemove
TextSize
TextSizeRemove
TextStyleAdd
TextStyleRemove
Time
Timestamp
Trim
TrimAll
Truncate
Upper
V, W, X, Y, Z
ValueCount
ValueListIDs
ValueListItems
ValueListNames
Variance
VarianceP
VerifyContainer
WeekOfYear
WeekOfYearFiscal
WindowNames
WordCount
Year
YearName