Forum Discussion

NealMathews's avatar
NealMathews
Qrew Trainee
8 years ago

Trigger Email Notification

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. 
App builders
Ask about Quickbase functionality
NotificationsEmail
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    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_'s avatar
    _anomDiebolt_
    Qrew Elite
    8 years ago
    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>"