# Array Column as options in a choice component?
**URL:** https://community.glideapps.com/t/array-column-as-options-in-a-choice-component/11108
**Category:** Feature Requests
**Created:** [June 19, 2020, 1:13am UTC](https://community.glideapps.com/t/array-column-as-options-in-a-choice-component/11108 "2020-06-19T01:13:04Z")
**Posts on this page:** 20
**Page:** 1
### Author:  [@Rasha](https://community.glideapps.com/u/Rasha)
#### Post date: [June 19, 2020, 1:13am UTC](https://community.glideapps.com/t/array-column-as-options-in-a-choice-component/11108/1 "2020-06-19T01:13:04Z")
Spent a couple of days trying to find an elegant solution to this. This post touches on a similar challenge but I couldn’t transfer the workaround to my setup.
> [@Multiple Columns of Data Merged in Glide?](https://community.glideapps.com/t/multiple-columns-of-data-merged-in-glide/7534/15):
>
> I got it working using Google Sheets. Those four gemstones are all presenting data from the same user’s row. So they’re clickable cause it’s a tile inline list. I just had to build it all in a new sheet with every user getting four rows in that new sheet, each pulling the data from a different column of the original user sheet. All so I can present four buttons horizontally. Jeeze. Presenting this same data vertically and I wouldn’t need to do any of this. But I want to present button…
I have a Product sheet (simplified below) where vendors have multiple products/sizes/price points. In a previous version, a form button component was linked to an “Order Form” sheet, separate from Products. Then, Orders were sent to an Orders Received sheet. Current version needs to use **just one sheet** for Products and another for orders received, nothing more. This reduces complexity for Admins uploading/editing products.
Looking to create a shopping cart experience with an “add to cart” Form Button on each product page on a vendor’s profile page. Brain-twister is **how to pull multiple (three) Size/Price columns into one choice component.** Advanced formulas are not my forte but I’ve played around with Transpose and Query (new to).
**Step 1:** Query columns from Product sheet (Product, Vendor, Size&Price\_A Size&Price\_B, Size&Price\_C)
**Step 2:** Transpose. Would render the sheet endless.
Right now, the choice component is pointing to **Size&Price\_A**. It pulls the entire column on any product — I have yet to crack filtering by Vendor.
Finally, not sure if this is relevant, but since I have Users (buyers), Admins (Sellers), and an extensive product catalog. To pre-empt any hiccups/mess, I assigned a Row ID to Vendor, Product, and User sheets.
What I desperately want to avoid is **multiple rows for each product** to account for different size/price combinations.
Tips/tricks/magic?
---
### Author:  [@John\_Cabrera](https://community.glideapps.com/u/John_Cabrera)
#### Post date: [June 19, 2020, 1:18am UTC](https://community.glideapps.com/t/array-column-as-options-in-a-choice-component/11108/2 "2020-06-19T01:18:15Z")
I abandoned my solution (which is the only one I can think of here) since it required a separate sheet, and formulas that essentially duplicated a row of info from another sheet four times. Very inefficient.
---
### Author:  [@Rasha](https://community.glideapps.com/u/Rasha)
#### Post date: [June 19, 2020, 1:19am UTC](https://community.glideapps.com/t/array-column-as-options-in-a-choice-component/11108/3 "2020-06-19T01:19:40Z")
Bummer, I was hoping you’d say you’ve fine-tuned it and it works brilliantly!
---
### Author:  [@John\_Cabrera](https://community.glideapps.com/u/John_Cabrera)
#### Post date: [June 19, 2020, 1:28am UTC](https://community.glideapps.com/t/array-column-as-options-in-a-choice-component/11108/4 "2020-06-19T01:28:53Z")
The only thing I can think of that might be a bit more efficient than what I did would be to create a blank sheet and create an arrayformula in the first column that gives you exactly 3 times the number of IDs as there are in the sheet with your Size/Price columns—pretty simply formula using counta and row().
Then in glide use math columns and if \> then columns to essentially stack the three Size/Price columns from that other sheet into one column in that new sheet. That new sheet will always have the appropriate number of rows to handle that data, since your ID formula is giving you that in Sheets.
It’s not an elegant solution. It still means that you have to chip into your Glide Row Quota just to create a Choice Display. But it does seem that the 25k row limit isn’t actually a limit but rather a point when Glide starts hitting bottlenecks. And in some cases people have been able to get far more than 25k rows because the rows themselves didn’t have much data. A sheet with just one column of ID numbers doesn’t seem particularly hefty.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [June 19, 2020, 1:32am UTC](https://community.glideapps.com/t/array-column-as-options-in-a-choice-component/11108/5 "2020-06-19T01:32:37Z")
I’m not sure this would work but how about creating an array column with columns named “Size&Price 1”, “Size&Price 2”,…
Then use that one as the choice values for the product?
Update: It’s not working here 😢
---
### Author:  [@Rasha](https://community.glideapps.com/u/Rasha)
#### Post date: [June 19, 2020, 1:45am UTC](https://community.glideapps.com/t/array-column-as-options-in-a-choice-component/11108/6 "2020-06-19T01:45:53Z")
I was just about to say… that was the first thing I tried 🙂
---
### Author:  [@Rasha](https://community.glideapps.com/u/Rasha)
#### Post date: [June 19, 2020, 1:51am UTC](https://community.glideapps.com/t/array-column-as-options-in-a-choice-component/11108/7 "2020-06-19T01:51:30Z")
Thanks John. I have to chew on this for a bit. Because of the nature of the app, it won’t take long to reach 50k as it is and I’m expecting having to regularly transfer data to clear rows.
---
### Author:  [@John\_Cabrera](https://community.glideapps.com/u/John_Cabrera)
#### Post date: [June 19, 2020, 3:22am UTC](https://community.glideapps.com/t/array-column-as-options-in-a-choice-component/11108/8 "2020-06-19T03:22:04Z")
Oh don’t get me wrong it is a pretty terrible option, but in lieu of a feature that bundles two rows for display choice, it’s probably the lightest thing avail rn.
---
### Author:  [@John\_Cabrera](https://community.glideapps.com/u/John_Cabrera)
#### Post date: [June 19, 2020, 3:24am UTC](https://community.glideapps.com/t/array-column-as-options-in-a-choice-component/11108/9 "2020-06-19T03:24:29Z")
Array columns for Choice Display would be the simplest solution to this and something I feel like Glide could handle. Add it to the Feature Request app, and you might be pleasantly surprised that it comes sooner than you think.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [June 19, 2020, 3:30am UTC](https://community.glideapps.com/t/array-column-as-options-in-a-choice-component/11108/10 "2020-06-19T03:30:10Z")
I have just added one but if I’m not wrong it is subjected to review from Glide team before available for voting.
---
### Author:  [@John\_Cabrera](https://community.glideapps.com/u/John_Cabrera)
#### Post date: [June 19, 2020, 3:32am UTC](https://community.glideapps.com/t/array-column-as-options-in-a-choice-component/11108/11 "2020-06-19T03:32:13Z")
They’ll add it. It’s a pretty obvious one. They usually take a few days to add new request for voting.
---
### Author:  [@Rasha](https://community.glideapps.com/u/Rasha)
#### Post date: [June 19, 2020, 3:35am UTC](https://community.glideapps.com/t/array-column-as-options-in-a-choice-component/11108/12 "2020-06-19T03:35:13Z")
Thank you for adding that. I thought the feature request app wasn’t live anymore, Is this the right [link](https://features.staging.glideapp.io/)?
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [June 19, 2020, 3:37am UTC](https://community.glideapps.com/t/array-column-as-options-in-a-choice-component/11108/13 "2020-06-19T03:37:42Z")
Yeah it’s there.
Here’s what Mark said a while ago:
> [@Feature request app - is it still alive?](https://community.glideapps.com/t/feature-request-app-is-it-still-alive/10600/2):
>
> Sorry about that. We’re very much behind triaging the suggestions, but we’ll catch up again. We also regularly consult this app for our work prioritization - your inputs there are very valuable to us!
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [June 19, 2020, 3:49am UTC](https://community.glideapps.com/t/array-column-as-options-in-a-choice-component/11108/14 "2020-06-19T03:49:07Z")
I’ve wanted this too, thanks for submitting the request!
---
### Author:  [@Rasha](https://community.glideapps.com/u/Rasha)
#### Post date: [June 19, 2020, 3:49am UTC](https://community.glideapps.com/t/array-column-as-options-in-a-choice-component/11108/15 "2020-06-19T03:49:44Z")
looks like it’s whitelisted emails only.
---
### Author:  [@Rasha](https://community.glideapps.com/u/Rasha)
#### Post date: [June 19, 2020, 3:50am UTC](https://community.glideapps.com/t/array-column-as-options-in-a-choice-component/11108/16 "2020-06-19T03:50:57Z")
I’ll give it a shot. Thanks so much!
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [July 2, 2020, 3:37am UTC](https://community.glideapps.com/t/array-column-as-options-in-a-choice-component/11108/17 "2020-07-02T03:37:01Z")
Hi @Mark …this really needs to be a thing. Array columns as choice components. 3 of my current apps hinge on this feature. Any chance it’s in the pipeline?
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [July 12, 2020, 2:12am UTC](https://community.glideapps.com/t/array-column-as-options-in-a-choice-component/11108/18 "2020-07-12T02:12:37Z")
We have solved it here.
> [@Solved: Dynamic product variants in choice component](https://community.glideapps.com/t/solved-dynamic-product-variants-in-choice-component/12344/):
>
> Thanks to the brilliant @Jeff_Hager, we have now successfully implemented a dynamic product variant choice component. It was started from this discussion. Based on this discussion and what Jeff and me worked on in the Sheets, I created an app that you can copy to work on for your own apps. Basically you need to have: A column that contains all sizes, separated by a comma (or you can change the separator in the formula if you have an existing one that is not a comma) Determine the max n…
---
### Author:  [@Rasha](https://community.glideapps.com/u/Rasha)
#### Post date: [July 12, 2020, 6:12am UTC](https://community.glideapps.com/t/array-column-as-options-in-a-choice-component/11108/19 "2020-07-12T06:12:12Z")
🥂 @ThinhDinh & @Jeff_Hager. Nice work and beautiful timing. Thanks for the ping!
---
### Author:  [@Rasha](https://community.glideapps.com/u/Rasha)
#### Post date: [July 12, 2020, 6:11pm UTC](https://community.glideapps.com/t/array-column-as-options-in-a-choice-component/11108/20 "2020-07-12T18:11:05Z")
Looked at this again today. For my particular use case which doesn’t utilize a standardized and finite range of sizes, it’s close but not quite. It’s users who enter their own product/size/price info. Need a solution that doesn’t rely on a secondary **size array** sheet.
[Next page](https://community.glideapps.com/t/array-column-as-options-in-a-choice-component/11108.md?page=2)