Update Date & Time field with URL Button
Hey Community, I'm working on some cool approval functionality and want to be able to use a URL button field to 1, change the status and 2, update the date and time of a field. I have everythin...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendIf it's date time field
& "fid_67=now"
It's an "easter egg" undocumented secret that will give the current date/ time when clicked even if the browser has been sitting "stale" for a long time.
This Syntax
& "fid_67=" & urlencode(Now())
will load the current date/ time into the button as the time the screen is loaded, but that will get stale if the screen sits for a while.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
& "fid_67=now"
It's an "easter egg" undocumented secret that will give the current date/ time when clicked even if the browser has been sitting "stale" for a long time.
This Syntax
& "fid_67=" & urlencode(Now())
will load the current date/ time into the button as the time the screen is loaded, but that will get stale if the screen sits for a while.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
The now seem to work but I'm getting an error message when the button is pressed now.
HERE IS THE FOMRULA FOR THE BUTTON:
"javascript:if(confirm ('Are You Sure You Want To Approve This?')){location.assign('/db/" & Dbid()
& "?act=API_EditRecord&apptoken=cppcatecu6khbiyb25chbxtangb"
& "&rid=" & [Record ID#]
& "&_fid_7=Approved"
& "fid_67=now"
& "&rdr=" & URLEncode(URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#]))
&"')}"
------------------------------
Jack Woods
------------------------------
"This XML file does not appear to have any style information associated with it. The document tree is shown below.
<qdbapi>
<action>API_EditRecord</action>
<errcode>0</errcode>
<errtext>No error</errtext>
<rid>2</rid>
<num_fields_changed>0</num_fields_changed>
<update_id>1611595484356</update_id>
</qdbapi>"
HERE IS THE FOMRULA FOR THE BUTTON:
"javascript:if(confirm ('Are You Sure You Want To Approve This?')){location.assign('/db/" & Dbid()
& "?act=API_EditRecord&apptoken=cppcatecu6khbiyb25chbxtangb"
& "&rid=" & [Record ID#]
& "&_fid_7=Approved"
& "fid_67=now"
& "&rdr=" & URLEncode(URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#]))
&"')}"
------------------------------
Jack Woods
------------------------------
- MarkShnier__YouIt's not an error message, just an unfriendly success message. I'm not an expert on that syntax with the popup confirm, but I do have this alternate code that you can try.
var text URL= URLRoot() & "db/" & Dbid() & "?act=API_DeleteRecord&rid=" & [Record ID#]
& "&apptoken= xxxxxxx";
"javascript: " &
"if ( confirm('Are you sure you want to permanently delete this record ? ') == true ){ "&
"$.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
------------------------------
