Forum Discussion
QuickBaseCoachD
7 years agoQrew Captain
Here is some help text on how to set up an email notification
https://help.quickbase.com/user-assis...
You can also set up a date time field called date email sent
You can then trigger of the email notification to Fire when the checkbook�s field is checked and you can also set up a form rule that when the record is saved and the checkbox field has changed to change the date email sent Peel to the current date and time.
When I get a chance I will post back with the formula to create a button that will check that check box and also set the email sent daytime field to the current date and time. Meanwhile you could get the email notification built.
Post back when you get that working and that will be a reminder for me to post the formula.
https://help.quickbase.com/user-assis...
You can also set up a date time field called date email sent
You can then trigger of the email notification to Fire when the checkbook�s field is checked and you can also set up a form rule that when the record is saved and the checkbox field has changed to change the date email sent Peel to the current date and time.
When I get a chance I will post back with the formula to create a button that will check that check box and also set the email sent daytime field to the current date and time. Meanwhile you could get the email notification built.
Post back when you get that working and that will be a reminder for me to post the formula.
QuickBaseCoachD
7 years agoQrew Captain
Here is an example of code to toggle a checkbox and set a date /time field to the current date time
var bool NewToggle = not [my checkbox field top trigger an email Notification];
var text URL =
URLRoot() & "db/" & Dbid () & "?act=API_EditRecord&rid=" & [Record ID#]
& "&apptoken=xxxxxxxx" // or omit this line if you have disabled the need for application tokens.
& "&_fid_12=" & $NewToggle;
& "&_fid_13=" & urlencode(Now());
"javascript:" &
"$.get('" &
$URL &
"',function(){" &
"location.reload(true);" &
"});"
& "void(0);"
You will need to change the 12 and 13 to your own field IDs.
var bool NewToggle = not [my checkbox field top trigger an email Notification];
var text URL =
URLRoot() & "db/" & Dbid () & "?act=API_EditRecord&rid=" & [Record ID#]
& "&apptoken=xxxxxxxx" // or omit this line if you have disabled the need for application tokens.
& "&_fid_12=" & $NewToggle;
& "&_fid_13=" & urlencode(Now());
"javascript:" &
"$.get('" &
$URL &
"',function(){" &
"location.reload(true);" &
"});"
& "void(0);"
You will need to change the 12 and 13 to your own field IDs.