Quick Base now has a native Sync connection to gmail which can be set up with a few clicks. I suggest reading about Sync
https://help.quickbase.com/user-assistance/connecting_to_Gmail.htmlYou will end creating one table on your app for each folder in your gmail..For example
Inbox
Sent
would be two common examples of folders.
OK, so lets say that you get that far and now need to figure out how to get an embedded table of the relevant gmails onto a case record.
To do that you will need to have some field in your case record which can be matched against a field on the gmail table. For example, if the case record has a field for contact Email, the you could make a Report Link field type.
On the left side you would configure the contact email address and then on the right side you would configure by navigating to your app and then to the Sync table field on say the Inbox table containing the FROM email address.
So the issue is less so a technical one once you have doe one, the issue is how to configure that Report Link field. Another example would be this. The Report link fields can be set up so as not to need to match "exactly". What that really means is that if you have a field on your case record in the format
case 1234
Then if you train your staff to always have the case number entered in that exact format in the body of the email or perhaps the subject, then you can match up against that field with a not exact match and get hits. on your case record you would create a formula text field which calculates to like "case 1234." where 1234 if the Record ID# (the case#)