Automation Modify vs new record

  • 0
  • 1
  • Question
  • Updated 2 weeks ago
  • In Progress
I have an automation that will trigger a new record in a separate table.  There are two scenarios where I want a new record created.  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.  I only want it to create a new record if a current record doesn't exist in the child table.  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.  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.  
Photo of Scott

Scott

  • 170 Points 100 badge 2x thumb

Posted 2 weeks ago

  • 0
  • 1
Photo of Chayce Duncan

Chayce Duncan

  • 140 Points 100 badge 2x thumb
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
Photo of Scott

Scott

  • 170 Points 100 badge 2x thumb
Thanks.  That was a helpful fix