Forum Discussion
QuickBaseCoachD
8 years agoQrew Captain
OK, well here is a low tech solution but maybe its good enough for you to start with. make a new table called Unique email addresses or whatever they really represent in your app. Make a field called email of type email address.
Then on your gmail sync table, make a summary report based on the count of the email addresses. That will give you a list of the unique email addresses.
Then while viewing the report, use the More ... button to export to another table and follow the steps to import the unique email addresses to the Unique email address table.
Then make a relationship where 1 Unique email address has Many Table Bs.
Make a formula checkbox field in the unique email addresses table and the formula will be
true
It will always calculate to "checked".
Look that up down to your Table B and any record with a checkbox exists in the email address table.
So that will work, but then from time to time or every morning someone will need to manually do that same More button routine to copy the unique email addresses form gmail to the unique email address table. The copy function will not change the existing email addresses, but it will add the new ones.
I do not know of a native way to automate that daily process. It would have to be done with a script and that will take paying a developer to do that.
Then on your gmail sync table, make a summary report based on the count of the email addresses. That will give you a list of the unique email addresses.
Then while viewing the report, use the More ... button to export to another table and follow the steps to import the unique email addresses to the Unique email address table.
Then make a relationship where 1 Unique email address has Many Table Bs.
Make a formula checkbox field in the unique email addresses table and the formula will be
true
It will always calculate to "checked".
Look that up down to your Table B and any record with a checkbox exists in the email address table.
So that will work, but then from time to time or every morning someone will need to manually do that same More button routine to copy the unique email addresses form gmail to the unique email address table. The copy function will not change the existing email addresses, but it will add the new ones.
I do not know of a native way to automate that daily process. It would have to be done with a script and that will take paying a developer to do that.