Do anyone know of a way to track email notifications

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
I created a button to change a checkbox field and the email notification is setup to send when the checkbox field is changed.  Do you know of a way to track the notification?
Photo of Shontay

Shontay

  • 490 Points 250 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of Avinash Sikenpore

Avinash Sikenpore

  • 162 Points 100 badge 2x thumb
It is a slightly complex process but I have done it for one of my application.

Here is how it works. Create a field known as email toggle as a checkbox.

Then create a formula text field that will change the email toggle field (true from false and false from true) and create a record in another table capturing information like (who the current user was, etc) - here is the formula for the button 

var bool toggleemail = If([Email Toggle (Approval)]=true,false,true);
var text URLONE = URLRoot() & "db/XXXXXX?a=API_AddRecord&apptoken=xxxxxxxxxxxxxxxxxx&_fid_10=true&_fid_6=" & URLEncode ([CRN Number])&"&_fid_8=" & URLEncode ([Current User]);
--- THe code above will create a record of someone clicking the email toggle button.



var text URLTWO = URLRoot() & "db/YYYYYYYY?a=API_EditRecord&apptoken=AAAAAAAAAAAAAAA&rid=" & URLEncode ([Record ID#])&"&_fid_560=" & URLEncode ($toggleemail)&"&rdr=";


----- this code above modifies the existing record and toggles the checkbox



"<a href='"& $URLONE &"&rdr="&URLEncode($URLTWO &URLEncode("ZZZZZZ?a=q&qid=44")) &"'><img src=\"https://images.quickbase.com/si/24/016-email_0.png\"></a>",


This code will combine the 3 actions - Create new record of email notification in your logging table -> change toggle email checkbox to enable notification trigger -> redirect them to table to ZZZZZZ with report #44.

I have attached some screenshots.