How do I say IF this email address has product A, check to see if it also has product B

[Shelly_Criswell]

I have a product that expires in one year. If they purchase an upgrade, it extends the expiration another year. The records are added individually to Airtable. How do I say IF this email address has product A, check to see if it also has product B in another record?

[Arthur_Tutt]

Ah @Kenneth_Raghuna good point! I'd forgotten about dot operating into the object. Well spotted 🙂

And yeah, there's still a lot of uncertainty around the logic or which purchases count and which don't, so lot's of room to further optimize. 

[Shelly_Criswell]

Arthur,

I am BLOWN away at how much effort and thought you put into this! 🤯 I cannot thank you enough! Thank you for the loom, screenshots, and script! So amazing!!! Thank you thank you thank you!

[Shelly_Criswell]

Hey Kenneth,

Wow, thank you as well! I'm going to work on this next! I really appreciate your reply!