# Roles and row owners - CRM App **URL:** \ **Category:** Ask for Help\ **Created:** [March 30, 2021, 5:39am UTC](https://community.glideapps.com/t/roles-and-row-owners-crm-app/24907 "2021-03-30T05:39:48Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Mozzie](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mozzie/32/17519_2.png) [@Mozzie](https://community.glideapps.com/u/Mozzie)\ **Post date:** [March 30, 2021, 5:39am UTC](https://community.glideapps.com/t/roles-and-row-owners-crm-app/24907/1 "2021-03-30T05:39:48Z")
Hi I’ve created a B2B CRM / Pricebook app for my employer. I’m a mobile rep and created this to solve a problem I see often as a rep. Everything is functioning correctly for a single user but what I need to do is have row owners and roles assigned but I’m struggling to get my head around it on multiple sheets. CRM Managers - National - See everything State - Offices with managers which see the state data they’re responsible for only (Deals, contacts and activities). Reps - Manage territories within the states with there own customers, contacts and deals/activities eg North Side / Southside or Machines / consumables. Some of the accounts are shared amongst the reps. Pricebook All managers and reps see everything as it’s all the same Calculator - Sheet to work out margin/markup etc which isn’t saved but cleared once worked out. This is functioning fine but how do I set it up so we don’t see each others workings? I’ve created teams columns which has become an array column within the user sheet but presumably this needs to happen with all the sheets that are specific - Companies, contacts, deals, activities?. I’m not sure on the best way to set it up.I’m on the home stretch and nearly ready to present it to management but this is bugging me. Can I get some help please? thanks in advance ---
**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\ **Post date:** [March 30, 2021, 5:51am UTC](https://community.glideapps.com/t/roles-and-row-owners-crm-app/24907/2 "2021-03-30T05:51:31Z")
This is helpful > **[Glide • Quickstart](https://www.glideapps.com/docs)** > > Publish your first app in under 5 minutes > **[Glide • Quickstart](https://www.glideapps.com/docs)** > > Publish your first app in under 5 minutes Also have you thought about using ‘user specific columns’? [![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/a/2a0d8a6edf9ca9a2c288a5057e0e590528f32bd3.jpeg "User Specific Columns | Glide Tutorial") ](https://www.youtube.com/watch?v=PK5eovZGne0) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/2/723ae81c485f77647dcf6d678e3573b92e74a86a.jpeg) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/0/70e01232ec38f33a60722b9f9025737826d7b69c.jpeg) > **[Glide • Quickstart](https://www.glideapps.com/docs)** > > Publish your first app in under 5 minutes ---
**Author:** ![Mozzie](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mozzie/32/17519_2.png) [@Mozzie](https://community.glideapps.com/u/Mozzie)\ **Post date:** [March 30, 2021, 6:15am UTC](https://community.glideapps.com/t/roles-and-row-owners-crm-app/24907/3 "2021-03-30T06:15:52Z")
Hi. I’m not sure how it will be used with the CRM parts as multiple users will need to access contacts, companies, deals and activities. I’ve looked for user specific columns for the calculator but when trying to edit the columns it’s greyed out. (see attached). It’s only when i create a new column it shows up. Is this a bug or are there other conditions? cheers ![calc](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/6/862cb717ad40b752aeff517a31bf93b5409373c5.png) ---
**Author:** ![Michael\_hien](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/michael_hien/32/18864_2.png) [@Michael\_hien](https://community.glideapps.com/u/Michael_hien)\ **Post date:** [March 30, 2021, 6:21am UTC](https://community.glideapps.com/t/roles-and-row-owners-crm-app/24907/4 "2021-03-30T06:21:10Z")
You could try different ideas from setting the tab/component visibility to users’ roles as you have set. Or in my app, I don’t name the roles, I do the sequencing, for example, I am 0, who should be able to see and do everything, the bigger number, the less parts they see ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/e/de2d866a73aeb9499d96040560a22be85ea8d604.png) You can also set up a View column to decide who could see which. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/2/22fd570661820f3d31e2ed03f295b815ce7d8872.png) ---
**Author:** ![Mozzie](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mozzie/32/17519_2.png) [@Mozzie](https://community.glideapps.com/u/Mozzie)\ **Post date:** [April 4, 2021, 3:49am UTC](https://community.glideapps.com/t/roles-and-row-owners-crm-app/24907/5 "2021-04-04T03:49:38Z")
Hi and thank you. I’ve got it solved and working well. Just needed to give it a break for 24 hours and then voila, all the advice made sense. Thank you