HAPPY BOOKSGIVING
Use code BOOKSGIVING during checkout to save 40%-55% on books and eBooks. Shop now.
Register your product to gain access to bonus material or receive a coupon.
This PDF will be accessible from your Account page after purchase and requires PDF reading software, such as Acrobat® Reader®.
The eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.
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.
Download PDF (1.90 MB)
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()