Reference > Functions reference > Functions reference (category list)
 

Functions reference (category list)

Aggregate functions

Average

Count

List

Max

Min

StDev

StDevP

Sum

Variance

VarianceP

Container functions

Base64Decode

Base64Encode

Base64EncodeRFC

CryptAuthCode

CryptDecrypt

CryptDecryptBase64

CryptDigest

CryptEncrypt

CryptEncryptBase64

GetContainerAttribute

GetHeight

GetThumbnail

GetWidth

HexDecode

HexEncode

TextDecode

TextEncode

VerifyContainer

Date functions

Date

Day

DayName

DayNameJ

DayOfWeek

DayOfYear

Month

MonthName

MonthNameJ

WeekOfYear

WeekOfYearFiscal

Year

YearName

Design functions

DatabaseNames

FieldBounds

FieldComment

FieldIDs

FieldNames

FieldRepetitions

FieldStyle

FieldType

GetNextSerialValue

LayoutIDs

LayoutNames

LayoutObjectNames

RelationInfo

ScriptIDs

ScriptNames

TableIDs

TableNames

ValueListIDs

ValueListItems

ValueListNames

WindowNames

Financial functions

FV

NPV

PMT

PV

Get functions

Get(AccountExtendedPrivileges)

Get(AccountGroupName)

Get(AccountName)

Get(AccountPrivilegeSetName)

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

Logical functions

Case

Choose

Evaluate

EvaluationError

ExecuteSQL

GetAsBoolean

GetAVPlayerAttribute

GetField

GetFieldName

GetLayoutObjectAttribute

GetNthRecord

If

IsEmpty

IsValid

IsValidExpression

Let

Lookup

LookupNext

Self

Mobile functions

GetSensor

Location

LocationValues

RangeBeacons

Number functions

Abs

Ceiling

Combination

Div

Exp

Factorial

Floor

Int

Lg

Ln

Log

Mod

Random

Round

SetPrecision

Sign

Sqrt

Truncate

Repeating functions

Extend

GetRepetition

Last

Summary functions

GetSummary

Text functions

Char

Code

Exact

Filter

FilterValues

Furigana

GetAsCSS

GetAsDate

GetAsNumber

GetAsSVG

GetAsText

GetAsTime

GetAsTimestamp

GetAsURLEncoded

GetValue

Hiragana

JSONDeleteElement

JSONFormatElements

JSONGetElement

JSONListKeys

JSONListValues

JSONSetElement

KanaHankaku

KanaZenkaku

KanjiNumeral

Katakana

Left

LeftValues

LeftWords

Length

Lower

Middle

MiddleValues

MiddleWords

NumToJText

PatternCount

Position

Proper

Quote

Replace

Right

RightValues

RightWords

RomanHankaku

RomanZenkaku

SerialIncrement

SortValues

Substitute

Trim

TrimAll

UniqueValues

Upper

ValueCount

WordCount

Text formatting functions

RGB

TextColor

TextColorRemove

TextFont

TextFontRemove

TextFormatRemove

TextSize

TextSizeRemove

TextStyleAdd

TextStyleRemove

Time functions

Hour

Minute

Seconds

Time

Timestamp functions

Timestamp

Trigonometric functions

Acos

Asin

Atan

Cos

Degrees

Pi

Radians

Sin

Tan