Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Associating multiple select field with subsequent specific multiple select fields

Topic Labels: Data Formulas
681 1
cancel
Showing results for 
Search instead for 
Did you mean: 
jennyafrank
4 - Data Explorer
4 - Data Explorer

If I make multiple selections from a dropdown list is there a way to associate each of those selections with a specific selection from a different multiple selection field? Using the existing Product Catalog template as an example it is easy to understand what my issue is..... If I choose two+ items from the multiple select "Materials" field (ex. "Light Wood" & "Metal"), then choose one or more colors from the multiple select "Color" field (ex. "white" "brown" "black") I have no way of knowing which color is associated with which material. Is there a way to differentiate between having a "Light Wood" in "white" "brown" and "Metal" in "brown" "black" "white"?

1 Reply 1
Alexey_Gusev
13 - Mars
13 - Mars

It depends on what's your desired output. Since you can change order of selected items, you can rely on their order. For example, my script. It has just one multiselect field, and associate it according to the order of items in bulleted list. It helps to prevent repeating field type multiple times.

Alexey_Gusev_0-1692509134997.png