Is is possible to send notifications based on summary fields in parent records?

  • 1
  • 2
  • Question
  • Updated 2 months ago
  • In Progress
I'm trying to send notifications based on summary fields in parent records, the table structure is a parent record that has multiple sub records. the sub-records are categorized (Client, Vendor, Internal). I've got summary fields telling me how many sub-records are active for each category. I'd like to trigger a notification when the summary count = 0. ie "all client tasks have been completed"

any ideas how to achieve this?
Photo of Brian Perry

Brian Perry

  • 80 Points 75 badge 2x thumb

Posted 1 year ago

  • 1
  • 2
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
The notification wont change based on a summary field change.

But, you can set the notification to tricker based on the child record change when it meets the same criteria.

You will need to send the summary field back to the task table.  

Then your notification can trigger when the value is 0 and the task is marked complete.  (Or some other criteria based on your use case).

Does that make sense?  Will that help you?
Photo of Claude

Claude

  • 70 Points
Quickbase needs to add the ability to send notifications based on formulas not just user activity. The platform is too expensive not to have this functionality.