Morning!
I have a rather complex problem to solve, any advice/help greatly appreciated! I’ve never used Section Access at anything other than a basic level.
I need to restrict users as to what data they can see at various levels within an application.
- I need to restrict users to only see data for their department (this is easy using publisher to distribute the app for only their department – no problem)
- Some users cannot see their entire departments data, only data for their sub department or for the team that they line manage (various levels of restriction here and this is what I’m struggling with)
- Sheet restriction for certain users within the application
There (probably) going to be 5 levels of users
- Executive (see all departments – possibly with data at an aggregated level)
- Department head (restricted to their department)
- Department senior managers (restricted to their staff in their department)
- Line managers (restricted to their staff in their department)
- Other
It’s a pretty simple data set in that the data is all in one table, with everything at row level. I just don’t know how to approach reducing the dashboards/app within a department depending on the users level of access.
Any help/advice greatly appreciated!
