Child table updates and triggers an email from Parent table

Question

Not sure if this is possible, but looking for a creative way to trigger an email when a child record is added.&nbsp; BUT the email needs to trigger from the parent record.
Parent table:&nbsp; Adds customer information.
Connected Child table adds an issue and up to 3 issues can be added.Seebelow:

I was hoping that I could get the child record to update "Issue Added" check box on the parent table and I could fire the email off of that.&nbsp; Any suggestions would be greatly appreciated.&nbsp; Thank you------------------------------Kathy Benjamin------------------------------

markshnier__you · Answer

This, &nbsp;would be easy to do with a Pipeline. &nbsp;On the parent record, you could have a Checkbox field, which when change would trigger an email notification. &nbsp;Then you could have a Formula Field on the Parent Rykert, which would be the opposite of that Checkbox field. &nbsp;
The formula would be.&nbsp;
not [my check box field]
The pipeline would trigger when a child record is added it within the next step would be to look up the parent record, I think that step is called Fetch record, and then the step after that would be to change the checkbox field to the value in the field opposite checkbox field
------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

Forum Discussion

Child table updates and triggers an email from Parent table

1 Reply