Discussions

Expand all | Collapse all

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

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

    Posted 06-27-2017 23:01
    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?


  • 2.  RE: Is is possible to send notifications based on summary fields in parent records?

    Posted 06-28-2017 06:54
    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?


  • 3.  RE: Is is possible to send notifications based on summary fields in parent records?

    Posted 09-10-2018 13:45
    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.