Last()

Last()

Category: Repeating

Syntax: Last ( field )

Parameters: field ”any repeating field or related field.

Description: If the specified field is a repeating field, Last() returns the last valid, non-blank value in the field. If the specified field is a related field, it returns the last non-blank value from the set of related records. The order of the set of related records is determined by the sort order of the relationship. If no sort order has been specified, then the creation order is used.

Examples:

When RepPercentage is a repeating field with the values .04, .05, and .06, Last (RepPercentage) returns .06 .

 Last (PhoneNumber::Number) 

Returns the most recent phone number entry, assuming no sort is specified for the relationship.