Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jun 01, 2023 08:36 AM
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.
Solved! Go to Solution.
Jun 01, 2023 08:44 AM
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!
Jun 01, 2023 08:44 AM
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!
Jun 02, 2023 08:05 AM
My man!
Worked really well.