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.
Solved
Lookup multiple value from other table
Best answer by kuovonne
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- ")
)
+27Use 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- ")
)
kuovonne wrote:
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.
1 person likes this
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.