Hi there,
I have a form that captures email
Here is an example of what the data could look like
I'm trying to create an automation such that any time a unique email is entered, data is populated here. In the table above you see that ethan@abc.com is entered a few times, yet only appears once below.
You'll need to use a Find Records action to determine if an email is unique. Your automation would look something like this:
Trigger: When record is created in Submissions
Action: Find Records, where Submissions table's email field = trigger record's email field
Conditional action: If found Records = 0, Create Record in Email table and populate Email with trigger record's email field
Hope that helps!
My man!
Worked really well.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.