Notification Triggered by Child Record Update
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 bee...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendSo, if you were to update 10 records are you looking to send 10 Notifications? Or 1 Notification with a link to the 10 records.
If you want to fire 10 Notifications, try this trick.
Set up a date time fields
[Date/Time to Trigger Notification]
Set up an Automation. Trigger on the same conditions as your Notification and have it update the field [Date/Time to Trigger Notification] with the current date / time.
Then set up a Notification to fire when that changes. Post back and let me know if that works.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
If you want to fire 10 Notifications, try this trick.
Set up a date time fields
[Date/Time to Trigger Notification]
Set up an Automation. Trigger on the same conditions as your Notification and have it update the field [Date/Time to Trigger Notification] with the current date / time.
Then set up a Notification to fire when that changes. Post back and let me know if that works.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Hi Mark,
I want to fire 1 notification when all the items have been approved, whether that's 1 or 10 at a time. Sometimes, the condition is satisfied when 1 date is entered. For example 4 of 5 items have been approved previously and the last one gets approved. Now all items are approved and the notification fires. I got this to work.
But there are situations where maybe 2 of 5 drawings have already been approved. When the last 3 drawings get approved at the same time, the approval date is entered for all 3 items at the same that. At that time, I would like the same notification to fire. In this situation, it would be fine if there's 1 notification with a link to the items or project.
------------------------------
Howard Fu
------------------------------
I want to fire 1 notification when all the items have been approved, whether that's 1 or 10 at a time. Sometimes, the condition is satisfied when 1 date is entered. For example 4 of 5 items have been approved previously and the last one gets approved. Now all items are approved and the notification fires. I got this to work.
But there are situations where maybe 2 of 5 drawings have already been approved. When the last 3 drawings get approved at the same time, the approval date is entered for all 3 items at the same that. At that time, I would like the same notification to fire. In this situation, it would be fine if there's 1 notification with a link to the items or project.
------------------------------
Howard Fu
------------------------------