I am importing emails into Quickbase from Gmail using Zapier. I have:
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.