Home > Store > Computer Software > Business Office Software > Database Software > Other

FileMaker 8 Calculation Functions (Digital Short Cut)

Register your product to gain access to bonus material or receive a coupon.

FileMaker 8 Calculation Functions (Digital Short Cut)

eBook (Watermarked)

  • Your Price: $12.99
  • About Watermarked eBooks
  • This PDF will be accessible from your Account page after purchase and requires the free Adobe® Reader® software to read it.

    The eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.

    Watermarked eBook FAQ

Description

  • Copyright 2007
  • Dimensions: 7 X 9-1/8
  • Pages: 156
  • Edition: 1st
  • eBook (Watermarked)
  • ISBN-10: 0-7686-6834-4
  • ISBN-13: 978-0-7686-6834-6

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.

Sample Content

Excerpts

Download PDF (1.90 MB)

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

Updates

Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership