- Shopping Bag ( 0 items )
Want a NOOK? Explore Now
This is the eBook version of the printed book.
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.
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()
Overview
This is the eBook version of the printed book.
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 ...