Date stamp formula for checkbox
Hello. I have a quick question regarding date stamps. I have two check-boxes on my form: import and export. For both, I hope to create a formula date stamp field to see when users ticked these b...
Forum Discussion
Another option if you aren't going to be editing individual records on the form, is to make a formula-url field that performs an API_EditRecord function to check the box, timestamp, and even add who clicked it (if desired).
These buttons can be used in reports, or on the form.
These buttons can be used in reports, or on the form.
I'm not sure if Matthew is still active on the forum.
Here is some code to updates some fields ona record and refersh
var date TodaysDate = Today();
var text Update = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#]
& "&apptoken=xxxxxxxxx" // you will need to decide if you want to require app tokens or just disable in App properties
& "&_fid_100=" & $TodaysDate // put the date into fid 101
& "&_fid_101=" & totext(User()) put who clicked into fid 102
& "&_fid_102=1" ; set a checkbox to be true
// then put in this code to execute the formula variable called URL and refresh the page
var text URL =
"javascript:" &
"$.get('" &
$Update &
"',function(){" &
"location.reload(true);" &
"});"
& "void(0);";
Here is some code to updates some fields ona record and refersh
var date TodaysDate = Today();
var text Update = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#]
& "&apptoken=xxxxxxxxx" // you will need to decide if you want to require app tokens or just disable in App properties
& "&_fid_100=" & $TodaysDate // put the date into fid 101
& "&_fid_101=" & totext(User()) put who clicked into fid 102
& "&_fid_102=1" ; set a checkbox to be true
// then put in this code to execute the formula variable called URL and refresh the page
var text URL =
"javascript:" &
"$.get('" &
$Update &
"',function(){" &
"location.reload(true);" &
"});"
& "void(0);";