FileMaker 8 Functions and Scripts Desk Reference

ISBN: 0789735113
EAN: 2147483647

Year: 2004
Pages: 352

Authors: Scott Love, Steve Lane, Bob Bowers

BUY ON AMAZON

: FileMaker Specifications

FileMaker 8 Product Line

• Overview of FileMaker Products

Specifications and Storage Limits

• Knowing Your Limits

Field Types and Import/Export Formats

• Knowing Your Data
• FileMaker Field Types
• Importing Data
• Exporting Data

: Calculation Functions

Working with Calculations Primer

• Working with Calculations Primer
• The Calculation Function Interface

Calculation Signatures

• Calculation Signatures
• Aggregate Functions
• Date Functions
• Design Functions
• External Functions
• Financial Functions
• Get Functions
• Logical Functions
• Number Functions
• Repeating Functions
• Summary Functions
• Text Functions
• Text Formatting Functions
• Time Functions
• Timestamp Functions
• Trigonometric Functions

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(FileMakerPath)
• Get(FileName)
• Get(FilePath)
• 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()
• Let()
• 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()

: Custom Functions

Custom Functions Primer

• Custom Functions Primer
• The Custom Function Interface

Useful Custom Functions

• Useful Custom Functions
• Number Calculations
• Date Calculations
• Text and Data Conversions
• Email Tools
• Developer Tools
• System Constants
• Toolkit for Complex Data Structures

: Script Steps

Scripting Primer

• About FileMaker Scripting

Script Step Reference

• About the Script Step Reference

: Quick Reference

FileMaker Error Codes

• Error Codes in FileMaker

FileMaker Keyboard Shortcuts

• Working Quickly, Saving Time
• Essential Shortcuts by Group
• Menu Reference

FileMaker Network Ports

• About Network Ports
• FileMaker Network Ports

FileMaker Server Command Line Reference

• Administering FileMaker Server from the Command Line
• Command Line Reference

FileMaker XML Reference

• FileMaker XML Reference
• About FileMaker and XML
• URL Syntax for Web Access to FileMaker Data
• FileMaker XML Grammars
• Query Parameters for XML/XSLT URL Requests
• FileMaker XML and XSLT Namespaces

: Other Resources

Where to Go for More Information

• Where to Go for More Information
• FileMaker
• General Information on Relational Databases
• Data Modeling and Database Design
• Project Management, Programming, and Software Development
• Running a FileMaker Consulting Practice
• General Resources for Tips and Tricks
• Hosting FileMaker Databases on the Web
• FileMaker News Sources
• Developer Tools
• Web Programming
• PHP
• ODBC/JDBC