Functions Reference

ManualsBrandsClaris FileMaker ManualsApplicationsFileMaker Pro 15

151

152

153

154

155

156

157

158

159

160

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 157

Get(PageNumber)

Purpose

Returns a number representing the current page being printed or previewed.

Format

Get(PageNumber)

Parameters

None

Data type returned

number

Originated in

FileMaker Pro 6.0 or earlier

Description

If nothing is being printed or previewed, 0 is returned.

Notes

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

Examples

Returns 4 when page 4 is being printed or previewed.