I wanted to share with you my newest template: Our Chores. I’ve seen several requests over the past week for a tutorial on task management as well as creating an onboard experience using the new User Profiles feature. I created version 1.0 of this app in under 24 hours—I plan on enhancing/gamifying it in the future. Take a look at the video tour below:
If you’d like to try the app as a child, visit:
If you’d like to make a copy for yourself, on a desktop, laptop or tablet, visit:
If you’d a tutorial on how I created the onboarding experience, just watch the video below:
A great app, thanks for sharing! I am trying to build something similar for my startup, however, I need a list of predefined tasks by client location. Is it possible for a form to read a table of tasks (columns are the task header and rows are the rooms my guys are cleaning and each cell is the actual task)? My thought is to have another sheet to collect the timestamps of when they say ‘completed’. Happy to hop on a call and pay for your time
They are, yes. Once a sales rep builds the task list (an app for another day) it produces a list of tasks that have to be done, by room, for that specific location. I am taking it a step further by showing the cleaning person not only the task, but a picture of the materials he/she needs to do the job in that room. For example, a bathroom task may be: “Clean the toilet with the RED cloth” and a corresponding image of a red cloth and spray bottle. I simply have the images paired with the task.
Happy to share my Sheet so you can see the tabs and columns. And also happy to pay for consultation, your time is valuable to me.
Gotcha. This sounds like a great instance for user specific columns…only issue is the reset and tracking of the list. User specific columns will allow you to push out a list to everyone who needs it and they can each mark things off on the list without affecting other users. The problem is this feature is so new that it doesn’t have support for the centralized tracking (by an admin let’s say) of the checkboxes per user. Likewise, the user specific columns live in the data editor and not the sheet, so a Google Sheets script couldn’t be run to reset the values nightly.
Recurring tasks is something I’ve been pondering for a while now. Let me play with it a bit today and I’ll reach out in a bit.
Seriously…problem with onboarding experiences is that you can only see them in the published app. In the builder for a new build, the app doesn’t recognize you’re signed in (even though your email address will show in the profile section of the menu).
@George_B or anyone else with scripting knowledge… If I set up a sheets script to clear the users column every minute, will other users inherit this script in their sheet when they make a copy?
I don’t think scripts transfer with a template because if the way the sheet data is copied. Basically glide grabs the data, creates a new sheet in a new account, then pushes the data to the new sheet. It’s not the same as copying a sheet within your own account