Relation for column with multiple values

Now that one can select many choices from a choice component, how can one relate to another sheet and look up their corresponding values. e.g in my app, one can select many suppliers of a product, now in app, how can the user contact the different suppliers (pull back their contacts for the supplier’s sheet)

Split the column where you house the choices, then use that in a multiple relation. From that relation, you can build lookups, join text columns, rollups etc.

1 Like