logo
Just for fun... click:
 
 
 

"It is well known that better code can help your organization function better"

-anyone who has been there





Infographics
JSON Overview JSON Overview
Progression

FileMaker 16 Card Windows FileMaker 16 Card Windows
Progression

iBeacons and FileMaker Go 15 iBeacons and FileMaker Go 15
Progression

FileMaker 14 Code Objects as ERD FileMaker 14 Code Objects as ERD
Progression

FMP URL protocol FMP URL protocol
Progression

FileMaker 14 Functions

This FileMaker platform training document:

The HTML for this table was "code generated" from a FileMaker database.

Function Type Intro'ed
Abs ( number ) Number 6.0
Acos ( number ) Trigonometric 9.0
Asin ( number ) Trigonometric 9.0
Atan ( number ) Trigonometric 6.0
Average( field { ; field... } ) Aggregate 6.0
Base64Decode ( text { ; fileNameWithExtension } ) Container 13.0
Base64Encode ( sourceField ) Container 13.0
Case ( test1 ; result1 { ; test2 ; result2 ; ... ; defaultResult} ) Logical 6.0
Ceiling ( number ) Number 7.0
Char ( number ) Text 10.0
Choose ( test ; result0 { ; result1 ; result2... } ) Logical 6.0
Code ( text ) Text 10.0
Combination ( setSize ; numberOfChoices ) Number 7.0
Cos ( angleInRadians ) Trigonometric 6.0
Count ( field { ; field... } ) Aggregate 6.0
DatabaseNames Design 6.0
Date ( month ; day ; year ) Date 6.0
Day ( date ) Date 6.0
DayName ( date ) Date 6.0
DayNameJ ( date ) Date 6.0
DayOfWeek ( date ) Date 6.0
DayOfYear ( date ) Date 6.0
Degrees ( angleInRadians ) Trigonometric 6.0
Div ( number ; divisor ) Number 7.0
Evaluate ( expression {; [ field1 ; field2 ; field3 ; ... ] } ) Logical 7.0
EvaluationError ( expression ) Logical 7.0
Exact ( originalText ; comparisonText ) Text 6.0
ExecuteSQL ( sqlQuery ; fieldSeparator ; rowSeparator { ; arguments... } ) Logical 12.0
Exp ( number ) Number 6.0
Extend ( non-repeatingField ) Repeating 6.0
Factorial ( number { ; numberOfFactors } ) Number 7.0
FieldBounds ( fileName ; layoutName ; fieldName ) Design 6.0
FieldComment ( fileName ; fieldName ) Design 7.0
FieldIDs ( fileName ; layoutName ) Design 6.0
FieldNames ( fileName ; layoutName ) Design 6.0
FieldRepetitions ( fileName ; layoutName ; fieldName ) Design 6.0
FieldStyle ( fileName ; layoutName ; fieldName ) Design 6.0
FieldType ( fileName ; fieldName ) Design 6.0
Filter ( textToFilter ; filterText ) Text 7.0
FilterValues ( textToFilter ; filterValues ) Text 7.0
Floor ( number ) Number 7.0
Furigana ( text { ; option } ) Text 14.0
FV ( payment ; interestRate ; periods ) Financial 6.0
Get ( AccountExtendedPrivileges ) Get 11.0
Get ( AccountName ) Get 7.0
Get ( AccountPrivilegeSetName ) Get 11.0
Get ( ActiveFieldContents ) Get 6.0
Get ( ActiveFieldName ) Get 6.0
Get ( ActiveFieldTableName ) Get 7.0
Get ( ActiveLayoutObjectName ) Get 8.5
Get ( ActiveModifierKeys ) Get 6.0
Get ( ActivePortalRowNumber ) Get 6.0
Get ( ActiveRepetitionNumber ) Get 6.0
Get ( ActiveSelectionSize ) Get 7.0
Get ( ActiveSelectionStart ) Get 7.0
Get ( AllowAbortState ) Get 7.0
Get ( AllowFormattingBarState ) Get 8.0
Get ( ApplicationArchitecture ) Get 14.0
Get ( ApplicationLanguage ) Get 7.0
Get ( ApplicationVersion ) Get 6.0
Get ( CalculationRepetitionNumber ) Get 7.0
Get ( ConnectionAttributes ) Get 13.0
Get ( ConnectionState ) Get 12.0
Get ( CurrentDate ) Get 6.0
Get ( CurrentExtendedPrivileges ) Get 6.0
Get ( CurrentHostTimestamp ) Get 7.0
Get ( CurrentPrivilegeSetName ) Get 6.0
Get ( CurrentTime ) Get 6.0
Get ( CurrentTimestamp ) Get 6.0
Get ( CurrentTimeUTCMilliseconds ) Get 13.0
Get ( CustomMenuSetName ) Get 8.0
Get ( DesktopPath ) Get 8.0
Get ( Device ) Get 13.0
Get ( DocumentsPath ) Get 8.0
Get ( DocumentsPathListing ) Get 10.0
Get ( EncryptionState ) Get 13.0
Get ( ErrorCaptureState ) Get 7.0
Get ( FileMakerPath ) Get 8.0
Get ( FileName ) Get 6.0
Get ( FilePath ) Get 6.0
Get ( FileSize ) Get 6.0
Get ( FoundCount ) Get 6.0
Get ( HighContrastColor ) Get 6.0
Get ( HighContrastState ) Get 6.0
Get ( HostApplicationVersion ) Get 9.0
Get ( HostIPAddress ) Get 8.0
Get ( HostName ) Get 6.0
Get ( InstalledFMPlugins) Get 12.0
Get ( LastError ) Get 6.0
Get ( LastMessageChoice ) Get 6.0
Get ( LastODBCError ) Get 6.0
Get ( LayoutAccess ) Get 6.0
Get ( LayoutCount ) Get 6.0
Get ( LayoutName ) Get 6.0
Get ( LayoutNumber ) Get 6.0
Get ( LayoutTableName ) Get 7.0
Get ( LayoutViewState ) Get 6.0
Get ( MenubarState ) Get 14.0
Get ( ModifiedFields ) Get 13.0
Get ( MultiUserState ) Get 6.0
Get ( NetworkProtocol ) Get 6.0
Get ( NetworkType ) Get 13.0
Get ( PageNumber ) Get 6.0
Get ( PersistentID ) Get 12.0
Get ( PreferencesPath ) Get 8.0
Get ( PrinterName ) Get 6.0
Get ( QuickFindText ) Get 11.0
Get ( RecordAccess ) Get 6.0
Get ( RecordID ) Get 6.0
Get ( RecordModificationCount ) Get 6.0
Get ( RecordNumber ) Get 6.0
Get ( RecordOpenCount ) Get 8.0
Get ( RecordOpenState ) Get 8.0
Get ( RequestCount ) Get 6.0
Get ( RequestOmitState ) Get 8.0
Get ( ScreenDepth ) Get 6.0
Get ( ScreenHeight ) Get 6.0
Get ( ScreenScaleFactor ) Get 13.02
Get ( ScreenWidth ) Get 6.0
Get ( ScriptAnimationState ) Get 13.0
Get ( ScriptName ) Get 6.0
Get ( ScriptParameter ) Get 7.0
Get ( ScriptResult ) Get 8.0
Get ( SortState ) Get 6.0
Get ( StatusAreaState ) Get 6.0
Get ( SystemDrive ) Get 8.0
Get ( SystemIPAddress ) Get 7.0
Get ( SystemLanguage ) Get 6.0
Get ( SystemNICAddress ) Get 7.0
Get ( SystemPlatform ) Get 6.0
Get ( SystemVersion ) Get 6.0
Get ( TemporaryPath ) Get 9.0
Get ( TextRulerVisible ) Get 8.0
Get ( TotalRecordCount ) Get 6.0
Get ( TouchKeyboardState ) Get 14.0
Get ( TriggerCurrentPanel ) Get 12.0
Get ( TriggerExternalEvent ) Get 14.0
Get ( TriggerGestureInfo ) Get 13.0
Get ( TriggerKeystroke ) Get 10.0
Get ( TriggerModifierKeys ) Get 10.0
Get ( TriggerTargetPanel ) Get 12.0
Get ( UserCount ) Get 6.0
Get ( UserName ) Get 6.0
Get ( UseSystemFormatsState ) Get 8.0
Get ( UUID ) Get 12.0
Get ( WindowContentHeight ) Get 7.0
Get ( WindowContentWidth ) Get 7.0
Get ( WindowDesktopHeight ) Get 7.0
Get ( WindowDesktopWidth ) Get 7.0
Get ( WindowHeight ) Get 7.0
Get ( WindowLeft ) Get 7.0
Get ( WindowMode ) Get 6.0
Get ( WindowName ) Get 7.0
Get ( WindowOrientation ) Get 13.0
Get ( WindowStyle ) Get 12.0
Get ( WindowTop ) Get 7.0
Get ( WindowVisible ) Get 7.0
Get ( WindowWidth ) Get 7.0
Get ( WindowZoomLevel ) Get 8.0
GetAsBoolean ( data ) Logical 8.0
GetAsCSS ( text ) Text 7.0
GetAsDate ( text ) Text 6.0
GetAsNumber ( text ) Text 6.0
GetAsSVG ( text ) Text 7.0
GetAsText ( data ) Text 6.0
GetAsTime ( text ) Text 6.0
GetAsTimestamp ( text ) Text 7.0
GetAsURLEncoded ( text ) Text 8.5
GetAVPlayerAttribute ( attributeName ) Logical 14.0
GetContainerAttribute ( sourceField ; attributeName ) Container 13.0
GetField ( fieldName ) Logical 6.0
GetFieldName ( fieldName ) Logical 10.0
GetHeight ( field ) Container 12.0
GetLayoutObjectAttribute ( objectName ; attributeName { ; repetitionNumber ; portalRowNumber } ) Logical 8.5
GetNextSerialValue ( fileName ; fieldName ) Design 6.0
GetNthRecord ( fieldName ; recordNumber ) Logical 8.0
GetRepetition ( repeatingField ; number ) Repeating 6.0
GetSummary ( summaryField ; breakField ) Summary 6.0
GetThumbnail ( field ; width ; height ) Container 12.0
GetValue ( listOfValues ; valueNumber ) Text 8.0
GetWidth ( field ) Container 12.0
Hiragana ( text ) Text 6.0
Hour ( time ) Time 6.0
If ( test ; result1 ; result2 ) Logical 6.0
Int ( number ) Number 6.0
IsEmpty ( field ) Logical 6.0
IsValid ( field ) Logical 6.0
IsValidExpression ( expression ) Logical 7.0
KanaHankaku ( text ) Text 6.0
KanaZenkaku ( text ) Text 6.0
KanjiNumeral ( text ) Text 6.0
Katakana ( text ) Text 6.0
Last ( field ) Repeating 6.0
LayoutIDs ( fileName ) Design 6.0
LayoutNames ( fileName ) Design 6.0
LayoutObjectNames ( fileName ; layoutName ) Design 8.5
Left ( text ; numberOfCharacters ) Text 6.0
LeftValues ( text ; numberOfValues ) Text 7.0
LeftWords ( text ; numberOfWords ) Text 6.0
Length ( field ) Text 6.0
Let ( { [ } var1 = expression1 { ; var2 = expression2... ] } ; calculation ) Logical 7.0
Lg ( number ) Number 7.0
List ( field { ; field... } ) Aggregate 8.5
Ln ( number ) Number 6.0
Location ( accuracy { ; timeout } ) Mobile 12.0
LocationValues ( accuracy { ; timeout } ) Mobile 12.0
Log ( number ) Number 6.0
Lookup ( sourceField { ; failExpression } ) Logical 7.0
LookupNext ( sourceField ; lower/higherFlag ) Logical 7.0
Lower ( text ) Text 6.0
Max ( field { ; field... } ) Aggregate 6.0
Middle ( text ; start ; numberOfCharacters ) Text 6.0
MiddleValues ( text ; startingValue ; numberOfValues ) Text 7.0
MiddleWords( text ; startingWord ; numberOfWords ) Text 6.0
Min ( field { ; field... } ) Aggregate 6.0
Minute ( time ) Time 6.0
Mod ( number ; divisor ) Number 6.0
Month ( date ) Date 6.0
MonthName ( date ) Date 6.0
MonthNameJ ( date ) Date 6.0
NPV ( payment ; interestRate ) Financial 6.0
NumToJText ( number ; separator ; characterType ) Text 6.0
PatternCount ( text ; searchString ) Text 6.0
Pi Trigonometric 6.0
PMT ( principal ; interestRate ; term ) Financial 6.0
Position ( text ; searchString ; start ; occurrence ) Text 6.0
Proper ( text ) Text 6.0
PV ( payment ; interestRate ; periods ) Financial 6.0
Quote ( text ) Text 7.0
Radians ( angleInDegrees ) Trigonometric 6.0
Random Number 6.0
RelationInfo ( fileName ; tableName ) Design 6.0
Replace ( text ; start ; numberOfCharacters ; replacementText ) Text 6.0
RGB ( red ; green ; blue ) Text formatting 7.0
Right ( text ; numberOfCharacters ) Text 6.0
RightValues ( text ; numberOfValues ) Text 7.0
RightWords ( text ; numberOfWords ) Text 6.0
RomanHankaku ( text ) Text 6.0
RomanZenkaku ( text ) Text 6.0
Round ( number ; precision ) Number 6.0
ScriptIDs ( fileName ) Design 6.0
ScriptNames ( fileName ) Design 6.0
Seconds ( time ) Time 6.0
Self Logical 9.0
SerialIncrement ( text ; incrementBy ) Text 7.0
SetPrecision ( expression ; precision ) Number 7.0
Sign ( number ) Number 6.0
Sin ( angleInRadians ) Trigonometric 6.0
Sqrt ( number ) Number 6.0
StDev ( field { ; field... } ) Aggregate 6.0
StDevP ( field { ; field... } ) Aggregate 6.0
Substitute ( text ; searchString ; replaceString ) Text 6.0
Sum ( field { ; field... } ) Aggregate 6.0
TableIDs ( fileName ) Design 6.0
TableNames ( fileName ) Design 6.0
Tan ( angleInRadians ) Trigonometric 6.0
TextColor ( text ; RGB ( red ; green ; blue ) ) Text formatting 7.0
TextColorRemove ( text { ; RGB ( red ; green ; blue ) } ) Text formatting 8.0
TextFont ( text ; fontName { ; fontScript } ) Text formatting 7.0
TextFontRemove ( text { ; fontToRemove ; fontScript } ) Text formatting 8.0
TextFormatRemove ( text ) Text formatting 8.0
TextSize ( text ; fontSize ) Text formatting 7.0
TextSizeRemove ( text { ; sizeToRemove } ) Text formatting 8.0
TextStyleAdd ( text ; styles ) Text formatting 7.0
TextStyleRemove ( text ; styles ) Text formatting 7.0
Time ( hours ; minutes ; seconds ) Time 6.0
Timestamp ( date ; time ) Timestamp 7.0
Trim ( text ) Text 6.0
TrimAll ( text ; trimSpaces ; trimType ) Text 6.0
Truncate ( number ; precision ) Number 6.0
Upper ( text ) Text 6.0
ValueCount ( text ) Text 7.0
ValueListIDs ( fileName ) Design 6.0
ValueListItems ( fileName ; valuelist ) Design 6.0
ValueListNames ( fileName ) Design 6.0
Variance ( field { ; field... } ) Aggregate 7.0
VarianceP ( field { ; field... } ) Aggregate 7.0
VerifyContainer ( field ) Container 12.0
WeekOfYear ( date ) Date 6.0
WeekOfYearFiscal ( date ; startingDay ) Date 6.0
WindowNames { ( fileName ) } Design 6.0
WordCount ( text ) Text 6.0
Year ( date ) Date 6.0
YearName ( date ; format ) Date 6.0

This evolving document was built on information from the community and made better by contributions from many. Free to give us feedback here.

Some useful links:

Thanks to all those who helped make this document better. Remaining errors are ours. Here are some of the people who shared useful suggestions (listed alphabetically):

  • Name, Org. (edit)

If you have any questions, please feel free to contact us.

Thanks.

FileMaker is a trademark of FileMaker, Inc. Tony White Designs, Inc. is an independent entity. This document has not been authorized, sponsored, or otherwise affiliated with FileMaker, Inc.

 

Valid XHTML 1.0 Strict