Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Lookup multiple value from other table

Topic Labels: Formulas
Solved
Jump to Solution
1336 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Ian_Tran
5 - Automation Enthusiast
5 - Automation Enthusiast

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
kuovonne
18 - Pluto
18 - Pluto

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
kuovonne
18 - Pluto
18 - Pluto

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- ")
)
Ian_Tran
5 - Automation Enthusiast
5 - Automation Enthusiast

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