Share
Explore

Dynamic List of Combinations


I’m trying to create a list of SKU’s by combine attributes from three other list together.

Attribute 1 - Color
0
Attribute Name
SKU code
Finish
1
Blue
Blu
Matte
Glossy
2
Red
Red
Matte
Glossy
3
Green
Gre
Semi-Gloss
There are no rows in this table
Attribute 2 - Finish
0
Attribute Name
SKU Code 2
1
Matte
1
2
Glossy
2
3
Semi-Gloss
3
There are no rows in this table
Attribute 3 - Item
0
SKU Code 3
Color
1
Table
Blue
2
Chair
Red
Green
Blue
3
Desk
Blue
Green
There are no rows in this table

How do I make this table automatically populate and stay up to date so if a color become available in a new finish or we stop making chairs in a certain color the list of SKUs can stay upto date?
List of Possible SKUs
0
Final SKU
Item
Color
Finish
1
Blu1Table
Table
Blue
Matte
2
Blu2Table
Table
Blue
Glossy
3
Blu1Desk
Desk
Blue
Matte
4
Blu2Desk
Desk
Blue
Glossy
5
Gre3Desk
Desk
Green
Semi-Gloss
There are no rows in this table

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.