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

[ethang]

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. 

[Stephen_Orr1 · Accepted solution]

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]

My man!

Worked really well.