Building user dropdowns based on columns in the DB

Need help Database
1

I’m using Bubble to build a website that will be a storefront to buy clothing packages.

A package consists of 2 items, a top and a bottom. There are different options/variants you can select when choosing either tops or bottoms.

If you look at my data table below you can see that tops are either:
tops: STYLE (sleeves) || SIZE || color
STYLE (classic) || SIZE || n/a

I’m struggling to build a UI that will allow customers to pick the SIZE and COLOR dynamically based on whats available (or not show the option if it’s not applicable.

I think I can’t build the UI because I have the wrong data model but honestly I’m not sure.

So far my data looks like this:

item itemstyle itemsize itemcolor quantity
top sleeves small orange 5
top sleeves large orange 7
top sleeves small orange 8
top sleeves large orange 2
top sleeves small lilac 5
top sleeves large lilac 7
top sleeves small lilac 8
top sleeves large lilac 2
top classic small N/A 3
top classic medium N/A 3
top classic large N/A 3
pants short small neon yellow 4
pants short small neon pink 6
pants long small neon pink 8
pants long medium neon pink 9
pants long large neon pink 0
2

Hey @twinkle. If these are the exact fields of your data type, you can build a dropdown for the available item styles like this for example:
image

You can build for any other field like this too. Simply, get them and get the unique elements. See that the type of choices will be the same as itemstyle (in this case, it is text. Whatever yours is).

Then, it is up to you what will happen when someone choose a value from this dropdown.