🔁 How to set up a recurring daily checklist

[Jeff_Hager]

Here’s some copyable examples of lists using images or emojis for your checked and unchecked status. It’s not exactly what you are looking for, but might help you get some ideas.

Reset Multiple Rows At Once

There have been several requests for people to find a way to clear a value in multiple rows. I was thinking about that and came up with a quick example of a way to handle that. Instead of trying to clear a value in an entire column, I realized we could just change one value on a parent column, load it as a single value in our sheet and then compare that parent value to a column that we set or unset for each row. It’s not about clearing an entire column, it’s about making a value in each row n…

A checklist style layout is probably not the best if you want them to reoccur.
I also don’t quite understand why you aren’t getting the checkbox to show as checked or not. You should be able to tap directly on the checkbox to check it and it will fill the column you have set for your checked value as true or false. If you are going into the details of the list item and clicking a button, then it should be writing true or false to that same column. I don’t know if you are maybe setting some other value other than true or false.

Instead, to get the reoccurring part to work, I would use a regular inline list with an image or emoji and have it set up so either tapping on the list item, or going into the details and clicking a button will write a timestamp of the current date/time to one of the columns. Then create an IF column that will check if that timestamp is WITHIN TODAY. If it is, then return the image url or emoji for a checked status. Else return an image url or emoji for an unchecked status. That way after midnight, the image will change and reset to unchecked and once you reset the timestamp, it will show as checked until the next day.

My example above uses Unique ID’s instead of timestamps, but the general idea is the same. You can simplify what I did quite a bit and ignore the whole Reset Multiple part.

[Ludka]

Thank you so much!

[Ludka]

Hi Jeff. Thank you so much for such a thorough advice. I actually did what you are advising me in the end - inline lost, tabs, when completed within today, then display checkmark, and my empty box is just an icon that i added in front of my task text it didn’t occur to me to put that into the “when not completed within today”, thats a perfect solution (im completely new to glide, apps, even spreadsheets). so thank you so so much

[Ludka]

I just want to say a massive THANK YOU to @Jeff_Hager and @ThinhDinh because you guys helped me a lot and now I’m so proud that I have a nice empty box, when clicked it’s a nice moving green checkmark, AAAAND when clicked AGAIN, it gets unclicked and becomes an empty box/square again!

I’m very proud lol. thank you
also, of course @Robert_Petitto

[Olivia_Green]

Hello Robert,

Thank you for providing this tutorial. It is helpful. Is there a way to change the if-then-statement to “within 30 minutes” vs within today?

[Jeff_Hager]

That would just require a math column that adds 0.0208333 (the equivalent of 30 minutes) to the timestamp and then use an IF column to compare the math date to now.

[Olivia_Green]

Thank you, Jeff.