Hey ya’ll, I have a doc where I’m checking off daily goals and I want, when I check the task off for it to fill in today’s date as the day the task was completed. But, I know nothing about formatting code, so I can’t get the formula right. Basically I’m trying to go : If my checkbox row is checked, my date row will enter today’s date. Can anybody help me write that out? A saw a similar post, but couldn’t access the actual code.
I created a GIF walkthrough for you.
Automation is a good approach here, because you ONLY want the date updated if and when the checkbox is actually selected.
3 Likes
Hi @Amber_Lee-Adadevoh and welcome to the Coda Community!
There are many ways you can accomplish that.
I would suggest you to use a button. With a button, you can run actions such as modifying a row.
I just created a doc for you for better understanding. Please check it out and let me know if this solves your problem and if you have any more questions.
Sincerely
Jannis
2 Likes
@Jannis I like your solution better. It’s simpler and immediate.
1 Like
I just saw @Troy_Larson already gave you an answer.
The way he showed is another way to accomplish it.
As I said:
Sincerely
Jannis
Bless you both. I started with the Troy version bc it was closer to what I already set up. One bug at the end. Instead of converting to a date, it’s just showing the text. I put a screenshot of the problem. I appreciate this so much!
open your automations and clear the input in the field “Past date”. Then open the formula editor by typing “=”, type Today() and click “Done”.
Also, make sure the column “Past date” in your table is a date-column. Coda likes to auto change it sometimes.
Please let me know if everything works or if you need any more help.
Sincerely
Jannis
2 Likes
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.