Using #field With Delimiter and Column ParametersPRO

The #field variable takes the following parameters:

#field(field_id, delimiter, column)

  • field_id is 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:

WS Form PRO - Data Grid - Multiple Columns

Column Mapping

When using the column parameter of the #field variable, you must ensure the column mapped to Values contains unique values.

WS Form PRO - Data Grid - Column Mapping - 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).

Demo