I have one table that contains all the names of the people who paid money and one table of cold leads.
I want to automate that when a new record is created in the payer's table, a V will be marked with that user based on their email in the cold leads table 1.
I created an automation that looks for the email of the person who pays in table 1, but I can't find an option to "update records" for that email in table 1 because I can't find his record ID.
I would love to understand what I am doing wrong.
Solved! Go to Solution.
@zerem As far as I understand you can only update one record at a time without having to write an automation script. So in your case I would:
Hope this helps.
Hi @Andrey_Kovalev , thanks for the reply
I'm not sure we understood each other 🙂
I want basically everyone who registers in table 2 to update a certain column in table 1 as well, so I create the automation.
But I can't seem to figure out how I can update table1 based on what happens in table2.