Automation Modify vs new record

Question

I have an automation that will trigger a new record in a separate table.&nbsp; There are two scenarios where I want a new record created.&nbsp; One is when a new record is created in the parent table and two is when a field changes from blank to being populated in the parent table.&nbsp; I only want it to create a new record if a current record doesn't exist in the child table.&nbsp; My issue I have is creating a work around that won't create a new record in the child table every time the field from the parent table changes.&nbsp; I know I can add a step to the automation to update a field in the parent table that child table was created as a potential work around to filter the trigger but I wanted to see if there was an easier way.&nbsp;&nbsp;

chayceduncan2 · Answer

An easy way is to just create a summary field to count the number of child records. Add that as a filter in your automation to only fire if the value in the summary counter is 0

scotttalarico · Answer

Thanks.&nbsp; That was a helpful fix

Forum Discussion

Automation Modify vs new record

Related Content

Modify multiple rows within the same group using Single Record ?

Custom Record Titles

Pipelines automation to change record owner

Using Grid Edit to Edit Multiple Records at Once

Record Details