Forum Discussion
QuickBaseCoachD
9 years agoQrew Captain
Here is a typical native solution. I can help you with the details of the elements or feel free to contact me directly via the information in my profile for personal assistance.
Make a URL formula button which updates a date email sent field to the value of today and refreshes the page it's on.
The button would be like
var text URL = URLRoot() & "db/" & dbid() & "?act=API_EditRecord&rid=" & ToText([record ID#])
& "&_fid_XXX=" & ToText(Today()); // put in the field ID of the date field here
"javascript:" &
"$.get('" &
$URL &
"',function(){" &
"location.reload(true);" &
"});"
& "void(0);"
Then make any report you like, but include a filer where that date field is not equal today.
Then make an email Notification and trigger it to fire when the date field is changed.
Make a URL formula button which updates a date email sent field to the value of today and refreshes the page it's on.
The button would be like
var text URL = URLRoot() & "db/" & dbid() & "?act=API_EditRecord&rid=" & ToText([record ID#])
& "&_fid_XXX=" & ToText(Today()); // put in the field ID of the date field here
"javascript:" &
"$.get('" &
$URL &
"',function(){" &
"location.reload(true);" &
"});"
& "void(0);"
Then make any report you like, but include a filer where that date field is not equal today.
Then make an email Notification and trigger it to fire when the date field is changed.