Insert Column

Insert new multi-select and formula columns to the table using the Insert Column option.

1. Click Manage Columns.

2. Select Insert Column.

Insert Column

1. Formula column

1. Choose Formula to insert a formula column.

Select Formula

1. Click the pencil icon to rename the column.

Rename column

1. To configure the formula, click on Click to configure in the 'Default Value' column.

Click to configure

1. Enter the required formula and click Apply. To know more about formulas and functions, you can refer to this section.

Enter formula

1. Click Save to save the configuration and insert the formula column.

Save the configuration

1. The formula column is inserted as shown below.

Inserted formula column

2. Multi-select column

Multi-select columns let users select and input multiple values in a field.

1. To insert a multi-select column, click Multi-select.

Choose Multi-select

1. A new multi-select column is added as shown below.

New column

1. Use the pencil icon to rename the column.

Renaming the column

1. Now, click the highlighted link to configure the column.

Click to configure

1. You'll see the pop-up below where you can configure the details of the lookup table to lookup options for multi-select and the relation table to insert lookup values.

Lookup table configuration