Need help with notifications for child records that are modified within an embedded report on a parent form?

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered
I use a formula checkbox field in the child records that fires the notification, and the records are added/modified/and deleted within an embedded report on the parent form. Let's say I add new record(s) and the checkbox becomes true as a result, then the notification will fire.  If the record(s) is subsequently modified, resulting in the checkbox returning to false, and then they are modified a second time resulting in the checkbox becoming true (again), the notification doers not fire again.  I wish it would fire again.  I believe it does not fire a second time because I am saving (modifying) the parent record not the child, despite the fact that the checkbox field is a child field, and despite the fact that it already fired the first time.   Is there a way around that?  I would prefer an automatic solution. FYI - The notification is in the child table and it is set to notify when a record is added/modified/or deleted.
Photo of Robin CC

Robin CC

  • 200 Points 100 badge 2x thumb

Posted 4 years ago

  • 0
  • 1
Photo of QB_Support_Brian

QB_Support_Brian

  • 40 Points
Hi Robin,

Email notifications respond to changes on a specific table, but they are not able to listen for changes to related records in other tables. If the second modification you mentioned requires you to save the parent record, but not the child, then the notification would not be sent. Database triggers would be needed to support this using native QuickBase, so I would definitely add your vote to the existing suggestion on our uservoice forum here:

https://quickbase.uservoice.com/forums/111823-quickbase-product-feedback/suggestions/1904137-quickba...


If the second modification does involve saving the child record, could you open a support case about this? (You can do so under Help > Manage Support Cases > + New Case) That way one of our customer care specialists can take a look at this with you.



Thanks,

Brian