Re: Search for an Email in a table from a separate table
Hi,
I have two tables in a Database.
One table: called "People". It has list of peoples and their Emails.
Second table: called "Mailing" Has email from table one.
I would like to set an new field in "People" (table 1) that marks "1" if an email is present in both tables. I called this field "Did_I_found_Email" (1 = yes, 0 = No).
How do I do this?
Hello,
You could proceed as follows.
-1- add a formula field in table Mailing wich equals primar key "EMAILWANT"
-2- Add a checkbox type field called "check email" in table people:
-3- Create a new automation:
Trigger is when field "Check email" is checked:
First action is to look in table "Mailing" for records with the same email:
EMail coming from the record that triggered the automation:
We then have a condition to check if we found some records:
And If so, we update table People with value 1:
We then have a condition for when no records were found:
And we update table people with value 0:
2 observations:
- This automation checks if an email present in table People is also present in table Maiing, not the other wayround.
- This automation is triggered manualy and does the check for one row only.
Depending on how your flow works, you can review the automation to work the other way round and to be triggered automatically, for example with a trigger 'when a record is created" in table Mailing.
Regards,
Pascal
