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
MarkShnier__You
Qrew Legend
Qrew LegendWhen you use that Javascript syntax it hides any error message.
Comment out the bottom javascript lines and just do this to help us debug.
var text Update = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#]
& "&apptoken=dhxpiidu5cj4edz3d8kvbn2cium"
& "&_fid_1469=" & $TodaysDate
& "&_fid_1468=" & ToText(User())
& "&_fid_805=1" ;
$Update
Then post back with the response from the button.
It will either be an error message or a success message.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Comment out the bottom javascript lines and just do this to help us debug.
var text Update = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#]
& "&apptoken=dhxpiidu5cj4edz3d8kvbn2cium"
& "&_fid_1469=" & $TodaysDate
& "&_fid_1468=" & ToText(User())
& "&_fid_805=1" ;
$Update
Then post back with the response from the button.
It will either be an error message or a success message.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Hi Mark,
I'm still struggling with the formula, the variable in yellow what highlighted like this on the formula section
------------------------------
Mariana Alejandra Ayala
------------------------------
I'm still struggling with the formula, the variable in yellow what highlighted like this on the formula section
------------------------------
Mariana Alejandra Ayala
------------------------------
- MarkShnier__YouPlease make a new field with this code
var text Update = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#]
& "&apptoken=dhxpiidu5cj4edz3d8kvbn2cium"
& "&_fid_1469=" & $TodaysDate
& "&_fid_1468=" & ToText(User())
& "&_fid_805=1" ;
$Update
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
------------------------------
Mariana Alejandra Ayala
------------------------------- MarkShnier__YouOK, use this formula and let me know what it does
var text TodaysDate = ToText(Today());
var text Update = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#]
& "&apptoken=dhxpiidu5cj4edz3d8kvbn2cium"
& "&_fid_1469=" & $TodaysDate
& "&_fid_1468=" & ToText(User())
& "&_fid_805=1" ;
$Update
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------ - Now the formula seems to be right, but I don't have the time stamp on the field
------------------------------
Mariana Alejandra Ayala
------------------------------ - MarkShnier__YouAre you saying that button now works? What happens when you click the link? Also are you trying to populate a field with just the date or the current date and time?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------ - Hi Mark,
I wasn't really expecting a link (but send an error if I click on it). What I'm trying to achieve and maybe I explained myself wrong was to collect a date stamp on the URL field when the user make the checkbox on the "Time Capitalized" field while he is using a report. Is this what you were helping me to do?
------------------------------
Mariana Alejandra Ayala
------------------------------ - MarkShnier__YouAre you saying that you simply want to record the date/time that a user checks a checkbox? If that is the situation I suggest that you post a brand new question explaining your use case from the beginning and I will watch for it.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
