Discussions

Expand all | Collapse all

Child Record Change Notification

  • 1.  Child Record Change Notification

    Bronze
    Contributor
    Posted 07-17-2018 13:42
    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?


  • 2.  RE: Child Record Change Notification

    Posted 07-17-2018 14:09
    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.


  • 3.  RE: Child Record Change Notification

    Bronze
    Contributor
    Posted 07-17-2018 14:33
    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.


  • 4.  RE: Child Record Change Notification

    Posted 07-17-2018 14:36
    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?


  • 5.  RE: Child Record Change Notification

    Bronze
    Contributor
    Posted 07-17-2018 14:40
    That's the best I have come up with so far (saw it as a comment from you on another post - Thanks!).

    Thanks


  • 6.  RE: Child Record Change Notification

    Bronze
    Contributor
    Posted 07-17-2018 14:59
    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.


  • 7.  RE: Child Record Change Notification

    Posted 07-17-2018 15:02
    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.


  • 8.  RE: Child Record Change Notification

    Bronze
    Contributor
    Posted 07-17-2018 15:26
    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?


  • 9.  RE: Child Record Change Notification

    Bronze
    Contributor
    Posted 07-17-2018 15:30
    ...nevermind...