In our case, we have an application that has both financial data and salary data. All users should see the financial data, but only users that manage employees should see the salary data. The financial and salary data are in 2 different tables. Access to employee data is based on the user's department in the section access.
To allow all users access to the application and see the finance data, I created a dummy department and concatenated all users the section access table with the dummy department. This allows all users access to the application, but they cannot see salary data unless they have a legitimate department in the section access table.
I hide the salary sheet by adding the following expression to the "Show Sheet" conditional expression.
If (count(employee) > 0,1,0)
Only users that have a legitimate department in the section access table will have a count greater than 0.
Thank you. I thought about this approach as well. But the caveat here is, I still need to add all the users in Section Access table and there are thousands. I can easily identify users who should have access to both Sheet1 and Sheet2 but there will be thousands who should have access just to Sheet1 but not Sheet2
The only other way to do this would be to split the application into two different apps, one for the Section Access folks and the other that would not have Section Access at all.
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.