Creating all possible combinations of each product doesn’t seem practical. I’ve tried using relations but it doesn’t appear to be the way. There’s also a finite amount for each product - another challenge.
In the original version of the form, the product choice was limited, so having two choice components in the form was sufficient (see below). The first component pulled from a (product name - price) column on a “Products” sheet, the second from a (Quantity) column on an “Options” sheet.
Hey there. I’ve checked out the various options on that thread including th Dynamic List Filter in your Concepts app. There are many permutations of the above scenario and the app is used by independent parties (via copy this app) so relying on visibility in component features is not an option especially for larger and more complex product lists. I actually wanted to delete this post but have no permission.