# Simple to do list for my kids

**URL:** <https://community.glideapps.com/t/simple-to-do-list-for-my-kids/7405>\
**Category:** Ask for Help\
**Created:** [April 20, 2020, 5:14am UTC](https://community.glideapps.com/t/simple-to-do-list-for-my-kids/7405 "2020-04-20T05:14:55Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![badger](https://avatars.discourse-cdn.com/v4/letter/b/3bc359/32.png) [@badger](https://community.glideapps.com/u/badger)\
**Post date:** [April 20, 2020, 5:14am UTC](https://community.glideapps.com/t/simple-to-do-list-for-my-kids/7405/1 "2020-04-20T05:14:55Z")

</div>

Hi I’m trying to build a simple to do list app for my kids.

I want to type in tasks into a spreadsheet. And in the app I want my kids to say if they did the task or not. And I want that to be written back to the spreadsheet in the row where I entered the task.

Can Glide do this?

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [April 20, 2020, 6:06am UTC](https://community.glideapps.com/t/simple-to-do-list-for-my-kids/7405/2 "2020-04-20T06:06:56Z")

</div>

Sure can! Though, it would be a lot easier if it doesn’t get written back to the sheet. You’d be able to use User Specific columns:

> [@User Specific Columns + User Profiles Demo](https://community.glideapps.com/t/user-specific-columns-user-profiles-demo/7097):
>
> call_me_hand Hey all! Wanted to create a quick and very rough demo of Glide’s two newest features: User Specific Columns and User Profiles. The video covers the process from sheet creation to feature implementation. Hope this helps until an official video comes out! [[Glide: User Specific Columns and User Profiles Demo] ](https://www.youtube.com/watch?v=9LLur9db8NM)

---

<div class="post-metadata">

**Author:** ![badger](https://avatars.discourse-cdn.com/v4/letter/b/3bc359/32.png) [@badger](https://community.glideapps.com/u/badger)\
**Post date:** [April 20, 2020, 1:40pm UTC](https://community.glideapps.com/t/simple-to-do-list-for-my-kids/7405/3 "2020-04-20T13:40:29Z")

</div>

Is it possible to write back to the sheet?

The person who enters the tasks needs to know if they get done.

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [April 20, 2020, 1:45pm UTC](https://community.glideapps.com/t/simple-to-do-list-for-my-kids/7405/4 "2020-04-20T13:45:09Z")

</div>

Could you have a “parent account” within the app that allows for the entering and checking of tasks?

---

<div class="post-metadata">

**Author:** ![badger](https://avatars.discourse-cdn.com/v4/letter/b/3bc359/32.png) [@badger](https://community.glideapps.com/u/badger)\
**Post date:** [April 20, 2020, 1:46pm UTC](https://community.glideapps.com/t/simple-to-do-list-for-my-kids/7405/5 "2020-04-20T13:46:06Z")

</div>

We really need each user to do that. So the user will receive a task, mark it as complete, and the parent can then see which tasks are completed vs not completed.

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [April 20, 2020, 1:51pm UTC](https://community.glideapps.com/t/simple-to-do-list-for-my-kids/7405/6 "2020-04-20T13:51:09Z")

</div>

Right. This can all be done in the app if you wanted. When parents sign in, they’ll have access to “add a new task” that kids won’t have. Can even build a dashboard for parents to see which tasks have been completed.

---

<div class="post-metadata">

**Author:** ![badger](https://avatars.discourse-cdn.com/v4/letter/b/3bc359/32.png) [@badger](https://community.glideapps.com/u/badger)\
**Post date:** [April 20, 2020, 1:52pm UTC](https://community.glideapps.com/t/simple-to-do-list-for-my-kids/7405/7 "2020-04-20T13:52:33Z")

</div>

the part I dont understand how to build here is…how do you give each kid a task, have them answer Yes or No and then write that back to the gsheet.

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [April 20, 2020, 2:06pm UTC](https://community.glideapps.com/t/simple-to-do-list-for-my-kids/7405/8 "2020-04-20T14:06:56Z")

</div>

I recommend taking a look at the task tracker template for a general sense of the mechanics:  
[https://go.glideapps.com/app/task-tracker-template](https://go.glideapps.com/app/task-tracker-template)

You’d need a sheet that lists your kids and a sheet that will house the tasks that need completing. You can create a form button that will allow you to create a new task and assign it to one of the kids from the kids sheet (using a choice component). In the task sheet you’ll want to collect kid name, task name, timestamp, due date, and kid email address (if your kids are signing into the app to see tasks specific to only them). In that sheet should also be a column that will allow for the true/false checkbox value so kids can mark the task as done.

Then it’s just a matter of creating relations and components to display the list per kid and configuring visibility settings on the form buttons, etc so that kids can’t create their own tasks (unless you want them to).

It’s hard to explain all the intricacies through text, but the app concept is very doable.

---

<div class="post-metadata">

**Author:** ![badger](https://avatars.discourse-cdn.com/v4/letter/b/3bc359/32.png) [@badger](https://community.glideapps.com/u/badger)\
**Post date:** [April 20, 2020, 2:20pm UTC](https://community.glideapps.com/t/simple-to-do-list-for-my-kids/7405/9 "2020-04-20T14:20:14Z")

</div>

Thanks I’ll check that out.

this particular example has projects and then projects have tasks

I just really wanted tasks and I was confused how to remove projects from that example

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [April 20, 2020, 2:32pm UTC](https://community.glideapps.com/t/simple-to-do-list-for-my-kids/7405/10 "2020-04-20T14:32:35Z")

</div>

I’ve been meaning to try my hand at a legit task tracker. Maybe I’ll throw one together today or tomorrow.

---

<div class="post-metadata">

**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\
**Post date:** [April 20, 2020, 8:23pm UTC](https://community.glideapps.com/t/simple-to-do-list-for-my-kids/7405/11 "2020-04-20T20:23:08Z")

</div>

The problem I see with using user specific rows for something like this is that the only one who can uncheck the task is the user themselves. So you can’t write code to uncheck all the routine daily tasks, or have the parent see that they are checked and then uncheck them for the next day.

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [April 20, 2020, 9:20pm UTC](https://community.glideapps.com/t/simple-to-do-list-for-my-kids/7405/12 "2020-04-20T21:20:11Z")

</div>

Right. User specific columns don’t work here. I’m in the middle of building a chores app for my kiddos. I’ll share when completed (nearly there)!

Stay tuned!

---

<div class="post-metadata">

**Author:** ![badger](https://avatars.discourse-cdn.com/v4/letter/b/3bc359/32.png) [@badger](https://community.glideapps.com/u/badger)\
**Post date:** [April 20, 2020, 9:24pm UTC](https://community.glideapps.com/t/simple-to-do-list-for-my-kids/7405/13 "2020-04-20T21:24:19Z")

</div>

In this case the parent defines the tasks and publishes them to each user.

Then each user can mark them as complete or not.

The parent needs to see if they are complete or not

---

<div class="post-metadata">

**Author:** ![badger](https://avatars.discourse-cdn.com/v4/letter/b/3bc359/32.png) [@badger](https://community.glideapps.com/u/badger)\
**Post date:** [April 20, 2020, 9:33pm UTC](https://community.glideapps.com/t/simple-to-do-list-for-my-kids/7405/14 "2020-04-20T21:33:09Z")

</div>

Thanks appreciate it!

---

<div class="post-metadata">

**Author:** ![Chris\_Lusk](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chris_lusk/32/5969_2.png) [@Chris\_Lusk](https://community.glideapps.com/u/Chris_Lusk)\
**Post date:** [April 21, 2020, 5:37pm UTC](https://community.glideapps.com/t/simple-to-do-list-for-my-kids/7405/15 "2020-04-21T17:37:31Z")

</div>

Following this thread to see how it was achieved. I have the same question as Badger. I want a “template” of To Do items and my workers (kids in her case) do the job by marking the tasks as done, and that activity gets recorded to another sheet or tab so I can “audit” the work and keep a history of the jobs performed.

---

<div class="post-metadata">

**Author:** ![dvdbsh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dvdbsh/32/404_2.png) [@dvdbsh](https://community.glideapps.com/u/dvdbsh)\
**Post date:** [April 21, 2020, 5:50pm UTC](https://community.glideapps.com/t/simple-to-do-list-for-my-kids/7405/16 "2020-04-21T17:50:32Z")

</div>

Hmm. Okay so, I’m by no means a pro, but to practice using Glide I sometimes lurk peoples requests or questions to see if I can figure out how to do it myself. This is what I came up with. What I’m sharing is a BLANK sheet, you’ll have to copy it over to use it. This’ll work, right?

[ypvbh.glideapp.io](http://ypvbh.glideapp.io)

Whoever logs in first to the app is automatically deemed the “Admin”, you can see this on the Users sheet. From there, as users log in, it will automatically add them to the Users sheet. These emails are being fed from the Logins sheet via a unique formula.

When you, the Admin, are logged in, you’ll have a dashboard that lets you see what chores are completed, done or overdue. Obviously you can add more chores from here as well.

I’m also a sucker for making things look different, so I did sneak in some _ **ForBIdDEn** _ html/css to make the dashboard look the way it does, but if you don’t want the rich text component there, you can swap it out for regular components and apply the proper filters, or get rid of it all together.

I played around with it only for a little bit, and due to my quarantine I’m out of coffee atm so my brain is absolute mush LOL, but I think it works alright?

Let me know how it works for you.

---

<div class="post-metadata">

**Author:** ![badger](https://avatars.discourse-cdn.com/v4/letter/b/3bc359/32.png) [@badger](https://community.glideapps.com/u/badger)\
**Post date:** [April 21, 2020, 6:27pm UTC](https://community.glideapps.com/t/simple-to-do-list-for-my-kids/7405/17 "2020-04-21T18:27:20Z")

</div>

Thanks How do I take a look at this in the glide editor?

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [April 21, 2020, 6:46pm UTC](https://community.glideapps.com/t/simple-to-do-list-for-my-kids/7405/18 "2020-04-21T18:46:16Z")

</div>

Hey Badger…here you go!

> [@Our Chores v1.0: An app that lets you manage and track your child(ren)'s chores](https://community.glideapps.com/t/our-chores-v1-0-an-app-that-lets-you-manage-and-track-your-child-ren-s-chores/7536):
>
> wave Hello fellow Gliders! 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, …

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [April 21, 2020, 6:55pm UTC](https://community.glideapps.com/t/simple-to-do-list-for-my-kids/7405/19 "2020-04-21T18:55:00Z")

</div>

> [@dvdbsh](#):
>
> These emails are being fed from the Logins sheet via a unique formula.

Just a suggestion, the new user profiles feature could handle automatically adding emails to the users sheet. I think this is better than using unique, because any modifications to the app:logins sheet could corrupt the data in the users sheet.

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [April 21, 2020, 6:58pm UTC](https://community.glideapps.com/t/simple-to-do-list-for-my-kids/7405/20 "2020-04-21T18:58:14Z")

</div>

Open the app in a desktop browser and click on the copy button to copy a template.

[Next page](https://community.glideapps.com/t/simple-to-do-list-for-my-kids/7405.md?page=2)
