Hi,
We have a table, as below, used for assigning departments to employees. Additionally, we have an ARM_department metric for managing users’ department access right.
I want users to see only the departments to which they have access in the dropdown list (rather than all departments) to avoid mistakes.
I know that something can be set for Department dimension, but this would affect the entire workspace, right? Is there a way to restrict it only in this table?
Thanks for any advice,
Weining
Best answer by Thu Mai
Hi
You can apply dependent dropdown into your table to filter available Departments for in dropdown menus metric.
Click this link for more detail Create a Dependent Dropdown on a Table | Community (pigment.com)
+10Hi
You can apply dependent dropdown into your table to filter available Departments for in dropdown menus metric.
Click this link for more detail Create a Dependent Dropdown on a Table | Community (pigment.com)
Hi,
Thank you for your response.
As I understand it, this feature allows restricting the dropdown list options based on my Employee dimension. However, I want to restrict the dropdown list options based on the User dimension (which is in the Admin app) to display only relevant departments by users.
The issue is that the User dimension does not exist in this table, so it seems that this feature cannot be used. (Please correct me if I am wrong.)
+10Got you
Yes you have to apply User dimension into the metric to restrict dependent dropdown for Department by User.
You said that you want to “restrict it only in this table”, maybe you can set this up, then choose Dynamic Variable - “Current User” in page options setting, so Pigment will automatically identify the current user interacting with the table
+10Hi
There is another way, by setting up access right by Department for Specific List Properties, but this will be applied for the List Properties all over the app.
Hi
Thank you for sharing the three options!
However, none of them fully meet our needs in the current situation.
Firstly, since the table does not have a User dimension, as I understand, neither Dependant Dropdown, nor Page Option can be used. Secondly, Access Rights would generally be a good choice, but as you said, it would apply to the entire app which we do not want .
So, we will choose Dependant Dropdown but will change the dependant metric from User to Employee. This will also reduce the number of departments in the dropdown list, which meets our expectations.
Thanks again for your helps.
Weining
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
