GetNthRowObjectList( ObjectList; N; delim )
Get data from named layout objects such as fields in portals or record lists. - Submitted by Bruce Robertson

Thu, 15 May 2008 10:59:02 -0700

PVofFV ( FutureVal , Interest , Term )
Present Value of a Future Value - Submitted by Barry Maskell

Sat, 10 May 2008 18:52:04 -0700

Edate ( thedate ; months )
Excel style EDATE function - Submitted by Barry Maskell

Sat, 10 May 2008 17:21:44 -0700

FormatDate( DatetoFormat )
//Returns Mon, Dec 8 - Submitted by Catherine Dillimore

Thu, 08 May 2008 18:05:46 -0700

Ceiling ( number )
Type: Number

Result: Number

Description: Returns a number rounded up to the next integer.

Example 1: Ceiling ( 5.25 ) = 6

Versions: 7, 8, 8.5, 9

Reference: FileMaker's Online Help

Tomorrow's Function: Combination ( setSize; numberOfChoices )

Wed, 14 May 2008 07:01:01 GMT

Abs ( number )
Type: Number

Result: Number

Description: Returns the absolute (positive value) of the number supplied.

Example 1: Abs( -456 ) = 456
A nice method for using a boolean toggle on a number field set as a checkbox.

Example 2: Abs( Checkbox - 1 )
Negative sign is stripped.

Versions: 3, 4, 5, 5.5, 6, 7, 8, 8.5, 9

Reference: FileMaker's Online Help

Tomorrow's Function: Ceiling ( number )

Tue, 13 May 2008 07:01:01 GMT

TextStyleRemove ( text; styles )
Type: Text Formatting

Result: Text

Description: Removes the specified styles from the text. The style "plain" is ignored. Styles are not case-sensitive and do not contain spaces. You can remove multiple styles by using the + operator between style names. Negative values are not valid. Plain is ignored if intermingled with other styles. Style options include [Bold, Italics, Underline, WordUnderline, DoubleUnderline, Condense, Extend, Strikethru, SmallSaps, Uppercase, Lowercase, Titlecase, Superscript, Subscript, AllStyles]

Example 1: TextStyleRemove( Resume; Italic + Bold )
removes bold and italic formatting from the supplied field

Example 2: TextStyleRemove( FirstName; AllStyles )
removes all style formatting from the supplied field

Versions: 7, 8, 8.5, 9

Reference: FileMaker's Online Help

Tomorrow's Function: Abs ( number )

Mon, 12 May 2008 07:01:00 GMT

TextStyleAdd ( text; styles )
Type: Text Formatting

Result: Text

Description: Applies the specified styles to the text supplied. The style "plain" can be used to remove all other styles. Styles are not case-sensitive and do not contain spaces. You can add multiple styles by using the + operator between style names. Negative values are not valid. Plain is ignored if intermingled with other styles. Style options include [Bold, Italics, Underline, WordUnderline, DoubleUnderline, Condense, Extend, Strikethru, SmallSaps, Uppercase, Lowercase, Titlecase, Superscript, Subscript, AllStyles]

Example 1: TextStyleAdd( StyledField; Plain )
removes all other styles applied to the text in the field

Example 2: TextStyleAdd( WebSiteDomain; Bold + Underline )
adds bold and underline style to the field WebSiteDomain

Versions: 7, 8, 8.5, 9

Reference: FileMaker's Online Help

Tomorrow's Function: TextStyleRemove ( text; styles )

Sun, 11 May 2008 07:01:00 GMT