Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

When a record is created create a record only is value is unique

Topic Labels: Automations
Solved
Jump to Solution
818 2
cancel
Showing results for 
Search instead for 
Did you mean: 
ethang
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi there,

I have a form that captures email

ethang_0-1685633493366.png

Here is an example of what the data could look like

ethang_1-1685633521792.png

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. 

ethang_2-1685633557770.png

 

 

 

 

1 Solution

Accepted Solutions
Stephen_Orr1
10 - Mercury
10 - Mercury

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!

See Solution in Thread

2 Replies 2
Stephen_Orr1
10 - Mercury
10 - Mercury

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!

ethang
5 - Automation Enthusiast
5 - Automation Enthusiast

My man!

Worked really well.