✨Multiselect Dropdown

The Multiselect feature in Impler allows users to pick multiple values for a single cell. This feature is useful in various scenarios like selecting categories for products, tagging items, and more.

i. Enable Multiselect from web portal

1. Click on the + button to add a new column.

2. Provide column Name and Type = Select.

Add Select Column

3. Click on Validations.

Multiselect Validations

4. We can provide allowed values in Select Values.

5. We can also enable Multi Select for select column. Which allows user to select multiple values in the cell.

Specifying Delimiter

6. Additionally we can sepcify , or ; as delimiter for multi-select values.

iii. Enabling Multiselect Dropdown using Runtime Schema

We can enable the Multiselect feature by providing a custom schema with the allowMultiSelect flag in our frontend code.

showWidget({
  schema: [
    {
      key: 'choice',
      name: 'Eating Choice',
      type: 'Select',
      selectValues: ['Fruit', 'Vegetables', 'Nuts'],
      allowMultiSelect: true,
      delimiter: ';'
    }
  ]
});

Sample file generation and format

Impler creates .xlsx and .xlsm files based on the columns' configuration:

• .xlsx File: Generated if no columns have Multiselect enabled.

• .xlsm File: Generated if any column has Multiselect enabled.

Writing in .xlsm Files

When a column is marked as Multiselect, Impler appends #MULTI to the end of the column name in the Excel file. This allows users to select multiple options in the cell.

For detailed steps on how to write in .xlsm files refer to Writing effectively into .xlsm files.

Data Format

Columns with the Multiselect feature will send an array of selected values when sent to application Using Webhook or Using Frontend Callback.

Have any doubts? Shoot us a message directly on Discord.