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.

Lookup multiple value from other table

Topic Labels: Formulas
Solved
Jump to Solution
1589 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.