# How to update respective column by each department? **URL:** \ **Category:** Ask for Help\ **Created:** [July 16, 2022, 3:02am UTC](https://community.glideapps.com/t/how-to-update-respective-column-by-each-department/44584 "2022-07-16T03:02:42Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![edbs\_India](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/edbs_india/32/4055_2.png) [@edbs\_India](https://community.glideapps.com/u/edbs_India)\ **Post date:** [July 16, 2022, 3:02am UTC](https://community.glideapps.com/t/how-to-update-respective-column-by-each-department/44584/1 "2022-07-16T03:02:43Z")
I have a sheet which consists of Customer name, phone, address etc. The sales department create new opportunities with basic information and then technical department fills in other columns. I want technical department to be able to update only the columns related to their work. Example Sales Dept enter/update the following 1. Date of Enquiry 2. Customer Name & Address 3. Requirement Details 4. Probability of winning the deal 5. Required on or before 6. Lead source … etc. Technical Department evaluates the opportunity and update columns 1. Choose the assigned opportunity from the list. 2. Update columns like a. Material Value b. Labour Value c. Outsourcing cost d. Date of Delivery …etc Sales department again based on the technical inputs prepare quotes and update the quote details. a. Quote Amount b. Quote Date etc. This time sales will be able to update only these columns. Please help to implement this workflow. Regards, Jay ---
**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:** [July 16, 2022, 4:01am UTC](https://community.glideapps.com/t/how-to-update-respective-column-by-each-department/44584/2 "2022-07-16T04:01:11Z")
You can do all this by using conditional visibility on your edit form input components. ---
**Author:** ![edbs\_India](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/edbs_india/32/4055_2.png) [@edbs\_India](https://community.glideapps.com/u/edbs_India)\ **Post date:** [July 16, 2022, 4:44am UTC](https://community.glideapps.com/t/how-to-update-respective-column-by-each-department/44584/3 "2022-07-16T04:44:48Z")
Thanks for your quick response. I have seen that option, but trying to understand whether any slice option available as in Appsheet. Anyways thanks. ---
**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:** [July 16, 2022, 5:09am UTC](https://community.glideapps.com/t/how-to-update-respective-column-by-each-department/44584/4 "2022-07-16T05:09:39Z")
There is a [Slice Array](https://www.glideapps.com/plugins/slice-array) plugin column. What do you need that for? ---
**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:** [July 16, 2022, 11:28pm UTC](https://community.glideapps.com/t/how-to-update-respective-column-by-each-department/44584/5 "2022-07-16T23:28:13Z")
If what you refer to as “Slices” is in the video below. [![]( " - YouTube") ](https://www.youtube.com/watch?v=5sNidpQBFIc) Then it’s a bit different. I believe the Slice here works for filtering rows from a table, while what you want is conditionally show/hide entry for columns in the same row. It should work like this: > [@edbs\_India](#): > > Sales Dept enter/update the following > > 1. Date of Enquiry > 2. Customer Name & Address > 3. Requirement Details > 4. Probability of winning the deal > 5. Required on or before > 6. Lead source … etc. Sales Dept add a new row through a form. > [@edbs\_India](#): > > Technical Department evaluates the opportunity and update columns > > 1. Choose the assigned opportunity from the list. > 2. Update columns like > a. Material Value > b. Labour Value > c. Outsourcing cost > d. Date of Delivery …etc If the signed-in user’s “department” is Technical then when they open the edit form, they can only see the columns above. > [@edbs\_India](#): > > Sales department again based on the technical inputs prepare quotes and update the quote details. > > a. Quote Amount > b. Quote Date etc. When sales dept go into a row’s details view, they can only see the columns above when they go into the edit screen. You might choose to allow the technical dept to continue editing info or not after sales has input the quote amount, I’m leaning towards a no. ---
**Author:** ![edbs\_India](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/edbs_india/32/4055_2.png) [@edbs\_India](https://community.glideapps.com/u/edbs_India)\ **Post date:** [July 17, 2022, 3:09am UTC](https://community.glideapps.com/t/how-to-update-respective-column-by-each-department/44584/6 "2022-07-17T03:09:37Z")
Thanks for your guidance and support. Understood how glideapps works. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [July 18, 2022, 3:10am UTC](https://community.glideapps.com/t/how-to-update-respective-column-by-each-department/44584/7 "2022-07-18T03:10:34Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.