# Can this be done via User Specific Columns? **URL:** \ **Category:** Ask for Help\ **Created:** [October 15, 2020, 5:45pm UTC](https://community.glideapps.com/t/can-this-be-done-via-user-specific-columns/17185 "2020-10-15T17:45:39Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Food2Soil](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/food2soil/32/659_2.png) [@Food2Soil](https://community.glideapps.com/u/Food2Soil)\ **Post date:** [October 15, 2020, 5:45pm UTC](https://community.glideapps.com/t/can-this-be-done-via-user-specific-columns/17185/1 "2020-10-15T17:45:39Z")
I am trying to build a timesheet app. I have a tasklist sheet with a list of projects and subprojects. There are a total of 14 rows on the tasklist sheet. Each team member needs to be approved to work on tasks. Team names are listed in columns in the same sheet. So imagine an array of tasks in rows and team names in columns. An ‘X’ is placed in that cell if that team member has approval to work on that task. I now want to have a choice component that only offers the tasks that a team member has approval to work on. Can I accomplish this by utilizing the user specific column feature? Thankyou for all your help. ---
**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:** [October 15, 2020, 10:09pm UTC](https://community.glideapps.com/t/can-this-be-done-via-user-specific-columns/17185/2 "2020-10-15T22:09:51Z")
How many teams do you have? I think a better structure is that you have as many columns as you have teams (or team members) then use choice components to assign tasks to them rather than using user-specific columns here. User-specific columns are more about letting each user interact with the same column in their own way. ---
**Author:** ![Food2Soil](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/food2soil/32/659_2.png) [@Food2Soil](https://community.glideapps.com/u/Food2Soil)\ **Post date:** [October 15, 2020, 10:14pm UTC](https://community.glideapps.com/t/can-this-be-done-via-user-specific-columns/17185/3 "2020-10-15T22:14:29Z")
Thankyou. So if I create one column for Sarah’s tasks and a second column for Jane’s tasks then how do I make sure that the choice component pulls the correct column values based on the user signed in? ---
**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:** [October 15, 2020, 11:19pm UTC](https://community.glideapps.com/t/can-this-be-done-via-user-specific-columns/17185/4 "2020-10-15T23:19:29Z")
I mean you should structure it like this. **Task** | **User Allowed 1** | **User Allowed 2** Then for each user allowed column, you have a choice component that sources from your list of emails. So now you have an array of columns that stores only the users that are allowed to do each task. Next, you can have a template column that stores the signed-in user’s email. Make a relation matching that template column back to the array of emails. If the relation is not empty they can do the task. ---
**Author:** ![Food2Soil](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/food2soil/32/659_2.png) [@Food2Soil](https://community.glideapps.com/u/Food2Soil)\ **Post date:** [October 16, 2020, 2:22am UTC](https://community.glideapps.com/t/can-this-be-done-via-user-specific-columns/17185/5 "2020-10-16T02:22:01Z")
Brilliant! Works like a charm. Thankyou so much for walking me through each step. Much appreciated! ---
**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:** [October 16, 2020, 2:32am UTC](https://community.glideapps.com/t/can-this-be-done-via-user-specific-columns/17185/6 "2020-10-16T02:32:40Z")
Nice to have been able to help! Do let me know if you need more assistance 😄 ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [September 24, 2025, 12:46am UTC](https://community.glideapps.com/t/can-this-be-done-via-user-specific-columns/17185/7 "2025-09-24T00:46:14Z")