Lookup multiple value from other table

[Ian_Tran]

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.

I need to somehow lookup the name of multiple ids in a field and display them like the picture above.

[kuovonne · Accepted solution]

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]

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