Child Record Change Notification

  • 0
  • 1
  • Question
  • Updated 4 months ago
  • Answered
I am building a lessons learned / read across database. There is a lessons table and an actions table for action items assigning and tracking.

Here is how it will be used:
  1. Person records lesson
  2. Checks a box to read across the lesson to other users
  3. Adds action items to an action items table that is related so that each lesson record may have many action items
  4. Change notifications fire so that users selected for read across are notified of new lessons and updates to lessons
This was pretty easy to set up and is working great, but i would like to fire notifications when action items are added or updated and I can't seem to get that part going. I am trying to do it from the lessons table. Any suggestions?
Photo of Adam Keever

Adam Keever

  • 996 Points 500 badge 2x thumb
  • cautiously optimistic

Posted 4 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,306 Points 50k badge 2x thumb
Re: i would like to fire notifications when action items are added or updated and I can't seem to get that part going. I am trying to do it from the lessons table. . Any suggestions?

A: Set up the Notifications on the Actions Table.
Photo of Adam Keever

Adam Keever

  • 996 Points 500 badge 2x thumb
I thought about that, but how would I show the list of all actions associated with a single lesson record? If I use the Actions table it will fire a notification for a single action.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,306 Points 50k badge 2x thumb
Can you fire a notification off lessons and on the email which is sent to the user, include a form that has the child actions shown on the form?
Photo of Adam Keever

Adam Keever

  • 996 Points 500 badge 2x thumb
That's the best I have come up with so far (saw it as a comment from you on another post - Thanks!).

Thanks
Photo of Adam Keever

Adam Keever

  • 996 Points 500 badge 2x thumb
The only problem with that is when an action item is added from the lesson form the Date Modified field does not fire the notification. So when action items are added or modified, there is no notification sent.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,306 Points 50k badge 2x thumb
You can make a hyperlink to display the Parent record, and suggest the user click the link?  ie include in the Notification triggered off the Action a Hyperlink to the Parent.
Photo of Adam Keever

Adam Keever

  • 996 Points 500 badge 2x thumb
Having trouble getting the hyperlink. The related lesson field just shows up as the lesson ID. Should it be a button that uses the related lesson field?
Photo of Adam Keever

Adam Keever

  • 996 Points 500 badge 2x thumb
...nevermind...