Trigger Email Notification

  • 0
  • 1
  • Question
  • Updated 9 months ago
  • Answered
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. 
Photo of Neal

Neal

  • 100 Points 100 badge 2x thumb

Posted 9 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,486 Points 50k badge 2x thumb
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 & ""
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,572 Points 20k badge 2x thumb
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>"
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,486 Points 50k badge 2x thumb
Thx Dan!