The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
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.