Functions reference (category list)

Text functions

Char

Code

Exact

Filter

FilterValues

GetAsCSS

GetAsDate

GetAsNumber

GetAsSVG

GetAsText

GetAsTime

GetAsTimestamp

GetAsURLEncoded

GetValue

Left

LeftValues

LeftWords

Length

Lower

Middle

MiddleValues

MiddleWords

PatternCount

Position

Proper

Quote

Replace

Right

RightValues

RightWords

SerialIncrement

SortValues

Substitute

Trim

TrimAll

UniqueValues

Upper

ValueCount

WordCount

Text formatting functions

RGB

TextColor

TextColorRemove

TextFont

TextFontRemove

TextFormatRemove

TextSize

TextSizeRemove

TextStyleAdd

TextStyleRemove

Number functions

Abs

Ceiling

Combination

Div

Exp

Factorial

Floor

Int

Lg

Ln

Log

Mod

Random

Round

SetPrecision

Sign

Sqrt

Truncate

Date functions

Date

Day

DayName

DayOfWeek

DayOfYear

Month

MonthName

WeekOfYear

WeekOfYearFiscal

Year

Time functions

Hour

Minute

Seconds

Time

Timestamp functions

Timestamp

Container functions

Base64Decode

Base64Encode

Base64EncodeRFC

CryptAuthCode

CryptDecrypt

CryptDecryptBase64

CryptDigest

CryptEncrypt

CryptEncryptBase64

CryptGenerateSignature

CryptVerifySignature

GetContainerAttribute

GetHeight

GetThumbnail

GetWidth

HexDecode

HexEncode

TextDecode

TextEncode

VerifyContainer

Japanese functions

DayNameJ

Furigana

Hiragana

KanaHankaku

KanaZenkaku

KanjiNumeral

Katakana

MonthNameJ

NumToJText

RomanHankaku

RomanZenkaku

YearName

JSON functions

JSONDeleteElement

JSONFormatElements

JSONGetElement

JSONListKeys

JSONListValues

JSONSetElement

Aggregate functions

Average

Count

List

Max

Min

StDev

StDevP

Sum

Variance

VarianceP

Repeating functions

Extend

GetRepetition

Last

Financial functions

FV

NPV

PMT

PV

Trigonometric functions

Acos

Asin

Atan

Cos

Degrees

Pi

Radians

Sin

Tan

Logical functions

Case

Choose

Evaluate

EvaluationError

ExecuteSQL

GetAsBoolean

GetField

GetNthRecord

GetSummary

If

IsEmpty

IsValid

IsValidExpression

Let

Lookup

LookupNext

Self

SetRecursion

While

Miscellaneous functions

GetFieldName

GetLayoutObjectAttribute

Get functions

Get(AccountExtendedPrivileges)

Get(AccountGroupName)

Get(AccountName)

Get(AccountPrivilegeSetName)

Get(AccountType)

Get(ActiveFieldContents)

Get(ActiveFieldName)

Get(ActiveFieldTableName)

Get(ActiveLayoutObjectName)

Get(ActiveModifierKeys)

Get(ActivePortalRowNumber)

Get(ActiveRecordNumber)

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(LastExternalErrorDetail)

Get(LastMessageChoice)

Get(LayoutAccess)

Get(LayoutCount)

Get(LayoutName)

Get(LayoutNumber)

Get(LayoutTableName)

Get(LayoutViewState)

Get(MenubarState)

Get(ModifiedFields)

Get(MultiUserState)

Get(NetworkProtocol)

Get(NetworkType)

Get(OpenDataFileInfo)

Get(PageNumber)

Get(PersistentID)

Get(PreferencesPath)

Get(PrinterName)

Get(QuickFindText)

Get(RecordAccess)

Get(RecordID)

Get(RecordModificationCount)

Get(RecordNumber)

Get(RecordOpenCount)

Get(RecordOpenState)

Get(RegionMonitorEvents)

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(UUIDNumber)

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)

Design functions

DatabaseNames

FieldBounds

FieldComment

FieldIDs

FieldNames

FieldRepetitions

FieldStyle

FieldType

GetNextSerialValue

LayoutIDs

LayoutNames

LayoutObjectNames

RelationInfo

ScriptIDs

ScriptNames

TableIDs

TableNames

ValueListIDs

ValueListItems

ValueListNames

WindowNames

Mobile functions

GetAVPlayerAttribute

GetSensor

Location

LocationValues

RangeBeacons