Render Data Save in a custom state and increment

Need help
1

Hello Bubble community,

I have been trying several things and I am not really sure how to achieve my goal.
I have 3 tables

  • colors
  • sizes
  • material

They can be accessed by the user through 3 different Multiselect dropdown.
When the user add a color, it is saved in a custom state list called"Selected colors"

Same for Size in a custom state list “Selected Sizes”
Same for Material in a custom state list “Selected materials”

Only color is required, so I can have 1, 2 or 3 lists. (custom state list).

Now I want to display this in a RG

If I have only color no problem:
Blue
Green
Red

Now if I had one size I want this size to be added to the existing color.
Blue
XS

Green
XS

Red
XS

Now if I add another size, I would need to create as many rows as there is selected colors

Blue
XS

Blue
S

Green
XS

Green
S

Red
XS

Red
S

Now if I add material then it’s the same I would need to add this selected material to the existing rows, and create now rows for each selected colors and sizes that exists.

Blue
XS
Wool

Blue
S
Wool

Blue
XS
Cotton

Blue
S
Cotton

Green
XS
Wool

Green
S
Wool

Green
XS
Cotton

Green
S
Cotton

So on and so on

Currently, I am using a RG inside a RG inside a RG but it’s not good.

I tried many things, merged with, joined with, group by but I really don’t know what direction I should head to… If someone has an idea it would be great.

Thanks a lot

2

Hey I should also mention that the reason I am using custom state list is because I don’t want to save the data in the data base, cause every time the user add or remove a color, a size, or a material, I will have to update the database.

3

Hello and thanks for posting! Would you mind reaching out to Bubble Support with screenshots or a link to your app? Our team is happy to take a look at your app and see what solutions we might be able to come up with!

4

This topic was automatically closed after 70 days. New replies are no longer allowed.