Home > Reference > Functions reference > Functions reference (alphabetical list)
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