How to Filter a Report Link or find MAX value? Gmail/Quickbase Integration Issue.

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

I am importing emails into Quickbase from Gmail using Zapier. I have:

CONTACTS table 

EMAILS table

However, because we can't make email the key field on our contacts table (we often don't get customer emails addresses until later), I can't figure out how to link the newly imported emails to their related contacts. 

So far, I've just made a report link in the CONTACTS table that matches up the "Email" field in our CONTACTS  to the "Email" field on the EMAILS table.

That's fine for the form. All I want to know the date of the most recent email for a contact on a table, or the MAX value.

Can anyone think of a workaround for this? 

Even if it's just a field on my CONTACTS table that updates every time an email is created on the EMAILS table that matches an email address on the CONTACTS table. 

Photo of Adam

Adam

  • 0 Points

Posted 4 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,760 Points 50k badge 2x thumb
My suggestion is to make the  email field the Key field of the Contacts table.  Where you have a missing email, then i would populate that with a temporary fake email composed of components of the record which should be unique, such as the customers name acmeflooring - waiting for valid email (and include the date and the time to ensure its unique).  There could be a form rule which populates the email field if it is left blank.

Then when you do get the email, the Parent will instantly join with the children.
Photo of Adam

Adam

  • 0 Points
I thought about that, but hadn't considered auto-populating it (I can just see our sales people using duplicates by accident and getting frustrated). If I could have it auto-populate the email field with a unique placeholder email somehow, it'd be a good compromise. Thanks for the suggestion!