Forum Discussion
CaroleVandenbe2
5 years agoQrew Trainee
Thanks - just tried and it says $TriggerEmailURL is not declared. Is this something I need to do in the Formula URL field as well?
------------------------------
Carole Vandenberg
------------------------------
------------------------------
Carole Vandenberg
------------------------------
MarkShnier__You
Qrew Legend
5 years agosorry, copy paste error
var text URL = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#]
& "&_fid_58=" & URLEncode(Now());
"javascript:" &
"$.get('" &
$URL &
"',function(){" &
"location.reload(true);" &
"});"
& "void(0);"
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
var text URL = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#]
& "&_fid_58=" & URLEncode(Now());
"javascript:" &
"$.get('" &
$URL &
"',function(){" &
"location.reload(true);" &
"});"
& "void(0);"
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- CaroleVandenbe25 years agoQrew TraineeManual change of the date/time field does trigger the notification but the Formula URL does not update the date/time field. I checked - I am using the correct FID (140) and I also tried using the apptoken too. No luck - any ideas on what to try next? Thank you!
------------------------------
Carole Vandenberg
------------------------------- MarkShnier__You5 years ago
Qrew Legend
the way to debug this is to do this
var text URL = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#]
& "&_fid_58=" & URLEncode(Now());
$URL
//"javascript:" &
//"$.get('" &
//$URL &
//"',function(){" &
//"location.reload(true);" &
//"});"
& "void(0);"
ie comment out the javascript stuff and just run the URL. That will expose the error message. The javascript refresh hides any error message and just refreshes the page.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- CaroleVandenbe25 years agoQrew TraineeIt's an apptoken error. I do think I need these. I put it in the code, and checked it twice, even created a new one and tried the new one. Keep getting the error 24 that it's not assigned. xxx below replaces the actual apptoken. But note the void(0) appended - does that tell something? I've checked for spaces and there are none. I am literally copying/pasting from the apptoken list into the code.
<qdbapi><action>API_EditRecord</action><errcode>24</errcode><errtext>Invalid Application Token</errtext><errdetail>The Application Token xxxvoid(0); has not been assigned to this Application. To read about assigning an Application Token to your application go to https://help.quickbase.com/user-assistance/app_tokens.html</errdetail></qdbapi>
------------------------------
Carole Vandenberg
------------------------------