# Array Column As A Choice Input

**URL:** <https://community.glideapps.com/t/array-column-as-a-choice-input/25151>\
**Category:** Ask for Help\
**Created:** [April 5, 2021, 4:34am UTC](https://community.glideapps.com/t/array-column-as-a-choice-input/25151 "2021-04-05T04:34:56Z")\
**Posts on this page:** 3\
**Page:** 2

<div class="post-metadata">

**Author:** ![Test\_Test](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/test_test/32/30930_2.png) [@Test\_Test](https://community.glideapps.com/u/Test_Test)\
**Post date:** [June 15, 2022, 5:12am UTC](https://community.glideapps.com/t/array-column-as-a-choice-input/25151/21 "2022-06-15T05:12:22Z")

</div>

> [@Robert\_Petitto](#):
>
> Choice components can’t be populated from array columns. They can only be populated from relations or individual rows.

Hola Robert,  
Have you found a workaround for this?  
When using a working table to support a custom form we normally have just one row. I’d like to be able to use some array/lookup or other columns to make this happen. I’m also not able to feed the choice column from relation columns in that single row working table.  
Any ideas?  
Thanks

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [June 15, 2022, 5:37am UTC](https://community.glideapps.com/t/array-column-as-a-choice-input/25151/22 "2022-06-15T05:37:32Z")

</div>

Probably a bit late for Bob, so I’ll jump in here.

The restriction still applies. The source of a choice component can only be a single column with multiple rows, or a multiple relation.

If you have an array of values, then what you would need to do is create additional rows in your working table - enough to cater for the maximum number of choices - and then expand the array into multiple rows using the Row Index → Single Value method. Or alternatively, you could do the same in a separate table.

If the relation column in your working table is a multiple relation, then you should be able to use that.

---

<div class="post-metadata">

**Author:** ![ShantanuIyengar](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/shantanuiyengar/32/35546_2.png) [@ShantanuIyengar](https://community.glideapps.com/u/ShantanuIyengar)\
**Post date:** [June 15, 2022, 11:49am UTC](https://community.glideapps.com/t/array-column-as-a-choice-input/25151/23 "2022-06-15T11:49:54Z")

</div>

An unethical approach but works!  
You can convert each entry in the comma seperated column to go into set no of rows in a temp column in another table!  
But, then max no applies!  
As the rows that you create in the temp table would be finite, your options also needs to be finite!  
If you have 10 options, create 10 rows.  
Get the array in a single value column!  
Create a column with numbering 1,2,3,4,5,6,7,8,9,10!  
Write JS or use array column to get that element from the array!  
And voila you would have options in rows which can be used for dropdown!

It may take time to get the data!  
Also, it might be difficult in a form to put it if you havent fetched single value in the screen before the form!  
Cannot happen real time in a form!

[Previous page](https://community.glideapps.com/t/array-column-as-a-choice-input/25151.md?page=1)
