Home > Reference > Functions reference > Functions reference (alphabetical list)
Functions reference (alphabetical list) A, B, C Abs Acos Asin Atan Average Case Ceiling Char Choose Code Combination Cos Count D DatabaseNames Date Day DayName DayNameJ DayOfWeek DayOfYear Degrees Div E Evaluate EvaluationError Exact Exp Extend External F Factorial FieldBounds FieldComment FieldIDs FieldNames FieldRepetitions FieldStyle FieldType Filter FilterValues Floor FV G Get(AccountName) Get(ActiveFieldContents) Get(ActiveFieldName) Get(ActiveFieldTableName) Get(ActiveLayoutObjectName) Get(ActiveModifierKeys) Get(ActiveRepetitionNumber) Get(ActiveSelectionSize) Get(ActiveSelectionStart) Get(AllowAbortState) Get(AllowToolbarState) Get(ApplicationLanguage) Get(ApplicationVersion) Get(CalculationRepetitionNumber) Get(CurrentDate) Get(CurrentHostTimestamp) Get(CurrentTime) Get(CurrentTimestamp) Get(CustomMenuSetName) Get(DesktopPath) Get(DocumentsPath) Get(DocumentsPathListing) Get(ErrorCaptureState) Get(ExtendedPrivileges) Get(FileMakerPath) Get(FileName) Get(FilePath) Get(FileSize) Get(FoundCount) Get(HighContrastColor) Get(HighContrastState) Get(HostApplicationVersion) Get(HostIPAddress) Get(HostName) Get(LastError) Get(LastMessageChoice) Get(LastODBCError) Get(LayoutAccess) Get(LayoutCount) Get(LayoutName) Get(LayoutNumber) Get(LayoutTableName) Get(LayoutViewState) Get(MultiUserState) Get(NetworkProtocol) Get(PageNumber) Get(PortalRowNumber) Get(PreferencesPath) Get(PrinterName) Get(PrivilegeSetName) Get(RecordAccess) Get(RecordID) Get(RecordModificationCount) Get(RecordNumber) Get(RecordOpenCount) Get(RecordOpenState) Get(RequestCount) Get(RequestOmitState) Get(ScreenDepth) Get(ScreenHeight) Get(ScreenWidth) 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(TriggerKeystroke) Get(TriggerModifierKeys) Get(UserCount) Get(UserName) Get(UseSystemFormatsState) Get(WindowContentHeight) Get(WindowContentWidth) Get(WindowDesktopHeight) Get(WindowDesktopWidth) Get(WindowHeight) Get(WindowLeft) Get(WindowMode) Get(WindowName) Get(WindowTop) Get(WindowVisible) Get(WindowWidth) Get(WindowZoomLevel) GetAsBoolean GetAsCSS GetAsDate GetAsNumber GetAsSVG GetAsText GetAsTime GetAsTimestamp GetAsURLEncoded GetField GetFieldName GetLayoutObjectAttribute GetNextSerialValue GetNthRecord GetRepetition GetSummary GetValue 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 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 WeekOfYear WeekOfYearFiscal WindowNames WordCount Year YearName