I have a worksheet with available sizes from a product. The column is named sizes and it is in this format: S,M,L. I have a form setup (different worksheet named form), where I want customers to make a selection from the choice component. So they would be able to choose either S, M or L and submit that choice in the form. So far I have no clue how to get the available sizes data into the choice component of the form. Tried with relations but somehow that does not work here. Any guidance or help is appreciated!

Assuming you have a products sheet, a sizes sheet, and the form sheet, correct? It sounds like you have a multiple relation from the products sheet to the sizes sheet? You should only need a form button on the product details page. Open the form and add a choice component. For the data source of the choice component, set it to the relation you created to link the product sheet to the size sheet.

no, just a product sheet and a form sheet. The sizes are in a column in the product sheet (coming from an xml feed).

How many different unique combinations of sizes would you have? (Ex. ‘S,M,L’; ‘S,L’; ‘M,L’; etc.)

we have about 100 sizes, so that would be an impossible venture to make all combinations from them. Is there no way to display a field value from a differtent worksheet, or does this just only work through relations?

I’ll have to think about this. To be clear, the sizes are listed in a single column for each product with a comma delimiter between each size?

I was talking about this in a thread like 2 weeks ago with the same problem. It would be nice if we can split that to multiple columns in an array column format, then make that array column the choice value, but obviously that does not work as of now.

@ThinhDinh Yeah, that’s kind of what I want to double check on when I get to a computer. I’m wondering if some weird split/transpose/unique or query formula could give us a list in a new sheet that could be linked to with a relation to build the list of sizes for the choice component. @applemooz Can you share a small sample of your data? Screenshot should be fine.

If we have each combination of product ID and size choice in a row then it would work, but it will eat up a lot of rows. If Karl still wants to go that way, then I think after splitting & trimming the choices into multiple columns in the original sheet, we can transform that to a new sheet with multiple lines by something like. ={FILTER({ProductID Column; Size 1 Column}, Size 1 Column <>"");FILTER({ProductID Column; Size 2 Column}, Size 2 Column <>"")} It might work stacking it on each other like this, an Array literal problem can come up, but that’s my best bet now.

[Untitled-10] Is this enough for you?

Sizes from one worksheet in choices component of other worksheet

Ask for Help

ThinhDinh July 12, 2020, 2:11am 20

Here, we have solved it.

Topic		Replies	Views
Solved: Dynamic product variants in choice component Ask for Help	12	3070	July 5, 2022
Array Column as options in a choice component? Feature Requests	27	3778	March 30, 2021
Help to add a product with size variations and when publishing, a size can be chosen Ask for Help	3	51	January 13, 2025
Arraycolumn relation within one table Ask for Help	7	897	July 12, 2020
Help! Populate Choice Component with calculated columns data Ask for Help	8	419	December 30, 2020

Sizes from one worksheet in choices component of other worksheet

Related topics