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

Get(ActiveFieldTableName)

Returns the name of the table occurrence that contains the field that has the focus.

Format 

Get ( ActiveFieldTableName )

Parameters 

None

Data type returned 

text

Originated in version 

7.0

Description 

Returns the table occurrence name for the active field. If there is no active field, this function returns an empty string.

Example 1 

There are two fields, Teachers::Name and Coaches::Name, on the current layout based on the Classes table occurrence. The Classes table occurrence is related to the Teachers table occurrence and the CoachesA table occurrence (whose source table is Coaches). Creating a script that returns the result of Get(ActiveFieldTableName) to a third field will return Teachers when the script is performed after clicking in the Teachers::Name field, or will return CoachesA after clicking in the Coaches::Name field.

Related topics 

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas