Array values as a choice for user

[Darren_Murphy]

The source of a choice component must be a single column, with one option per row.
To transform what you have there you can use a technique commonly referred to as the “Miracle Method”. Essentially:

• Create a Helper Table with enough rows in it to cover the maximum number of expected options in the array
• Index the rows, starting at zero
• Add your array to every row of the table (could be multiple ways to do this)
• Use a Single Value column to take N from start of the array, where N is the Row Index. This will give you one array element per row.
• Use a series of Query JSON or JavaScript columns to extract the data elements from the JSON string.
• Stitch them back together using a template.
• Use the template as the source of your Choice component.

Transpose Columns to an Inline List: The Miracle Method

I’m often asked how to take columns of data (say form responses) and display them in an inline list. Here’s one way to do it—the MIRACLE METHOD. [Glide: Transpose Data Columns into an Inline List with the MIRACLE METHOD]

How do I create an auto-incrementing row number with Glide Tables?

This is a question that comes up a lot, so creating this topic to use as a reference. Typically, there are two distinct use cases when it comes to auto-incrementing row numbers. Use Case 1: – We need to generate a Part Number, or an Order Number, or an Employee ID. Once the number is generated, it should never change, even if rows are deleted. – The general approach for this use case is to maintain a static counter, use it to craft a suitably formatted ID, and increment it by one every time…