Forum Discussion
QuickBaseCoachD
7 years agoQrew Captain
OK, so you can do a non exact match to set up the Report Link field. You will need to have a separate table for the INBOX and the SENT emails, and of course, this does presume that that the gmail email address that you are syncing to has the emails in it.
So that typically means that your staff are using a generic email address such as CustomerService@gmail.com or else there is a gmail email mailbox which is cc'd on all the emails in and out from selected email addresses.
If you have a standard enough format where you can actually parse out the Work Order number from the subject line by formula, then you can actually have a relationship where 1 case has many INBOX emails and count the number of replies. Then you would know if there was zero replies to a case.
So that typically means that your staff are using a generic email address such as CustomerService@gmail.com or else there is a gmail email mailbox which is cc'd on all the emails in and out from selected email addresses.
If you have a standard enough format where you can actually parse out the Work Order number from the subject line by formula, then you can actually have a relationship where 1 case has many INBOX emails and count the number of replies. Then you would know if there was zero replies to a case.