Notification Triggered by Child Record Update

Question

I have a Project Log (parent) and Items Table (child). The items table has an [Approval Date] field. I would like to trigger a notification at the Project level when all Items in that project have been approved. I created look up fields, [# of Items] and [# of Approved Items]. I want the notification to trigger when [# of Items] = [# of Approved Items] but it's not working. Any suggestions?

------------------------------
Howard Fu
------------------------------

MarkShnierYou · Answer

Notification will only fire when the record is edited by hand or by an API. Not by virtue of summary fields changing. I suggest that you make the notification off the table of the record that changed. Look up those summary fields back down to the child and use them to filter the Notification.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community