Discussions

Expand all | Collapse all

Trigger Email Notification

  • 1.  Trigger Email Notification

    Posted 02-15-2018 03:58
    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. 


  • 2.  RE: Trigger Email Notification

    Posted 02-15-2018 04:19
    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 & ""


  • 3.  RE: Trigger Email Notification

    Posted 02-15-2018 05:16
    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>"


  • 4.  RE: Trigger Email Notification

    Posted 02-15-2018 12:07
    Thx Dan!