The #field variable takes the following parameters:
#field(field_id, delimiter, column)
field_idis the ID of the field.delimiter(Optional) is the character or string you want to separate multiple values by.column(Optional) is the column in your data grid you wish to retrieve the value from.
The column parameter is compatible with select, checkbox and radio fields.
Example: #field(123, ",", "Width")
Demo
This demo uses a checkbox field that has the following data grid:
Column Mapping
When using the column parameter of the #field variable, you must ensure the column mapped to ‘Values’ contains unique values.
Examples
| Example | Description |
|---|---|
#text(field(123)) |
Dynamically returns the value of field ID 123 and update it if field ID 123 changes. |
#text(#field(123, "/")) |
Dynamically returns the value of field ID 123, separating multiple values with the / character and update it if field ID 123 changes. |
#text(#field(123, "/", "Width")) |
Returns the value found in the ‘Width’ column of field ID 123, separating multiple values with the / character. |
#text(#field(123, "/", 2)) |
Dynamically returns the value found in column index 2 (third column) of field ID 123, separating multiple values with the / character and update it if field ID 123 changes. |
Using #calc with Multiple Columns
You can use the #calc variable with #field variables containing the column parameter.
For example: #calc(#field(123, ",", "Width") * #field(123, ",", "Length"))
Note how the delimiter parameter is simply set to its default value "," and is essentially ignored in this example because the radio field only returns one value (row).