Looking to make a list of daily tasks that the user can check off in a checkmark component, and have the responses reset daily. Is this possible to do within glide or would I need to find a script to do this in Google Sheets? Any leads are appreciated. Thanks!

I think you would need a script. It shouldn’t be that difficult, if you have any questions or need a start give us more details.

@George_B Copy of Tasks Sample slavetasks Username,Task 1 ,Task 2,Task 3,Task 4 User A User B Users are added as they register for the app. The "Username" column on my sheet is populated with an "IMPORT" function. Users are added when they register. I want to…

Here you go. Copy of Copy of Tasks Sample slavetasks Username,Task 1 ,Task 2,Task 3,Task 4 User A User B

Hi, how can I view this? Am a beginner and just wondering if I can borrow the code to clear a column too…

@simpler Just click the link. You should end up in View only mode. Go to File/Make a copy. Once that is open you can go to Tools/Script editor and look at the script. The script has only 3 functions. One that creates the menu item on open, another one to run the onOpen via the onInstall event. …

Thanks for the quick reply. I’ll have a look now.

Hi George, is there a way to re-use this script to do the following for shopping list: eg. I note to buy 3 items and once I check it off, the 3 items are recorded in my pantry list for next time? And the to do list is cleared? (I’m afraid I couldn’t run the script to see how this actually works)…

I’m not sure you would even need a script to do what you want to do. I would suggest that you watch at least 5 or 6 of @JackVaughan ’s tutorials and build a few of the apps he walks you through step by step, if you haven’t done so already. Then create a document that has as much detail as you can t…

Hi, I have. I created sheet with list of pantry items. When I note the quantity I want and then check them off once I buy them. I then want the quantity bought to be recorded that it’s in the pantry and the quantity cell is cleared for the next time. Any ideas? Jack’s videos doesn’t have it, I’ve …

I would suggest you need to create another sheet that pulls in any item from your main list that has a qty needed, your shopping list. Then you would add an additional column to that sheet that would hold the checkbox result. When at the store you would check off the items that you actually bought…

Reset values daily

Ask for Help

George_B October 29, 2019, 1:37am 4

Here you go.

Edit sheet through glide

Topic		Replies	Views
Button in Google Sheet to 'Clear/reset' Ask for Help	14	9572	March 2, 2022
New Row in Spreadsheet for Every User Ask for Help	52	3697	September 26, 2020
Reset column per user per day Ask for Help	4	461	September 17, 2020
How to clear whole column? Ask for Help actions	61	4976	November 3, 2023
Clear Cells Ask for Help	8	1217	September 26, 2020

Reset values daily

Related topics