Skip to main content
Question

Trigger Email Notification

  • February 15, 2018
  • 0 replies
  • 76 views
I have an app with two tables Table 1(Parent)="Cases" Table 2=(Child)"Case Notes". 

I would like to set-up an email notification from the parent table whenever a new Note(Record) in the Child has been added. The parent record is not being edited, just a note being created in the child, linking it to the parent record. 

1 Case can have many case notes.
I'm completely stuck on how to accomplish this. 
    This topic has been closed for replies.

    You need to build the email Notification on the table being changed, so this is the child table. But you can use any words and fields you like in the custom email Notification, including any lookup fields which you bring down from the Parent Record.

    You can build a hyperlink in the par3nt Record and ghis n look that up to use in the email Notification.

    The format for that field in the Parent would be a formula rich Text field

    var text URL = urlroot() & "db/" & dbid() & "?a=dr&rid=" & [Record ID#];
    var text Words = "Link to Case";

    "" & $Words & ""
    • anomDiebolt
    • Registered
    • February 15, 2018
    I think the forum messed up that formula. I think this is more or less what was intended:

    var text URL = urlroot() & "db/" & dbid() & "?a=dr&rid=" & [Record ID#]; 
    var text Words = "Link to Case";   
    "<a href='" & $URL & "'>" & $Words & "</a>"
    Thx Dan!
    Terms & ConditionsAccessibility statement