I’m looking for a way to set a date when an action occurs, for instance, ticking a checkbox. Using Now( ) or Today ( ) update on a regular basis depending on the precision, but how can I set a static date when an action occurs?
In my case, I’m trying to have a “Start Date” set when I check an “In Progress” box.
Your best bet in that exact situation is to set a “Row-Changed” automation that watches the specific checkbox column
Then, have the action of the automation update a second column (maybe titled checkbox modified) to be Now(“minute”)
Just know that automations are run on Codas server. This means every time you check that checkbox, a little message is sent over to Coda that says “please update a column in my doc!”
Then a little Coda robot called the “Automation Bot” must come back to your doc and make the actual change.
Because of this journey that must take place, row-changed automations take anywhere from 3-20 seconds depending on how fast your little robot messenger is.
Therefore, if you set your Now() formula without the “minute” option as I have above it will record the change of your row incorrectly (if you care about actual seconds)
That makes sense, thank you! I’m really looking at a precision of days or maybe hours here so unless my internet is really struggling, I think a little lag should be fine
That will only log last modified time as opposed to a running record of all modified times though. I don’t think that’s what you need but just wanted to throw that call out in case others come across this!
There are ways to log every modified time, but it’s a bit more complex. Feel free to ask further if need be!
Hey @Max_Cheney ! You can close to topic from the settings section of this Community post or mark the solution from the three-dot menu on the comment providing the solution as shown here:
Hmm … Maybe you can only select a post as a solution in the topics you create on the Community (as opposed to selecting a post as a solution in someone else’s topic)
At least that would make sense …
Ah thanks for the heads up @Pch and sorry for the oversight @Max_Cheney. This may only be available for certain roles we need to set on our end in the Community. Would you like me to close this conversation, Max?