I am building a workload overview report for a group of teachers. The data shows that the majority of teachers are only doing teaching activities. However, there are other teachers who take up on other projects that do not belong to teaching. My goal here is to make two different pages that either show less information concerning only teaching activities and a more detailed page that shows also the other projects.
I am also using row-level security so that teachers will be only able to see data that is associated with their username. However, the trouble is that I want to create a condition that will lead a teacher to the appropriate page that they need to see either only teaching activities or full detail. The reason for this is that the second page has too much information that is not usefull for teachers who do not do extra projects. I tried using a "transition page" that asks them the question whether they have other projects aside from teaching, but user testing has proven that teachers find this very confusing and hard to understand.
Therefore my question now is, how can I set a conditional formatting for the page navigation of a button that it will filter the data whether a teacher has any other roles or just teaching, and it then will lead them to the correct page - either only teaching overview or full detail. I am sure that my data can be manipulated to fit this condition, however I cannot find the practical solution.
Are there any suggestions on how I can solve this problem?
Thanks
