Forum Discussion

BrianDunk's avatar
BrianDunk
Qrew Cadet
3 years ago

JavaScript Warning, How can I get this working again?

I have a button that when clicked changes a Date/Time field (57) to when the button was clicked.  I am now getting a JavaScript warning when I open the properties window of the button field.  How can ...
APIs and custom code
Buttons
BrianDunk's avatar
BrianDunk
Qrew Cadet
3 years ago
Here is my current code:

Thanks for the help.

var text URL = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord"
& "&rid=" & [Budget item ID#]
& "&_fid_57=" & ToText(Now());


"javascript:" &
"$.get('" &
$URL &
"',function(){" &
"location.reload(true);" &
"});"
& "void(0);"

------------------------------
Brian Dunk
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
3 years ago
var text URL = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord"
& "&rid=" & [Budget item ID#]
& "&_fid_57=" & ToText(Now());

var text RefreshPage = URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl();

 
$URL
& "&rdr=" & URLEncode($RefreshPage)


As as side note there is a nuance about the use of Now(). 

if you replace the line with this

& "&_fid_57=now;

The effect will be to populate the field with the moment that the user actually clicks the button as opposed to when the button loaded on the screen.

In many cases it's good enough to be close but if you were writing an application where users were say clocking in and clocking out on a time card system then you want to record the time they actually clicked the button and not perhaps a stale date/time when the page loaded.  

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------