Functions Reference

ManualsBrandsClaris FileMaker ManualsApplicationsFileMaker Pro 15

261

262

263

264

265

266

267

268

269

270

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

Number functions

ILEMAKER PRO FUNCTIONS REFERENCE 263

Log

Purpose

Returns the base-10 (common) logarithm of a number.

Format

Log(number)

Parameters

number - any positive numeric expression or field containing a numeric expression

Data type returned

number

Originated in

FileMaker Pro 6.0 or earlier

Description

Number can be any positive value. Negative values return an error. For 0, the Log function returns

nothing because this value is out of the acceptable range.

Log

Ln number()

Ln 10()

---------------------------------

Examples

Log(1) returns 0.

Log(100) returns 2.