Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Nov 27, 2022 10:06 AM
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! Go to Solution.
Nov 27, 2022 11:01 AM
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- ")
)
Nov 27, 2022 11:01 AM
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- ")
)
Nov 27, 2022 12:22 PM
This is awesome.
I don’t know it can be copied like that.
Thank you a lot.