Forum Discussion

AdamKeever1's avatar
AdamKeever1
Qrew Commander
7 years ago

Child Record Change Notification

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?
  • 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.
  • 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.
  • 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?
  • That's the best I have come up with so far (saw it as a comment from you on another post - Thanks!).

    Thanks
  • 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.
  • 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.
  • 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?