Category: Get
Syntax: Get ( ActiveFieldContents ) |
Parameters: None
Data type returned: Text, Number, Date, Time, Timestamp, Container
Description:
Returns the contents of the field in which the cursor is currently placed. The contents of the field need not be highlighted.
Get ( ActiveFieldContents ) can return the contents of fields of any data type, but the field in which you place those contents may need to be of the same data type for it to display properly.
Note that in the case where the cursor is not placed in a field, a blank value is returned, as opposed to a question mark.
When using Get() functions within field definitions, in most cases you should set the storage option to be "unstored" so that the field always displays current data.
Examples:
Function |
Results |
---|---|
Get ( ActiveFieldContents ) |
Returns Rowena when the current field contains the name Rowena. |
: 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