O'Reilly logo

FileMaker 9 Developer Reference: Functions, Scripts, Commands, and Grammars, with Extensive Custom Function Examples by Steve Lane, Scott Love, Bob Bowers

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Examples:

If( DayOfWeek (Get ( CurrentDate ))) = 1 ;  "It's Sunday, no work!"; // true result  "Get back to work!" // false result)If ( myFlagField; graphicTrue; graphicFalse )

Looks for a true value (nonzero, nonblank) in myFlagField and displays the correct graphic container.

If ( not IsEmpty ( Taxable ) and TaxRate > 0;   Price + (Price * TaxRate);   Price)

Int()

Syntax:

Int ( number )

Data type returned: Number                   Category: Number

Parameters:

number—Any expression that resolves to a numeric value.

Description:

Returns the whole number (integer) part of the number parameter without rounding. Digits to the right of the decimal point are dropped.

Note that for positive numbers, Floor() and Int() return the same results; ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required