Hello, Im creating an app in releation to new cars. We have a list of car options from big query in this format: [image] The end goal is to have the user be able to check some of the options in the array and have the prices add up into a seperate column so they can be factored into a master cal…

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 th…

HI Darren, I have managed to do the miricle and get the options come back seperately. [image] (i can sort the formatting later on) how do i save the users choice? I need them to be able to click more than one and save the values (in the future the sum of the price selected) into the users table

[image] Lewis_Parker: how do i save the users choice? That’s just a matter of configuring a target column for your choice component, which can be a column in the User Profile row. You can enable multiple select on the choice component. If your end goal is to calculate the sum of the selection…

I made a column for the selected choice in the user module (text column). Despite having allow selecting multiple when i click one of the checkboxes it does save the selection in the right column BUT it wil only save one. So if i click a 2nd option it replaces the first. And the checkboxes don’t act…

Are you sure you’re using an actual choice component? Can you show me a screenshot of how that’s configured?

[image] [image] Yeah its a choice component. Any thoughts?

Okay, the problem is that your options contain commas. This breaks the multi-select because multiple selected options are written as a comma separated list. Go back to my initial instructions - you should extract the individual items, then join them back together using a template (without any comma…

Array values as a choice for user

Ask for Help

Darren_Murphy Split this topic October 28, 2024, 11:59am 3

3 posts were split to a new topic: Dynamic row count in Helper Table for Miracle method

Topic		Replies	Views
Array Column as options in a choice component? Feature Requests	27	3592	March 30, 2021
Parsing text into multiple choice values for a Choice form component Ask for Help choice , multiple-rows	9	308	March 6, 2024
Use comma-separated values as source for Choice? Ask for Help choice	10	689	February 15, 2024
Google sheets collumns 1 till 10 becomes in glide an array Ask for Help	18	406	January 9, 2022
Array Column As A Choice Input Ask for Help	22	1655	June 15, 2022

Array values as a choice for user

Related topics