LogoLogo
WebsiteCommunity
  • Overview
    • Introduction
    • How to use it? In 5 steps
  • Importer
    • React Embed
    • Angular Embed
    • Bubble.io Embed
    • HTML & JS Embed
    • Text Customization
    • Directly Enter your Data
    • Select Header Row
  • Data Retrieval
    • Using Webhook
    • Using Frontend Callback
  • Validations
    • Base Validations
    • Advanced Validations
  • Features
    • Data Seeding
    • Import Excel with Image
    • Automated Import
    • Runtime Schema
    • Custom Validation
    • Default Value
    • Column Description
    • Freeze Columns
    • Multiselect Dropdown
    • Output Customization
  • Platform
    • Email Alerts
    • Activity Page
    • Manage Project
    • Make Your Team
    • How subscription works?
  • Additional Resources
    • FAQs
    • Architecture
    • Data Migrations
    • Selfhost Impler
    • Run Impler locally
    • Writing effectively into .xlsm files
  • Changelog
Powered by GitBook
On this page
  • i. Enable Multiselect from web portal
  • iii. Enabling Multiselect Dropdown using Runtime Schema
  • Sample file generation and format
  • Writing in .xlsm Files
  • Data Format

Was this helpful?

Edit on GitHub
Export as PDF
  1. Features

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.

PreviousFreeze ColumnsNextOutput Customization

Last updated 6 months ago

Was this helpful?

i. Enable Multiselect from web portal

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

  2. Provide column Name and Type = Select.

  1. Click on Validations.

  1. We can provide allowed values in Select Values.

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

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

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.

iii. Enabling Multiselect Dropdown using

Runtime Schema
Add Select Column
Multiselect Validations
Specifying Delimiter

If you have any questions, suggestions, or comments. Feel free to reach out to us over . We’re constantly improving to deliver the best Data Importer for your product, and we value your input.

Discord