ContributionsMost RecentMost LikesSolutionsRe: Date stamped when a checkbox is checkedThank you so much!!! ------------------------------ Mariana Alejandra Ayala ------------------------------ Date stamped when a checkbox is checkedHi, I need to be able to create a date stamped when an additional field is checked. This checkbox will be editing most likely in a grid edit report and I would like to be able to save date and time when this particular field is checked. I tried to use the Quickbase action, even as administrator of my app I'm not able to create it editing an existing record. Is there an other way to do it? Thanks in advance Regards ------------------------------ Mariana Alejandra Ayala ------------------------------ Re: Date stamp formula for checkboxHi 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 ------------------------------ Re: Date stamp formula for checkboxNow the formula seems to be right, but I don't have the time stamp on the field Do I need to link in some way the "Time Capitalized" (checkbox field) to the "Time" (URL formula field) Sorry I'm not familiar at all about URL formulas. Thanks ------------------------------ Mariana Alejandra Ayala ------------------------------ Re: Date stamp formula for checkbox Mark, Is giving me the next error: The variable $TodaysDate is not declared. Regards ------------------------------ Mariana Alejandra Ayala ------------------------------ Re: Date stamp formula for checkboxHi Mark, I'm still struggling with the formula, the variable in yellow what highlighted like this on the formula section Thank you Regards ------------------------------ Mariana Alejandra Ayala ------------------------------ Re: Date stamp formula for checkboxHere is the formula 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" ; "javascript:" & "$.get('" & $Update & "',function(){" & "location.reload(true);" & "});" & "void(0);" I'm not sure if the name or features of the field could be the issue. The formula seems to be right. Not error message. ------------------------------ Mariana Alejandra Ayala ------------------------------ Re: Date stamp formula for checkbox Hi, I'm trying to do the same and I'm using the formula recommended since for some reason even being admin on my app I'm not able to configure the ACTION editing related records. I'm not really experienced on URL formulas, and I'm not receiving any error on the formula, but the date stamp is not working as I was expecting. I would appreciate additional information on how I can make it work. Thanks in advance Regards Mariana Ayala ------------------------------ Mariana Alejandra Ayala ------------------------------