|
| Click the item to view FMI reference. |
| Aggregate Functions | | Average ( field {; field...} ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | Count ( field {; field...} ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | List ( field {; field...} ) | 8.5, 9 | | Max ( field {; field...} ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | Min ( field {; field...} ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | StDev ( field {; field...} ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | StDevP ( field {; field...} ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | Sum ( field {; field...} ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | Variance ( field {; field...} ) | 7, 8, 8.5, 9 | | VarianceP ( field {; field...} ) | 7, 8, 8.5, 9 | | Date Functions | | Date ( month; day; year ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | Day ( date ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | DayName ( date ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | DayNameJ ( date ) | 7, 8, 8.5, 9 | | DayofWeek ( date ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | DayofYear ( date ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | Month ( date ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | MonthName ( date ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | MonthNameJ ( date ) | 7, 8, 8.5, 9 | | WeekofYear ( date ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | WeekofYearFiscal ( date; startingDay ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | Year ( date ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | YearName ( date; format ) | 7, 8, 8.5, 9 | | Design Functions | | DatabaseNames | 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | FieldBounds ( fileName; layoutName; fieldName ) | 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | FieldComment ( fileName; fieldName ) | 7, 8, 8.5, 9 | | FieldIDs ( fileName; layoutName ) | 5.5, 6, 7, 8, 8.5, 9 | | FieldNames ( fileName; layoutName ) | 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | FieldRepetitions ( fileName; layoutName; fieldName ) | 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | FieldStyle ( fileName; layoutName; fieldName ) | 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | FieldType ( fileName; fieldName ) | 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | GetNextSerialValue ( fileName; fieldName ) | 5.5, 6, 7, 8, 8.5, 9 | | LayoutIDs ( fileName ) | 5.5, 6, 7, 8, 8.5, 9 | | LayoutNames ( fileName ) | 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | LayoutObjectNames ( fileName; layoutName ) | 8.5, 9 | | RelationInfo ( fileName; tableName ) | 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | ScriptIDs ( fileName ) | 5.5, 6, 7, 8, 8.5, 9 | | ScriptNames ( fileName ) | 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | TableIDs ( fileName ) | 7, 8, 8.5, 9 | | TableNames ( fileName ) | 7, 8, 8.5, 9 | | ValueListIDs ( fileName ) | 5.5, 6, 7, 8, 8.5, 9 | | ValueListItems ( fileName; valuelist ) | 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | ValueListNames ( fileName ) | 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | WindowNames {( fileName )} | 7, 8, 8.5, 9 | | Financial Functions | | FV ( payment; interestRate; periods ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | NPV ( payment; interestRate ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | PMT ( principal; interestRate; term ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | PV ( payment; interestRate; periods ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | Get Functions | | Get(AccountName) | 7, 8, 8.5, 9 | | Get(ActiveFieldContents) | 7, 8, 8.5, 9 | | Get(ActiveFieldName) | 7, 8, 8.5, 9 | | Get(ActiveFieldTableName) | 7, 8, 8.5, 9 | | Get(ActiveLayoutObjectName) | 8.5, 9 | | Get(ActiveModifierKeys) | 7, 8, 8.5, 9 | | Get(ActiveRepetitionNumber) | 7, 8, 8.5, 9 | | Get(ActiveSelectionSize) | 7, 8, 8.5, 9 | | Get(ActiveSelectionStart) | 7, 8, 8.5, 9 | | Get(AllowAbortState) | 7, 8, 8.5, 9 | | Get(AllowToolbarState) | 8, 8.5, 9 | | Get(ApplicationLanguage) | 7, 8, 8.5, 9 | | Get(ApplicationVersion) | 7, 8, 8.5, 9 | | Get(CalculationRepetitionNumber) | 7, 8, 8.5, 9 | | Get(CurrentDate) | 7, 8, 8.5, 9 | | Get(CurrentHostTimestamp) | 7, 8, 8.5, 9 | | Get(CurrentTime) | 7, 8, 8.5, 9 | | Get(CurrentTimestamp) | 7, 8, 8.5, 9 | | Get(CustomMenuSetName) | 8, 8.5, 9 | | Get(DesktopPath) | 8, 8.5, 9 | | Get(DocumentsPath) | 8, 8.5, 9 | | Get(DocumentsPathListing) | 10 | | Get(ErrorCaptureState) | 7, 8, 8.5, 9 | | Get(ExtendedPrivileges) | 7, 8, 8.5, 9 | | Get(FileMakerPath) | 8, 8.5, 9 | | Get(FileName) | 7, 8, 8.5, 9 | | Get(FilePath) | 7, 8, 8.5, 9 | | Get(FileSize) | 7, 8, 8.5, 9 | | Get(FoundCount) | 7, 8, 8.5, 9 | | Get(HighContrastColor) | 7, 8, 8.5, 9 | | Get(HighContrastState) | 7, 8, 8.5, 9 | | Get(HostApplicationVersion) | 9 | | Get(HostIPAddress) | 8, 8.5, 9 | | Get(HostName) | 7, 8, 8.5, 9 | | Get(LastError) | 7, 8, 8.5, 9 | | Get(LastMessageChoice) | 7, 8, 8.5, 9 | | Get(LastODBCError) | 7, 8, 8.5, 9 | | Get(LayoutAccess) | 7, 8, 8.5, 9 | | Get(LayoutCount) | 7, 8, 8.5, 9 | | Get(LayoutName) | 7, 8, 8.5, 9 | | Get(LayoutNumber) | 7, 8, 8.5, 9 | | Get(LayoutTableName) | 7, 8, 8.5, 9 | | Get(LayoutViewState) | 7, 8, 8.5, 9 | | Get(MultiUserState) | 7, 8, 8.5, 9 | | Get(NetworkProtocol) | 7, 8, 8.5, 9 | | Get(PageNumber) | 7, 8, 8.5, 9 | | Get(PortalRowNumber) | 7, 8, 8.5, 9 | | Get(PreferencesPath) | 8, 8.5, 9 | | Get(PrinterName) | 7, 8, 8.5, 9 | | Get(PrivilegeSetName) | 7, 8, 8.5, 9 | | Get(RecordAccess) | 7, 8, 8.5, 9 | | Get(RecordID) | 7, 8, 8.5, 9 | | Get(RecordModificationCount) | 7, 8, 8.5, 9 | | Get(RecordNumber) | 7, 8, 8.5, 9 | | Get(RecordOpenCount) | 8, 8.5, 9 | | Get(RecordOpenState) | 8, 8.5, 9 | | Get(RequestCount) | 7, 8, 8.5, 9 | | Get(RequestOmitState) | 8, 8.5, 9 | | Get(ScreenDepth) | 7, 8, 8.5, 9 | | Get(ScreenHeight) | 7, 8, 8.5, 9 | | Get(ScreenWidth) | 7, 8, 8.5, 9 | | Get(ScriptName) | 7, 8, 8.5, 9 | | Get(ScriptParameter) | 7, 8, 8.5, 9 | | Get(ScriptResult) | 8, 8.5, 9 | | Get(SortState) | 7, 8, 8.5, 9 | | Get(StatusAreaState) | 7, 8, 8.5, 9 | | Get(SystemDrive) | 8, 8.5, 9 | | Get(SystemIPAddress) | 7, 8, 8.5, 9 | | Get(SystemLanguage) | 7, 8, 8.5, 9 | | Get(SystemNICAddress) | 7, 8, 8.5, 9 | | Get(SystemPlatform) | 7, 8, 8.5, 9 | | Get(SystemVersion) | 7, 8, 8.5, 9 | | Get(TemporaryPath) | 9 | | Get(TextRulerVisible) | 8, 8.5, 9 | | Get(TotalRecordCount) | 7, 8, 8.5, 9 | | Get(TriggerKeystroke) | 10 | | Get(TriggerMidifierKeys) | 10 | | Get(UserCount) | 7, 8, 8.5, 9 | | Get(UserName) | 7, 8, 8.5, 9 | | Get(UseSystemFormatsState) | 8, 8.5, 9 | | Get(WindowContentHeight) | 7, 8, 8.5, 9 | | Get(WindowContentWidth) | 7, 8, 8.5, 9 | | Get(WindowDesktopHeight) | 7, 8, 8.5, 9 | | Get(WindowDesktopWidth) | 7, 8, 8.5, 9 | | Get(WindowHeight) | 7, 8, 8.5, 9 | | Get(WindowLeft) | 7, 8, 8.5, 9 | | Get(WindowMode) | 7, 8, 8.5, 9 | | Get(WindowName) | 7, 8, 8.5, 9 | | Get(WindowTop) | 7, 8, 8.5, 9 | | Get(WindowVisible) | 7, 8, 8.5, 9 | | Get(WindowWidth) | 7, 8, 8.5, 9 | | Get(WindowZoomLevel) | 8, 8.5, 9 | | Logical Functions | | Case ( test1; result1 {; test2; result2; ...; defaultResult} ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | Choose ( test; result0 {; result1; result2...} ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | Evaluate ( expression {; [field1; field2; ...] } ) | 7, 8, 8.5, 9 | | EvaluationError ( expression ) | 7, 8, 8.5, 9 | | GetAsBoolean ( data ) | 8, 8.5, 9 | | GetField ( fieldName ) | 5.5, 6, 7, 8, 8.5, 9 | | GetFieldName ( field ) | 10 | | GetLayoutObjectAttribute ( objectName; attributeName {; repetitionNumber; portalRowNumber} ) | 8.5, 9 | | GetNthRecord ( fieldName; recordNumber ) | 8, 8.5, 9 | | If ( test; resultOne; resultTwo ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | IsEmpty ( field ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | IsValid ( field ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | IsValidExpression ( expression ) | 7, 8, 8.5, 9 | | Let ( {[}var1=expression1 {; var2=expression2...]}; calculation ) | 7, 8, 8.5, 9 | | Lookup ( sourceField {; failExpression} ) | 7, 8, 8.5, 9 | | LookupNext ( sourceField; lower/higherFlag ) | 7, 8, 8.5, 9 | | Quote ( text ) | 7, 8, 8.5, 9 | | Self | 9 | | Number Functions | | Abs ( number ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | Ceiling ( number ) | 7, 8, 8.5, 9 | | Combination ( setSize; numberOfChoices ) | 8, 8.5, 9 | | Div ( number; divisor ) | 7, 8, 8.5, 9 | | Exp ( number ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | Factorial ( number {; numberOfFactors} ) | 7, 8, 8.5, 9 | | Floor ( number ) | 7, 8, 8.5, 9 | | Int ( number ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | Lg ( number ) | 7, 8, 8.5, 9 | | Ln ( number ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | Log ( number ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | Mod ( number; divisor ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | Random | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | Round ( number; precision ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | SetPrecision ( expression; precision ) | 7, 8, 8.5, 9 | | Sign ( number ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | Sqrt ( number ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | Truncate ( number; precision ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | Repeating Functions | | Extend ( non-repeatingField ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | GetRepetition ( repeatingField; Number ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | Last ( repeatingField ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | Summary Functions | | GetSummary ( summaryField; breakField ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | Text Functions | | Char ( number ) | 10 | | Code ( text ) | 10 | | Exact ( originalText; comparisonText ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | Filter ( textToFilter; filterText ) | 7, 8, 8.5, 9 | | FilterValues ( textToFilter; filterValues ) | 7, 8, 8.5, 9 | | GetAsCSS ( text ) | 7, 8, 8.5, 9 | | GetAsDate ( text ) | 7, 8, 8.5, 9 | | GetAsNumber ( text ) | 7, 8, 8.5, 9 | | GetAsSVG ( text ) | 7, 8, 8.5, 9 | | GetAsText ( data ) | 7, 8, 8.5, 9 | | GetAsTime ( text ) | 7, 8, 8.5, 9 | | GetAsTimestamp ( text ) | 7, 8, 8.5, 9 | | GetAsURLEncoded ( text ) | 8.5, 9 | | GetValue ( listOfValues; valueNumber ) | 8, 8.5, 9 | | Hiragana ( text ) | 7, 8, 8.5, 9 | | KanaHankaku ( text ) | 7, 8, 8.5, 9 | | KanaZenkaku ( text ) | 7, 8, 8.5, 9 | | KanjiNumeral ( text ) | 7, 8, 8.5, 9 | | Katakana ( text ) | 7, 8, 8.5, 9 | | Left ( text; number ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | LeftValues ( text; numberOfValues ) | 7, 8, 8.5, 9 | | LeftWords ( text; numberOfWords ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | Length ( text ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | Lower ( text ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | Middle ( text; start; numberOfCharacters ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | MiddleValues ( text; startingValue; numberOfValues ) | 7, 8, 8.5, 9 | | MiddleWords ( text; startingWord; numberOfWords ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | NumToJText ( number; separator; characterType ) | 7, 8, 8.5, 9 | | PatternCount ( text; searchString ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | Position ( text; searchString; start; occurrence ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | Proper ( text ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | Replace ( text; start; numberOfCharacters; replacementText ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | Right ( text; number ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | RightValues ( text; numberOfValues ) | 7, 8, 8.5, 9 | | RightWords ( text; numberOfWords ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | RomanHankaku ( text ) | 7, 8, 8.5, 9 | | RomanZenkaku ( text ) | 7, 8, 8.5, 9 | | SerialIncrement ( text; incrementBy ) | 7, 8, 8.5, 9 | | Substitute ( text; searchString; replaceString ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | Trim ( text ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | TrimAll ( text; trimSpaces; trimType ) | 7, 8, 8.5, 9 | | Upper ( text ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | ValueCount ( text ) | 7, 8, 8.5, 9 | | WordCount ( text ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | Text Formatting Functions | | RGB ( red; green; blue ) | 7, 8, 8.5, 9 | | TextColor ( text; RGB( red; green; blue ) ) | 7, 8, 8.5, 9 | | TextColorRemove ( text {; RGB( red; green; blue )} ) | 8, 8.5, 9 | | TextFont ( text; fontName {; fontScript} ) | 7, 8, 8.5, 9 | | TextFontRemove ( text {; fontToRemove; fontScript} ) | 8, 8.5, 9 | | TextFormatRemove ( text ) | 8, 8.5, 9 | | TextSize ( text; fontSize ) | 7, 8, 8.5, 9 | | TextSizeRemove ( text {; sizeToRemove} ) | 8, 8.5, 9 | | TextStyleAdd ( text; styles ) | 7, 8, 8.5, 9 | | TextStyleRemove ( text; styles ) | 7, 8, 8.5, 9 | | Time Functions | | Hour ( time ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | Minute ( time ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | Seconds ( time ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | Time ( hours; minutes; seconds ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | Timestamp Functions | | Timestamp ( date; time ) | 7, 8, 8.5, 9 | | Trigonometric Functions | | Acos | 9 | | Asin | 9 | | Atan ( number ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | Cos ( angleInRadians ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | Degrees ( angleInRadians ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | Pi | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | Radians ( angleInDegrees ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | Sin ( angleInRadians ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | | Tan ( angleInRadians ) | 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9 | |
|
|
Functions 
Script Steps
