# Choice Component using split list or array **URL:** \ **Category:** Ask for Help\ **Created:** [March 12, 2022, 6:12pm UTC](https://community.glideapps.com/t/choice-component-using-split-list-or-array/39563 "2022-03-12T18:12:12Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Lin\_Altshuler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lin_altshuler/32/32591_2.png) [@Lin\_Altshuler](https://community.glideapps.com/u/Lin_Altshuler)\ **Post date:** [March 12, 2022, 6:12pm UTC](https://community.glideapps.com/t/choice-component-using-split-list-or-array/39563/1 "2022-03-12T18:12:12Z")
Hi, Is there a way to use values from a split list\array as the source of a choice component? I currently don’t have the option to choose it. To be more specific this is _not_ a multiple relation. This is generated from split text. all the data is stored in one row, not in a column. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [March 12, 2022, 6:14pm UTC](https://community.glideapps.com/t/choice-component-using-split-list-or-array/39563/2 "2022-03-12T18:14:40Z")
Choices need to come from multiple rows. You can’t build them based on a single row. ---
**Author:** ![Lin\_Altshuler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lin_altshuler/32/32591_2.png) [@Lin\_Altshuler](https://community.glideapps.com/u/Lin_Altshuler)\ **Post date:** [March 12, 2022, 6:18pm UTC](https://community.glideapps.com/t/choice-component-using-split-list-or-array/39563/3 "2022-03-12T18:18:11Z")
I see, Any ideas how It can be done ? I need to be able to choose values from split text ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [March 12, 2022, 6:21pm UTC](https://community.glideapps.com/t/choice-component-using-split-list-or-array/39563/4 "2022-03-12T18:21:31Z")
Are the values consistent? Meaning, are there a set list of possible choices, or can they be completely random? What I’m getting at, is that you could have a separate table that contains all of the possible choices for everything (one per row). Then you could use your split array to create a relation to the choice table, and point your choice component to that relation. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [March 12, 2022, 6:23pm UTC](https://community.glideapps.com/t/choice-component-using-split-list-or-array/39563/5 "2022-03-12T18:23:41Z")
Something like this may help: > [@fishbaguette\_breadbasket Transpose Columns to an Inline List: The Miracle Method](https://community.glideapps.com/t/transpose-columns-to-an-inline-list-the-miracle-method/32766): > > 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] ](https://www.youtube.com/watch?v=t-sh_Q3WbQc) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [March 12, 2022, 6:24pm UTC](https://community.glideapps.com/t/choice-component-using-split-list-or-array/39563/6 "2022-03-12T18:24:42Z")
That would have been my next suggestion if the possible choices are random. 😉 ---
**Author:** ![Lin\_Altshuler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lin_altshuler/32/32591_2.png) [@Lin\_Altshuler](https://community.glideapps.com/u/Lin_Altshuler)\ **Post date:** [March 12, 2022, 6:26pm UTC](https://community.glideapps.com/t/choice-component-using-split-list-or-array/39563/7 "2022-03-12T18:26:09Z")
No, they are random ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [March 12, 2022, 6:28pm UTC](https://community.glideapps.com/t/choice-component-using-split-list-or-array/39563/8 "2022-03-12T18:28:55Z")
Yeah, then @Robert_Petitto’s method could be your best option. I think a separate table with the max number of rows (choices) you would possibly have, then pass in you delimited list through an action and have the table transpose everything to separate rows. Using a user specific column to receive the delimited list of course. ---
**Author:** ![Lin\_Altshuler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lin_altshuler/32/32591_2.png) [@Lin\_Altshuler](https://community.glideapps.com/u/Lin_Altshuler)\ **Post date:** [March 12, 2022, 6:42pm UTC](https://community.glideapps.com/t/choice-component-using-split-list-or-array/39563/9 "2022-03-12T18:42:46Z")
Prefect, it really worked like magic. I love it! Thanks ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/1/317f5fa393f5faaef4e37fd86377cfaf42021b2d.png) ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [March 13, 2022, 6:42pm UTC](https://community.glideapps.com/t/choice-component-using-split-list-or-array/39563/10 "2022-03-13T18:42:52Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.