Functions Reference

ManualsBrandsClaris FileMaker ManualsApplicationsFileMaker Pro 15

131

132

133

134

135

136

137

138

139

140

Table Of Contents

Script steps 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(LastExternalErrorDetail)
- Get(LastMessageChoice)
- 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
- RangeBeacons
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 PRO FUNCTIONS REFERENCE 136

Get(FoundCount)

Purpose

Returns the number of records in the current found set.

Format

Get(FoundCount)

Parameters

None

Data type returned

number

Originated in

FileMaker Pro 6.0 or earlier

Description

If there are multiple windows open in the current database file, each window can have its own found

count value, but results are returned for only the foreground window.

If you specify the context for the current calculation, this function will be evaluated based on that

context; otherwise, it will be evaluated based on the context of the current window.

Examples

Returns 7 when there are seven records in the current found set. For example scripts, see If script

step.