I need to create aa order form from my data sets that allows the users to be able to select different custom options for every product I sell. For example; Color, Size, Manufacturer and Brand. In this example I am selling a Widget that is manufactured by 3 different companies and each company has its own brand name and each widget has 10 different size options and 6 different color options and each has it’s own unique price will change depending on the selected options. I would like be able to Display a Single product image for the user and for there to be drop down menus so that user can select manufacturer, brand, size, color and quantity.
Hi James,
You could use what I call a choices table. In that table you just have different columns for the different options you have and then use Choice components in your form that link to the correct column in that choices table.
Once you have that setup you use custom filtering based on the previous choice made on the form.
Hope that helps
Choice tables work well as long as you’re not allowing users to update them via the app. In that case, you’ll want them in their own tables.
1 Like
| Manufacturer | Brand | Size | Color | Price |
|---|---|---|---|---|
| Company A | Brand X | Small | Red | $10.00 |
| Company A | Brand X | Medium | Blue | $12.00 |
| Company A | Brand X | Large | Green | $14.00 |
| Company B | Brand Y | Extra Large | Yellow | $16.00 |
| Company B | Brand Y | 2XL | Black | $18.00 |
| Company B | Brand Y | 3XL | White | $20.00 |
| Company C | Brand Z | 4XL | Red | $22.00 |
| Company C | Brand Z | 5XL | Blue | $24.00 |
| Company C | Brand Z | 6XL | Green | $26.00 |
| Company C | Brand Z | 7XL | Yellow | $28.00 |
You can have an Options table like this.
Then, on the front end, as Mike described, add choice components for Color, Size, Manufacturer and Brand. Be careful when setting up filters using screen values, and then on the destination table, use queries and single value columns to retrieve the price.
1 Like