Forum Discussion

Qrew Member

3 years ago

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...

Buttons

Formulas and functions

MarkShnier__You

Qrew Legend

not 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
------------------------------

frnmj

Qrew Member

3 years ago

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
------------------------------