Dynamically Pull Data From Two Rows?

Question

Hi all, I'd appreciate a bit of help.I am trying to make a two product comparison page. I have all product specifications in one table like this: And I want to pull the specs data on this other "compare pages" table depending on which two products are picked:So if Product 1 is "iPhone 11" then it would pull the specs into this "Product 1 Specs HTML"from the first table. Same for product 2. Hopefully it makes sense.Is there an automation or formula that I can use to achieve this? Much appreciated!

n0xp · Accepted Answer

You're close enough.In your comparison table, change the field type for Product 1 and 2 to the 'Link to record' type and select 'your table Product specs.Then in your Product 1 specs and Products 2 specs fields change the type to Lookup fields. And make them look up your Product and then the Product specs.(this might look confusing on text, but go through it step by step in Airtable, and it'll make sense)&#10084;&#65039;

Vutropush · Answer

You're close enough.In your comparison table, change the field type for Product 1 and 2 to the 'Link to record' type and select 'your table Product specs.Then in your Product 1 specs and Products 2 specs fields change the type to Lookup fields. And make them look up your Product and then the Product specs.(this might look confusing on text, but go through it step by step in Airtable, and it'll make sense)&#10084;&#65039;This worked! Appreciate the help &#128578; Here's a screenshot:

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded