GetField()

Category: Logical

Syntax: GetField ( fieldName )

Parameters:

fieldNameA text string, or field or expression that returns a text string, which contains the name of a field.

Data type returned: Text, Number, Date, Time, Timestamp, Container

Description:

Returns the contents of the fieldName field.

Essentially, GetField() provides a level of abstraction when retrieving the contents of a field. Instead of saying "Give me the value of the FirstName field," for instance, it's like saying "Give me the value of the field whose name is in the gWhatField field." By putting a different field name in the gWhatField field, you can retrieve the contents of a different field.

The Evaluate() function can always be used in place of the GetField(). In this example, for instance, Evaluate (gSelectColumn) and GetField (gSelectColumn) both return the same result. The opposite is not true, however. Evaluate() can perform complex evaluations and can have trigger conditions defined, whereas GetField() can retrieve only the contents of a field.

Examples:

Function

Results

GetField ("myField")

Returns the contents of myField.

GetField (myField)

Returns the contents of FirstName, when myField contains the string "FirstName".

GetField (MiddleValues (fieldList; counter ;1))

Returns the contents of the LastName field, when fieldList is a return-delimited list of field names containing "FirstName¶LastName¶City¶State¶Zip" and counter is 2.



: 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