[Workaround] JavaScript for Multi-Choices in Glide

Introduction

The Choice component in Glide allows users to select a single value based on predefined options. However, if you need different values to be derived from multiple selected choices, you can achieve this functionality using a JavaScript column.

This guide explains how to implement this workaround step-by-step, enabling dynamic value mapping for multi-choice selections.

Steps to Implement

1. Prepare Your Data

Add a Text Column
- In a separate table, create a text column to store the choice values.
- Populate this column with the desired choice options (e.g., "Choice 1", "Choice 2").
Add a Text Column for Results
- Create another text column in the same table to capture the user's selected values.

2. Configure the Choice Component

In your app layout, add a Choice Component.
Link this component to the text column for user selections.
Use the first column (choice values) as the source for the choice options.
Enable Allow Select Multiple in the component settings.

Result:
The selected choices will be stored in the result column, separated by commas (e.g., Choice 1, Choice 2, Choice 4).

3. Add a JavaScript Column

Create a JavaScript column in your table and paste the following code:

// Define the mapping of choices to values
const choiceValues = {
  "Choice 1": 1,
  "Choice 2": 2,
  "Choice 3": 3,
  "Choice 4": 4,
  "Choice 5": 5
};

// Initialize an empty array to store matched values
let matchedValues = [];

// Split the selections in p1 and p2 into arrays (remove extra spaces)
let p1Choices = p1.split(',').map(choice => choice.trim());
let p2Choices = p2.split(',').map(choice => choice.trim());

// Iterate over the user-selected choices in p2
p2Choices.forEach(choice => {
  // Check if the current choice in p2 exists in p1
  if (p1Choices.includes(choice)) {
    // Push the corresponding value from the mapping if it exists
    if (choiceValues[choice]) {
      matchedValues.push(choiceValues[choice]);
    }
  }
});

// Return the matched values, joined as a string
return matchedValues.join(', ');