(Couldn’t find this asked elsewhere) I am adding a voting component to my app. I have a page to create a vote ‘motion’. I have a default vote choices of “In Favour” / “Against” / “Abstain”. but the admin can also create a set of choices, like “Red” / “Green” / “None” with no theoretical limit on # …

Here’s a rough draft of the video I plan on reshooting this week:

You need to use the miracle method to transpose the list. [image] fishbaguette_breadbasket Transpose Columns to an Inline List: The Miracle Method Community Resources I’m often asked how to take columns of data (say form responses) and display them in an inline list. Here…

Thanks, Darren. Hmm, the video’s interesting but I’m not sure how to apply in my case. I don’t have the list of items in rows anywhere. They’re only ever in one text field. I’d rather not make a column somewhere to track the list of options for every poll / motion we want to vote on, right? The go…

The miracle method allows you to transpose a CSV to rows using a helper table. I think I’ll recreate this video to showcase the method in a more straightforward manner.

[image] jkirkwood001: I don’t have the list of items in rows anywhere. The idea is to dynamically generate the list by first creating an array from the list, then using a Helper Table with a row index, and finally a Single Value column to select each item from the array on a separate row. Bob…

I had this problem for one of my apps - and the simplest way to fix: you have the options that people are saving in a column, let;'s call it usc-mychoice you have some lookup table to display your choices - some of which might have commas you then have a choice component where the user can…

Thanks Mark. That could work, except my Choice list is going to vary and the number of polls / votes will grow over time. So I don’t think a fixed column per poll is scalable. I’m groing to try and use Rob’s updated video - thanks @Robert_Petitto ! And thanks @Darren_Murphy for always helping too. …

I have the same problem as you… likely unlimited potential number of pills, etc. So I use the user table a lot to set values, such as an id to find the row (eg ‘survey id’). Then in the user table I do lookups to find question id things for the questions that might be included. …. Then I have my h…

It works! Thanks folks :slightly_smiling_face: [image]

Use comma-separated values as source for Choice?

Ask for Help

Darren_Murphy February 11, 2024, 7:02pm 2

You need to use the miracle method to transpose the list.

Topic		Replies	Views
Choice Component using split list or array Ask for Help	9	2431	March 12, 2022
How to turn a csv list into choice component options? Ask for Help	5	494	April 15, 2023
Parsing text into multiple choice values for a Choice form component Ask for Help choice , multiple-rows	9	310	March 6, 2024
How to use a row as a source for choice component? Ask for Help	3	750	December 19, 2021
Array values as a choice for user Ask for Help	8	118	October 28, 2024

Use comma-separated values as source for Choice?

Related topics