# Need help with the Relations of users and Tasks Completed **URL:** \ **Category:** Ask for Help\ **Created:** [February 23, 2020, 8:01am UTC](https://community.glideapps.com/t/need-help-with-the-relations-of-users-and-tasks-completed/4860 "2020-02-23T08:01:51Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![esplitt](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/esplitt/32/3748_2.png) [@esplitt](https://community.glideapps.com/u/esplitt)\ **Post date:** [February 23, 2020, 8:01am UTC](https://community.glideapps.com/t/need-help-with-the-relations-of-users-and-tasks-completed/4860/1 "2020-02-23T08:01:51Z")
Hi, I’m new to Glide, but loving it so far. I’m making a task management app that has a list of pre-defined and recurring tasks with due dates. Each user needs to be able to log in and complete the tasks by checking them off. Every time a new user comes along, they should see all the same tasks for them to complete. My task sheet columns are: Task, Date, Completed, notes I also have a sheet with User emails. I’ve read and watched many tutorials online, but none show me what I’m trying to do. Per-user data is confusing here because I have multiple users who each have multiple tasks. And Multiple tasks can all have multiple users. Can someone please advise me on what sheets I need set up and what columns need to be related? Thanks! ---
**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:** [February 23, 2020, 12:30pm UTC](https://community.glideapps.com/t/need-help-with-the-relations-of-users-and-tasks-completed/4860/2 "2020-02-23T12:30:14Z")
For multiple tasks, should each user have their own version of the task (each user must complete this task individually) or is the task collaborative, meaning anyone can complete the single task and have it cleared from all lists? ---
**Author:** ![esplitt](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/esplitt/32/3748_2.png) [@esplitt](https://community.glideapps.com/u/esplitt)\ **Post date:** [February 23, 2020, 2:29pm UTC](https://community.glideapps.com/t/need-help-with-the-relations-of-users-and-tasks-completed/4860/3 "2020-02-23T14:29:21Z")
It is not collaborative. They need to complete them individually. ---
**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:** [February 23, 2020, 2:59pm UTC](https://community.glideapps.com/t/need-help-with-the-relations-of-users-and-tasks-completed/4860/4 "2020-02-23T14:59:20Z")
Might need to create a list of all tasks and then a separate sheet that tracks the completion of those tasks via form button (log of users submitting a form). The log would include the users email address. In the master task list sheet: 1. Create a multiple relation between the task name in the this list of tasks and the task name in the log form. 2. Create a lookup of the email column in the log (this returns the users who have completed the task) 3. In the layout view, filter the task list where email lookup column is not signed in user. I’ve done something similar in my app: [itemstore.glideapp.io](http://itemstore.glideapp.io). Check out the “challenges” tab to see the functionality. ---
**Author:** ![Scott\_Hack](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/scott_hack/32/3408_2.png) [@Scott\_Hack](https://community.glideapps.com/u/Scott_Hack)\ **Post date:** [February 23, 2020, 3:24pm UTC](https://community.glideapps.com/t/need-help-with-the-relations-of-users-and-tasks-completed/4860/5 "2020-02-23T15:24:04Z")
@Robert_Petitto - Is it okay if I use your app and check it out? ---
**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:** [February 23, 2020, 3:26pm UTC](https://community.glideapps.com/t/need-help-with-the-relations-of-users-and-tasks-completed/4860/6 "2020-02-23T15:26:57Z")
Of course! Submit an entry! It’s a concept app, play around. It’s not ready for copying yet, though. I’m waiting for a couple features and the ability to reorder/rearrange data columns as it’s been pieced together as I come out with new ideas. ---
**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:** [February 26, 2020, 2:03am UTC](https://community.glideapps.com/t/need-help-with-the-relations-of-users-and-tasks-completed/4860/7 "2020-02-26T02:03:04Z")
Take a look at the info in this thread. I have a somewhat working example of Tasks in [https://concepts.glideapp.io/](https://concepts.glideapp.io/). If you copy the app, you can turn on public with email and with some minor changes, get a working example. My example uses a shared list of tasks that can be view and individually completed by multiple users. > [@I want to make this for multiple users](https://community.glideapps.com/t/i-want-to-make-this-for-multiple-users/4023/5): > > Ok, so I’m assuming you have one list of tasks, and each intern will be able to view the same list, but individually mark then completed and have individual notes for example? Does that sound right? There is a new feature in the works that should make this very easy once it’s released. It’s a new column type that will store data per signed in user. I haven’t played with it myself, but you could test it in [https://staging.heyglide.com/](https://staging.heyglide.com/). Again, I have not tested it so I’m not sure if it compl… ---
**Author:** ![RedHeadKev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/redheadkev/32/2821_2.png) [@RedHeadKev](https://community.glideapps.com/u/RedHeadKev)\ **Post date:** [June 4, 2020, 6:53pm UTC](https://community.glideapps.com/t/need-help-with-the-relations-of-users-and-tasks-completed/4860/8 "2020-06-04T18:53:07Z")
Any updates to this thread with some of the newer features or different solutions from above? I have multiple app concepts that would benefit from this concept. Thank you! ---
**Author:** ![RedHeadKev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/redheadkev/32/2821_2.png) [@RedHeadKev](https://community.glideapps.com/u/RedHeadKev)\ **Post date:** [June 5, 2020, 2:07pm UTC](https://community.glideapps.com/t/need-help-with-the-relations-of-users-and-tasks-completed/4860/9 "2020-06-05T14:07:11Z")
@Robert_Petitto, I really like your Itemstore app. Is it available to copy and see the behind the scenes?