Forum Discussion
QuickBaseCoachD
6 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.
- SalesInfo6 years agoQrew Assistant CaptainQuickBaseCoach App Dev./Training,
I still would not know why the email button is not working. Can you please dig into this method and help me figure out why this is not working for the long text body?
Thank you! - QuickBaseCoachD6 years agoQrew CaptainIf you would like one-on-one assistance you would need to contact me directly at QuickBaseCoach.com
I'm not a Quick Base employee :) - QuickBaseCoachD6 years agoQrew CaptainHere 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.