FileMaker 15 Functions

This FileMaker platform training document:

Is a simple, easy to read list of all the functions in FileMaker 15
Includes the Type and the version of FileMaker where the Function was Introduced
Is sortable...click on the header to sort by Function signature, Type or Introduced header
Links to the source documents from FileMaker, Inc.
Pairs well with FileMaker 15 Script Step Compatibility, FileMaker 15 Script Trigger Compatibility and BaseElements Plugin Functions
* We renamed 13.0.2 to 13.02 so that the sorting works

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
External	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 ( LastExternalErrorDetail )	Get	6.0
Get ( LastMessageChoice )	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
RangeBeacons	Number	15.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.