Chapter 24 contains a complete reference guide to using FileMaker’s built in Mobile functions. The following functions are discussed in this chapter: Mobile Function Reference Location LocationValues RangeBeacons << Previous Chapter Chapter Index Next Chapter >>

Chapter 23 contains a complete reference guide to using FileMaker’s built in Design functions. The following functions are discussed in this chapter: DatabaseNames FieldBounds FieldComment FieldIDs FieldNames FieldRepetitions FieldStyle FieldType GetNextSerialValue LayoutIDs LayoutNames LayoutObjectName RelationInfo ScriptIDs ScriptNames TableIDs TableNames ValueListIDs ValueListItems ValueListNames WindowNames << Previous Chapter Chapter Index Next Chapter >>

Chapter 22 contains a complete reference guide to using FileMaker’s built in Get functions. The following functions are discussed in this chapter: Get ( AccountExtendedPrivileges ) Get ( AccountName ) Get ( AccountPrivilegeSetName ) Get ( ActiveFieldContents ) Get ( ActiveFieldName ) Get ( ActiveFieldTableName ) Get ( ActiveLayoutObjectName ) Get ( ActiveModifierKeys ) Get ( ActivePortalRowNumber ) Get (… read more →

Chapter 21 contains a complete reference guide to using FileMaker’s built in logical functions. The following functions are discussed in this chapter: Logical Function Reference Case Choose Evaluate EvaluationError ExecuteSQL GetAsBoolean GetAVPlayerAttribute GetField GetFieldName GetLayoutObjectAttribute GetNthRecord If IsEmpty IsValid IsValidExpression Let Lookup LookupNext Self << Previous Chapter Chapter Index Next Chapter >>

Chapter 20 contains a complete reference guide to using FileMaker’s built in financial and trigonometric functions. The following functions are discussed in this chapter: Financial Function Reference FV NPV PMT PV Trigonometric Function Reference Acos Asin Atan Cos Degrees Pi Radians Sin Tan << Previous Chapter Chapter Index Next Chapter >>

Chapter 19 contains a complete reference guide to using FileMaker’s built in aggregate, summary and repeating functions. The following functions are discussed in this chapter: Aggregate Function Reference Average Count List Max Min Steve StDevP Sum Variance VarianceP Summary Function Reference GetSummary Repeating Function Reference Extend GetRepetition Last << Previous Chapter Chapter Index Next Chapter >>

Chapter 18 contains a complete reference guide to using FileMaker’s built in container functions. The following functions are discussed in this chapter: Container Function Reference Base64Decode Base64Encode Base64EncodeRFC GetContainerAttribute GetHeight GetThumbnail GetWidth VerifyContainer << Previous Chapter Chapter Index Next Chapter >>

Chapter 17 contains a complete reference guide to using FileMaker’s built in Date, Time and Timestamp functions. The following functions are discussed in this chapter: Date Function Reference Date Day Day Name DayNameJ DayOfWeek DayOfYear Month MonthName MonthNameJ WeekOfYear WeekOfYearFiscal Year YearName Time Function Reference Hour Minute Second Time Timestamp Function Reference Timestamp << Previous Chapter Chapter Index Next Chapter… read more →

Chapter 16 contains a complete reference guide to using FileMaker’s built in Number functions. The following functions are discussed in this chapter: Number Function Reference Abs Ceiling Combination Div Exp Factorial Floor Int Lg Ln Log Mod Random Round SetPrecision Sign Sqrt Truncate << Previous Chapter Chapter Index Next Chapter >>

Chapter 15 contains a complete reference guide to using FileMaker’s built in Text Formatting Functions. The following functions are discussed in this chapter: Text Formatting Function Reference RGB TextColor TextColorRemove TextFont TextFontRemove TextSize TextSizeRemove TextStyleAdd TextStyleRemove << Previous Chapter Chapter Index Next Chapter >>