October 10, 200223 yr Newbies I have a checkbox in one layout, that returns the date modified in another layout. Is there a way that I can instead, get it to return the date first checked, and return nothing if the checkbox is subsequently unchecked? thanks, Ben
October 10, 200223 yr Hello Ben, What you might like to try is setting up a field with an Auto-enter by calculation option, with the formula set to: Case(YourCheckbox = "YourCheckboxValue", Status(CurrentDate)) This will remain empty until the checkbox is checked, but will ignore all subsequent changes to the checkbox (unless the value in it is deleted, in which case it will acquire a new value the next time the checkbox is checked after it became empty).
Create an account or sign in to comment