Retrieving option attribute values from list columns

You can retrieve data from option attributes in Formula columns. Here are various examples of such formulas:

Retrieve a specific option attribute value

With this formula, you can get the value of an option attribute from a Single Select List or a Multi Select List column.

return $(id_1).name

Request parameters:

id_1 — The identifier of the Single Select List or Multi Select List column.

name — Key of the option attribute.

Check out how to use this formula here:

Updating grid data after selecting a list item

Retrieve all option attributes from a Single Select List column

For example, we have a Single Select List column with the following option attributes:

Enter the following formula to retrieve all option attributes from a Single Select column:

return $(id_1)

id_1 — The identifier of the Single Select List column.

This formula will retrieve the following values for the Single Select List column above:

{"email":"example@email.com","label":"admin","id":"1"}

If there is a single option attribute value, the formula will retrieve the value of that attribute. For example, for the label attribute, it will retrieve the admin value.

Retrieve all option attributes from a Multi Select List column

For example, we have a Multi Select List column with two list items: Admin and User.

Enter the following formula to retrieve all option attributes from a Multi Select column:

return $(id_1)

id_1 is the identifier of the Multi Select List column.

This formula will retrieve different values based on the number of list items you select.

If you select only Admin you will get the following results:

[{"label":"admin","email":"example@email.com","id":"1"}

If you select both Admin and User you will get the following results:

[{"label":"admin","email":"example@email.com","id":"1"},{"label":"user","email":"user@example.com","id":"2"}]

Retrieve option attributes from a Multi Select List column with an index value

Options in Multi Select List columns are stored as array values. Each option has a unique index value assigned to it, starting from 0.

For example, we have a Multi Select List column with two static options: Admin and User. The Admin static option has a 0 index value, and the User static option has a 1 index value.

Use the following formula to retrieve all option attributes from the Admin static option:

return $(id_1)[0]

In this example, you will see the following result in the Formula column:

{"label":"admin","email":"admin@example.com","id":"1"}

If you remove all option attributes from this column, you will see the label value displayed. In this example, it will be displayed as:

admin

Use this formula to retrieve the email option attribute with an index value, and it's Key.

return $(id_1)[0].email

In this example, you will see the following result in the Formula column:

admin@example.com