β¨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
Click on the
+
button to add a new column.Provide column
Name
andType
=Select
.
Click on
Validations
.
We can provide allowed values in
Select Values
.We can also enable Multi Select for select column. Which allows user to select multiple values in the cell.
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.
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.
Last updated