Data View Restriction

anilkrag1984

Sample report.png

Hello Team

I have requirement wherein I want to restrict my Sales rep to view each others data, I did checked the solution posted by Mr Mike on 2018. But that still doesn't solve the problem as the users can still see the each others data after removing the filter.

For example as shown in the attachement Sales Agent shouldn't view each others data.

But that solution was provided 2 years back do we have any workaround for this?

Thanks

Anil Raghav

Ramzi K

@anilkrag77641 Anil, the challenge with any type of data "isolation" like you are trying to do is that you ultimately need to give the user access to the entire underlying sheet which means they can see everyone's information.

Your best bet is to use a premium app called Dynamic View.

I hope this helps.

Ramzi

Andrée Starå

Hi @anilkrag77641

I'd recommend creating one sheet for each sales rep and by using cross-sheet formulas, collect the data from the main sheet to the individual sheets, or you could (if you have access) use the new WorkApps feature.

What do you think?

Which option do you prefer?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!