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:
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 email@example.com!