Time In/Time Out Formula
Hello, can someone help me with the formula for getting the current date/time and set it as value on field with a click of a button? Basically, I'm trying to create a time in/out table where it will h...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendnot tested but try thisas a formula URL button
var text URL = urlroot() & "db/" & dbid() & "?act=API_EditRecord"
& "&apptoken=xxxxxxxxx" // if you have app tokens enabled
& "&_fid_99=now"; /// assumes the field ID 99 is the date time field to be updated.
var text RefreshPage = URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl();
$URL
& "&rdr=" & URLEncode($RefreshPage)
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
var text URL = urlroot() & "db/" & dbid() & "?act=API_EditRecord"
& "&apptoken=xxxxxxxxx" // if you have app tokens enabled
& "&_fid_99=now"; /// assumes the field ID 99 is the date time field to be updated.
var text RefreshPage = URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl();
$URL
& "&rdr=" & URLEncode($RefreshPage)
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Thank you so much for the quick reply, I tried it out but I could not save the formula due to an error. It says it's Expecting datetime but found text.
------------------------------
frnmj
------------------------------I changed the field type from "Formula - Date/Time" to "Formula - Text" and the error went away. However, when I tried it out it takes me to this page:
------------------------------
frnmj
------------------------------- MarkShnier__YouThe field type for the button to push is formula URL. You need to adjust the 99 to be the field ID of the date time field you want to update.
I suggest that you disable the need for application tokens. That is set in the App Properties.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------I have now changed the field type to "Formula - URL" and disabled application tokens. However, when I click on the button, it takes me to this page:
------------------------------
frnmj
------------------------------
