How can I add a button to load the current date-time to a field

Here is some code which will do that.  I also have an app in the Exchange called

URL Formuals for Dummies, which helps explain how to write URL formula buttons.


vat text URL = urlroot() & "db/" & dbid() & "?act=API_EditRecord" & rid=" & [Record ID#]
& "&_fid_999=" & URLEncode(Now());

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


The first line creates a formula variable called URL which does the edit.  You will need to set 999 to the field ID which is being set to Now().  Here is some help on formula variables if you have never used them.  https://help.quickbase.com/user-assistance/formula_variables.html

The second part is a handy snippet which simply runs the URL and refreshes the page.