Oct 26, 2021 01:17 PM
Hi, any way to automate this?
Table 1 has 1000 “users” with lots of data for each user, including email address.
Table 2 has a list of 500 email addresses only.
What I’m looking for: if Table 2 email addresses are found within in Table 1 users, I want one of my single entry fields for those users to update in Table 1 from“l “No” to “Yes”
Basically I’m trying to mark on Table 1 who belongs to Table 2 as well.
Thanks!
Oct 26, 2021 02:12 PM
Welcome to the Airtable community!
There a ways to automate this, but it might not be easy.
Here are some questions to consider.
One way to do this is to have a button script to do the comparisons and set the field values. Then have another automation script to watch for new records or change to email addresses and set the field value. On the other hand, this requires scripting knowledge.
If each email address in [Table 2] appears exactly one time in [Table 1], it might be trigger an automation from the record in [Table 2] and use a “find actions” automation action to update the record in [Table 1]. However, if there are situations where the email does not exist in [Table 1] or there are multiple matches in [Table 1], the automation won’t work.