Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Dynamically Pull Data From Two Rows?

Solved
Jump to Solution
113 3
cancel
Showing results for 
Search instead for 
Did you mean: 

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: 

Vutropush_0-1674213078587.png

And I want to pull the specs data on this other "compare pages" table depending on which two products are picked:

Vutropush_1-1674213117295.png

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! 

1 Solution

Accepted Solutions
n0xp
5 - Automation Enthusiast
5 - Automation Enthusiast

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)

❤️

See Solution in Thread

3 Replies 3
n0xp
5 - Automation Enthusiast
5 - Automation Enthusiast

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)

❤️

This worked! Appreciate the help 🙂 Here's a screenshot: 

Vutropush_0-1674224905930.png

 

You're welcome !

In general when using Airtable I find it helpful to think, that you should NEVER need to write the same thing twice. It should always be pulled from another place where you already wrote it once.

Have fun !