Reference > Functions reference > Functions reference (alphabetical list)
 

Functions reference (alphabetical list)

A, B, C

Abs

Acos

Asin

Atan

Average

Base64Decode

Base64Encode

Base64EncodeRFC

Case

Ceiling

Char

Choose

Code

Combination

ComputeModel

ConvertFromFileMakerPath

ConvertToFileMakerPath

Cos

Count

CryptAuthCode

CryptDecrypt

CryptDecryptBase64

CryptDigest

CryptEncrypt

CryptEncryptBase64

CryptGenerateSignature

CryptVerifySignature

D

DatabaseNames

Date

Day

DayName

DayNameJ

DayOfWeek

DayOfYear

Degrees

Div

E

Evaluate

EvaluationError

Exact

ExecuteSQL

Exp

Extend

F

Factorial

FieldBounds

FieldComment

FieldIDs

FieldNames

FieldRepetitions

FieldStyle

FieldType

Filter

FilterValues

Floor

Furigana

FV

G

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

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

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)

GetAsBoolean

GetAsCSS

GetAsDate

GetAsNumber

GetAsSVG

GetAsText

GetAsTime

GetAsTimestamp

GetAsURLEncoded

GetAVPlayerAttribute

GetContainerAttribute

GetField

GetFieldName

GetHeight

GetLayoutObjectAttribute

GetNextSerialValue

GetNthRecord

GetRepetition

GetSensor

GetSummary

GetThumbnail

GetValue

GetWidth

H, I, J, K

HexDecode

HexEncode

Hiragana

Hour

If

Int

IsEmpty

IsValid

IsValidExpression

JSONDeleteElement

JSONFormatElements

JSONGetElement

JSONListKeys

JSONListValues

JSONSetElement

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

RangeBeacons

RelationInfo

Replace

RGB

Right

RightValues

RightWords

RomanHankaku

RomanZenkaku

Round

S

ScriptIDs

ScriptNames

Seconds

Self

SerialIncrement

SetPrecision

SetRecursion

Sign

Sin

SortValues

Sqrt

StDev

StDevP

Substitute

Sum

T, U

TableIDs

TableNames

Tan

TextColor

TextColorRemove

TextDecode

TextEncode

TextFont

TextFontRemove

TextFormatRemove

TextSize

TextSizeRemove

TextStyleAdd

TextStyleRemove

Time

Timestamp

Trim

TrimAll

Truncate

UniqueValues

Upper

V, W, X, Y, Z

ValueCount

ValueListIDs

ValueListItems

ValueListNames

Variance

VarianceP

VerifyContainer

WeekOfYear

WeekOfYearFiscal

While

WindowNames

WordCount

Year

YearName