# User specific column associated with a profile column different to email **URL:** \ **Category:** Feature Requests\ **Created:** [December 26, 2020, 8:56am UTC](https://community.glideapps.com/t/user-specific-column-associated-with-a-profile-column-different-to-email/20307 "2020-12-26T08:56:22Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![profechef](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/profechef/32/221_2.png) [@profechef](https://community.glideapps.com/u/profechef)\ **Post date:** [December 26, 2020, 8:56am UTC](https://community.glideapps.com/t/user-specific-column-associated-with-a-profile-column-different-to-email/20307/1 "2020-12-26T08:56:22Z")
I wonder if it would be possible to associate a user specific column with a profile column different to email. Use case 1. A game where different teams have to make some tasks and they can buy some items to help them. Every profile has a team column with the same value. Any member of the team A can mark a task as done or buy any item and only team A members can see it Use case 2 Home work tracking by parents. Every student and his/her parents profiles have a family column with the same value. Teachers write the homework and each student marks a task as done and his/her parents can see what’s done and what is uncompleted ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [December 26, 2020, 9:57am UTC](https://community.glideapps.com/t/user-specific-column-associated-with-a-profile-column-different-to-email/20307/2 "2020-12-26T09:57:11Z")
I assume you’re using a public with email app. Here are my thoughts. I think user-specific columns are assigned to each logged in user, and one specific cell of data can store multiple values, based on which user is logging in. In your case 1, if team A members need to check only 1 specific cell to mark the task as done, then just use conditional visibility so only team A’s members can see that switch/checkbox. That value will show for all team A’s members’ accounts. In your case 2, show the checkbox to the user based on the “family column”. If it needs to be a checkbox on a homework sheet (that multiple students can mark as done) then I think what you want is a submission that writes to another sheet. ---
**Author:** ![profechef](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/profechef/32/221_2.png) [@profechef](https://community.glideapps.com/u/profechef)\ **Post date:** [December 26, 2020, 11:17am UTC](https://community.glideapps.com/t/user-specific-column-associated-with-a-profile-column-different-to-email/20307/3 "2020-12-26T11:17:51Z")
Both cases are the same. Every team must achieve the same targets and can buy the same items. By now I’m doing it with submission, but lines grow too fast: 30 students in a class group, 10 subjects, 2 tasks each subject = 600 lines That’s the reason I’m asking for this feature ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [December 26, 2020, 11:19am UTC](https://community.glideapps.com/t/user-specific-column-associated-with-a-profile-column-different-to-email/20307/4 "2020-12-26T11:19:39Z")
So it’s like a rollup over user specific column? Multiple users can tick on the same box but the “total” value must still be presented to all users who can see the record? ---
**Author:** ![profechef](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/profechef/32/221_2.png) [@profechef](https://community.glideapps.com/u/profechef)\ **Post date:** [December 26, 2020, 11:22am UTC](https://community.glideapps.com/t/user-specific-column-associated-with-a-profile-column-different-to-email/20307/5 "2020-12-26T11:22:18Z")
No. Just one chek on each item by team or student and each team or family can see all the checked items by any team member or by the student. It’s like a “group favorite” ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [December 26, 2020, 11:37am UTC](https://community.glideapps.com/t/user-specific-column-associated-with-a-profile-column-different-to-email/20307/6 "2020-12-26T11:37:38Z")
So for example, if I’m team A and you’re also team A, if I favorite item X, you can see that I favorited that, but you still have the ability to favorite item X yourself? ---
**Author:** ![profechef](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/profechef/32/221_2.png) [@profechef](https://community.glideapps.com/u/profechef)\ **Post date:** [December 26, 2020, 11:45am UTC](https://community.glideapps.com/t/user-specific-column-associated-with-a-profile-column-different-to-email/20307/7 "2020-12-26T11:45:53Z")
No. Once any team member has marked an item that item belongs to the team. It is unnecessary to mark it again Once the student checks a homework as done the famiy can see it’s done. Parents don’t need to do homework 😜 ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [December 26, 2020, 11:55am UTC](https://community.glideapps.com/t/user-specific-column-associated-with-a-profile-column-different-to-email/20307/8 "2020-12-26T11:55:00Z")
Yeah, I was just asking to see if there’s a workaround. Recently Glide enabled the option for us to download user-specific data as well and what I see is they store them on different rows. As of now it seems like your cases can’t be done without using a lot of rows though. Hopefully they will find a way for this to happen. ---
**Author:** ![profechef](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/profechef/32/221_2.png) [@profechef](https://community.glideapps.com/u/profechef)\ **Post date:** [December 26, 2020, 11:55am UTC](https://community.glideapps.com/t/user-specific-column-associated-with-a-profile-column-different-to-email/20307/9 "2020-12-26T11:55:59Z")
Thanks for your time and your thoughts ---
**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:** [December 26, 2020, 11:16pm UTC](https://community.glideapps.com/t/user-specific-column-associated-with-a-profile-column-different-to-email/20307/10 "2020-12-26T23:16:24Z")
I would maybe just have a column in your task sheet and fill it with ‘Team A’ for example? So, one row for each team. Then just filter those rows to only show if the user profile team matches the row’s team column value. In your example, if each team consists of 2 students, then it would cut the rows down to 300 rows. It would reduce more rows if the groups are bigger. ---
**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:** [December 27, 2020, 12:23am UTC](https://community.glideapps.com/t/user-specific-column-associated-with-a-profile-column-different-to-email/20307/11 "2020-12-27T00:23:34Z")
I’m wondering if you could use some trickery with Template columns and Set Row action to ultimately generate a comma separated list of teams per task that have marked it done. Then, use filtering if User Profile \> Team column `is included in` the comma separated list. It’s basically what I’m doing here: > [@speech\_balloon Updated: Group Chat Template v2!](https://community.glideapps.com/t/sneak-peak-group-chat-functionality/20277): > > Now available in the Glide Template Store! Group Chat is a spin on my Messenger Template that, well, allows for group messaging! Features: Efficient: only one row per person and one row per chat Private: row owners per chat to prevent prying eyes, anonymized users default setting, user history per app, chat host can control who is/is not in the group Fun: compound actions to create floating action menus and responsive “add user to chat” functionality Grab the template here: [[G…](https://www.youtube.com/watch?v=TG1gvXbk9W4) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [December 27, 2020, 12:44am UTC](https://community.glideapps.com/t/user-specific-column-associated-with-a-profile-column-different-to-email/20307/12 "2020-12-27T00:44:08Z")
> [@Robert\_Petitto](#): > > Template columns and Set Row action to ultimately generate a comma separated list of teams per task that have marked it done Theoretically it’s completely possible, just that it doesn’t have a way back when you want to revert it to not done. ---
**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:** [December 27, 2020, 1:17am UTC](https://community.glideapps.com/t/user-specific-column-associated-with-a-profile-column-different-to-email/20307/13 "2020-12-27T01:17:00Z")
Right…same is true with my messaging app 😅 ---
**Author:** ![profechef](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/profechef/32/221_2.png) [@profechef](https://community.glideapps.com/u/profechef)\ **Post date:** [December 27, 2020, 8:53am UTC](https://community.glideapps.com/t/user-specific-column-associated-with-a-profile-column-different-to-email/20307/14 "2020-12-27T08:53:58Z")
Thanks. I like your job. That’s a good solution but I need the users can revert an item to no done. May be a student checks a homework as done but his/her parents verify that’s not true or may be a team checks an item as achieved by error. I’m working on a solution based on scripts and submission. When a user marks an item as achieved/ not achieved it will be submitted to an aux sheet. The first script will be triggered each time the aux sheet changes. If it is a new mark it will be logged in another sheet, say “Items achieved”, and by mean of formulas it would be added to a comma separated list of items to each family or team member. If it is a mark deleting the script will search for that item in “Items achieved” and delete its row. The app doesn’t use “Items achived” so it doesn’t matter how many lines it has. The second script will be triggered each night to delete the aux sheet.