FileMaker 8 Calculation Functions (Digital Short Cut)

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()