FileMaker 8 Calculation Functions (Digital Short Cut)

The calculation dialog in FileMaker serves as a fundamental element in nearly all development activities. The calculation dialog allows developers easy access to the data fields in their solutions and to a complete function list. This Short Cut presents a complete description of each calculation function, lists examples, and in many cases offers additional comments on usage.

 

This Short Cut is Chapter 6 from the book FileMaker 8 Functions and Scripts Desk Reference by Scott Love, Steve Lane, and Bob Bowers (0-7897-3511-3).  As such, it contains references pointing you to additional information not found in this Short Cut, but in a companion book, Special Edition Using FileMaker 8. Apart from this reference, the Short Cut is fully self-contained and is an excellent sampling of calculation functions.

Table of Contents

Abs()

Atan()

Average()

Case()

Ceiling()

Choose()

Combination()

Cos()

Count()

DatabaseNames

Date()

Day()

DayName()

DayNameJ()

DayOfWeek()

DayOfYear()

Degrees()

Div()

Evaluate()

EvaluationError()

Exact()

Exp()

Extend()

External()

Factorial()

FieldBounds()

FieldComment()

FieldIDs()

FieldNames()

FieldRepetitions()

FieldStyle()

FieldType()

Filter()

FilterValues()

Floor()

FV()

Get(AccountName)

Get(ActiveFieldContents)

Get(ActiveFieldName)

Get(ActiveFieldTableName)

Get(ActiveModifierKeys)

Get(ActiveRepetitionNumber)

Get(ActiveSelectionSize)

Get(ActiveSelectionStart)

Get(AllowAbortState)

Get(AllowToolbarState)

Get(ApplicationLanguage)

Get(ApplicationVersion)

Get(CalculationRepetitionNumber)

Get(CurrentDate)

Get(CurrentHostTimestamp)

Get(CurrentTime)

Get(CurrentTimestamp)

Get(CustomMenuSetName)

Get(DesktopPath)

Get(DocumentsPath)

Get(ErrorCaptureState)

Get(ExtendedPrivileges)

Get(FileSize)

Get(FoundCount)

Get(HighContrastColor)

Get(HighContrastState)

Get(HostIPAddress)

Get(HostName)

Get(LastError)

Get(LastMessageChoice)

Get(LastODBCError)

Get(LayoutAccess)

Get(LayoutCount)

Get(LayoutName)

Get(LayoutNumber)

Get(LayoutTableName)

Get(LayoutViewState)

Get(MultiUserState)

Get(NetworkProtocol)

Get(PageNumber)

Get(PortalRowNumber)

Get(PreferencesPath)

Get(PrinterName)

Get(PrivilegeSetName)

Get(RecordAccess)

Get(RecordID)

Get(RecordModificationCount)

Get(RecordNumber)

Get(RecordOpenCount)

Get(RecordOpenState)

Get(RequestCount)

Get(RequestOmitState)

Get(ScreenDepth)

Get(ScreenHeight)

Get(ScreenWidth)

Get(ScriptName)

Get(ScriptParameter)

Get(ScriptResult)

Get(SortState)

Get(StatusAreaState)

Get(SystemDrive)

Get(SystemIPAddress)

Get(SystemLanguage)

Get(SystemNICAddress)

Get(SystemPlatform)

Get(SystemVersion)

Get(TextRulerVisible)

Get(TotalRecordCount)

Get(UserCount)

Get(UserName)

Get(UseSystemFormatsState)

Get(WindowContentHeight)

Get(WindowContentWidth)

Get(WindowDesktopHeight)

Get(WindowDesktopWidth)

Get(WindowHeight)

Get(WindowLeft)

Get(WindowMode)

Get(WindowName)

Get(WindowTop)

Get(WindowVisible)

Get(WindowWidth)

Get(WindowZoomLevel)

GetAsBoolean()

GetAsCSS()

GetAsDate()

GetAsNumber()

GetAsSVG()

GetAsText()

GetAsTime()

GetAsTimestamp()

GetField()

GetNextSerialValue()

GetNthRecord()

GetRepetition()

GetSummary()

GetValue()

Hiragana()

Hour()

If()

Int()

IsEmpty()

IsValid()

IsValidExpression()

KanaHankaku()

KanaZenkaku()

KanjiNumeral()

Katakana()

Last()

LayoutIDs()

LayoutNames()

Left()

LeftValues()

LeftWords()

Length()

Length()

Lg()

Ln()

Log()

Lookup()

LookupNext()

Lower()

Max()

Middle()

MiddleValues()

MiddleWords()

Min()

Minute()

Mod()

Month()

MonthName()

MonthNameJ()

NPV()

NumToJText()

PatternCount()

Pi

PMT()

Position()

Proper()

PV()

Quote()

Radians()

Random

RelationInfo()

Replace()

RGB()

Right()

RightValues()

RightWords()

RomanHankaku()

RomanZenkaku()

Round()

ScriptIDs()

ScriptNames()

Seconds()

SerialIncrement()

SetPrecision()

Sign()

Sin()

Sqrt()

StDev()

StDevP()

Substitute()

Sum()

TableIDs()

TableNames()

Tan()

TextColor()

TextColorRemove()

TextFont()

TextFontRemove()

TextFormatRemove()

TextSize()

TextSizeRemove()

TextStyleAdd()

TextStyleRemove()

Time()

Timestamp()

Trim()

TrimAll()

Truncate()

Upper()

ValueCount()

ValueListIDs()

ValueListItems()

ValueListNames()

Variance()

VarianceP()

WeekOfYear()

WeekOfYearFiscal()

WindowNames

WordCount()

Year()

YearName()

 

Excerpts

Download PDF (1.90 MB)