Functions Reference

ManualsBrandsClaris FileMaker ManualsApplicationsFileMaker Pro 14

131

132

133

134

135

136

137

138

139

140

Table Of Contents

Contents
Functions reference (alphabetical list)
About functions
- Working with formulas and functions
- Using this functions reference
Aggregate functions
- Average
- Count
- List
- Max
- Min
- StDev
- StDevP
- Sum
- Variance
- VarianceP
Container functions
- Base64Decode
- Base64Encode
- GetContainerAttribute
- GetHeight
- GetThumbnail
- GetWidth
- VerifyContainer
Date functions
- Date
- Day
- DayName
- DayNameJ
- DayOfWeek
- DayOfYear
- Month
- MonthName
- MonthNameJ
- WeekOfYear
- WeekOfYearFiscal
- Year
- YearName
Design functions
- DatabaseNames
- FieldBounds
- FieldComment
- FieldIDs
- FieldNames
- FieldRepetitions
- FieldStyle
- FieldType
- GetNextSerialValue
- LayoutIDs
- LayoutNames
- LayoutObjectNames
- RelationInfo
- ScriptIDs
- ScriptNames
- TableIDs
- TableNames
- ValueListIDs
- ValueListItems
- ValueListNames
- WindowNames
External functions
- External
Financial functions
- FV
- NPV
- PMT
- PV
Get functions
- 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(ApplicationArchitecture)
- 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(MenubarState)
- 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(ScreenScaleFactor)
- 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(TouchKeyboardState)
- Get(TriggerCurrentPanel)
- Get(TriggerExternalEvent)
- 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)
Logical functions
- Case
- Choose
- Evaluate
- EvaluationError
- ExecuteSQL
- GetAsBoolean
- GetAVPlayerAttribute
- GetField
- GetFieldName
- GetLayoutObjectAttribute
- GetNthRecord
- If
- IsEmpty
- IsValid
- IsValidExpression
- Let
- Lookup
- LookupNext
- Self
Mobile functions
- Location
- LocationValues
Number functions
- Abs
- Ceiling
- Combination
- Div
- Exp
- Factorial
- Floor
- Int
- Lg
- Ln
- Log
- Mod
- Random
- Round
- SetPrecision
- Sign
- Sqrt
- Truncate
Repeating functions
- Extend
- GetRepetition
- Last
Summary functions
- GetSummary
Text functions
- Char
- Code
- Exact
- Filter
- FilterValues
- Furigana
- GetAsCSS
- GetAsDate
- GetAsNumber
- GetAsSVG
- GetAsText
- GetAsTime
- GetAsTimestamp
- GetAsURLEncoded
- GetValue
- Hiragana
- KanaHankaku
- KanaZenkaku
- KanjiNumeral
- Katakana
- Left
- LeftValues
- LeftWords
- Length
- Lower
- Middle
- MiddleValues
- MiddleWords
- NumToJText
- PatternCount
- Position
- Proper
- Quote
- Replace
- Right
- RightValues
- RightWords
- RomanHankaku
- RomanZenkaku
- SerialIncrement
- Substitute
- Trim
- TrimAll
- Upper
- ValueCount
- WordCount
Text formatting functions
- RGB
- TextColor
- TextColorRemove
- TextFont
- TextFontRemove
- TextFormatRemove
- TextSize
- TextSizeRemove
- TextStyleAdd
- TextStyleRemove
Time functions
- Hour
- Minute
- Seconds
- Time
Timestamp functions
- Timestamp
Trigonometric functions
- Acos
- Asin
- Atan
- Cos
- Degrees
- Pi
- Radians
- Sin
- Tan
Glossary

Get functions

ILEMAKER FUNCTIONS REFERENCE 138

Get(FileMakerPath)

Purpose

Returns the path to the folder of the currently running copy of FileMaker Pro.

Format

Get(FileMakerPath)

Parameters

None

Data type returned

text

Originated in

FileMaker Pro 8.0

Description

In Windows, the path format is /Drive:/Program Files/FileMaker/FileMaker Pro 14/.

In OS X, the path format is /DriveName/Applications/FileMaker Pro 14/.

Notes

• In FileMaker WebDirect, this function is not supported and returns an empty string.

• For information on how functions evaluate differently on the host versus the client, search

the FileMaker Knowledge Base available at

http://help.filemaker.com.

Examples

Returns /C:/Program Files/FileMaker/FileMaker Pro 14/ in Windows.

Returns /MacintoshHD/Applications/FileMaker Pro 14/ in OS X.