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 have two buttons and two fields. Clicking the Time In button populates the Time Int field with the current date/time, same thing for the Time Out button.
------------------------------
frnmj
------------------------------
Question
Time In/Time Out Formula
This topic has been closed for replies.
+22not 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
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.