Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Nov 01, 2022 08:46 AM
Okey…
i get two table… in the first table when user login in the app, create a record with email.
when it creates a record in the first table, I want it to create it in the second one, but if the email is repeated in the first one I don’t want it to be created again in the second one, for example:
Table 1 ---------Table 2
hello@gmail ----hello@gmail
bye@gmail ----bye@gmail
one@gmail ----- one@gmail
hello@gmail … “no create record” …
two@gmail ------ two@gmail
thx!!!
Nov 01, 2022 09:45 AM
You need something that will loop through the automation one by one. You do this by linking the two tables as you have - then using rollups to identify which rows to automate, and a view in the table 2 with a formula referencing a lookup that compares if Table 1 email=Table 2 email. I’ve built this already - Airtable Automation: Cycle through one automation at a time
Simply rename the value or tag field to email in both tables. If you want to see how it works first, shoot me an email at dan.airtable@gmail.com!