Logical Functions

Logical functions allow comparative tests to be evaluated and return differing results based on those comparisons. They also allow you to work with variables.

Table 5.7. Logical Functions

Syntax

Data Type Returned

Case ( test1; result1 {; test2; result2; defaultResult...} )

Text, Number, Date, Time, Timestamp, Container

Choose ( test; result0 {; result1; result2...} )

Text, Number, Date, Time, Timestamp, Container

Evaluate ( expression {; [ field1; field2; ...]} )

Text, Number, Date, Time, Timestamp, Container

EvaluationError ( expression )

Number

GetAsBoolean ( data )

Number

GetField ( fieldName )

Text, Number, Date, Time, Timestamp, Container

GetNthRecord ( fieldName; recordNumber )

Text, Number, Date, Time, Timestamp, Container

If ( test; result1; result2 )

Text, Number, Date, Time, Timestamp, Container

IsEmpty ( expression )

Number

IsValid ( expression )

Number

IsValidExpression ( expression )

Number

Let ( {[} var1=expression1 {; var2=expression2 ...]}; calculation )

Text, Number, Date, Time, Timestamp, Container

Lookup ( sourceField {; failExpression })

Text, Number, Date, Time, Timestamp, Container

LookupNext ( sourceField; lower/higher Flag )

Text, Number, Date, Time, Timestamp, Container

Quote ( text )

Text


: FileMaker Specifications

FileMaker 8 Product Line

Specifications and Storage Limits

Field Types and Import/Export Formats

: Calculation Functions

Working with Calculations Primer

Calculation Signatures

Calculation Functions

: Custom Functions

Custom Functions Primer

Useful Custom Functions

: Script Steps

Scripting Primer

Script Step Reference

: Quick Reference

FileMaker Error Codes

FileMaker Keyboard Shortcuts

FileMaker Network Ports

FileMaker Server Command Line Reference

FileMaker XML Reference

: Other Resources

Where to Go for More Information



FileMaker 8 Functions and Scripts Desk Reference
FileMaker 8 Functions and Scripts Desk Reference
ISBN: 0789735113
EAN: 2147483647
Year: 2004
Pages: 352

Flylib.com © 2008-2020.
If you may any questions please contact us: flylib@qtcs.net