Reference > Functions reference > Get functions > Get(ActiveFieldContents)


Returns the contents of the field that has the focus.


Get ( ActiveFieldContents )



Data type returned 

text, number, date, time, timestamp, container

Originated in 

FileMaker Pro 6.0 or earlier


When the focus is in a repeating field, this function returns the contents of the active repetition. The result type of the active field depends upon the data type of the active field and the result type assigned to the Get(ActiveFieldContents) calculation function.

This type of calculation is most useful if used in a script when you want to examine data in different fields as the script proceeds.

Example 1 

Returns SomeShop when the focus is in the Name field, and that field contains the data SomeShop.

Related topics 

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas