Skip to main content

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.

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- ")
)

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.


Reply