Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Lookup multiple value from other table

Topic Labels: Formulas
Solved
Jump to Solution
257 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello guys, is there a way to archive this scenario with Airtable.
Let’s say I have a field with multiple ids/skus (kind of an array) and a table with ids/sku and name column.
image
I need to somehow lookup the name of multiple ids in a field and display them like the picture above.

1 Solution

Accepted Solutions

Use a linked record field to link the two tables together.

If the SKUs are in the primary field of the other table, you can then copy the {SKUs} field to the linked field to form the link. You can do the copying manually or with an automation. Then create a rollup field of the product names base on the linked record field. You won’t be able to get a real bulleted list, but you can approximate it with this rollup formula:

IF(
  values,
  "- " & ARRAYJOIN(values, "\n- ")
)

See Solution in Thread

2 Replies 2

Use a linked record field to link the two tables together.

If the SKUs are in the primary field of the other table, you can then copy the {SKUs} field to the linked field to form the link. You can do the copying manually or with an automation. Then create a rollup field of the product names base on the linked record field. You won’t be able to get a real bulleted list, but you can approximate it with this rollup formula:

IF(
  values,
  "- " & ARRAYJOIN(values, "\n- ")
)

This is awesome.
I don’t know it can be copied like that.
Thank you a lot.