Skip to main content
Solved

Selective Dropdown

  • September 11, 2025
  • 7 replies
  • 145 views

Forum|alt.badge.img+5

Hi,

I have a dimension formatted property in a transaction list. I want to restrict the items in the dropdowns based on users. Applying data access rules achieves this only partially it seems. While the users cannot see the items that are not assigned to them once they make the selection from the dropdown (the input simply disappears), while making the selection they are able to see all available items in the list. How can I restrict this?

Best answer by Luiza

Hello ​@tjain02 ,

Thank you for your question!

There is no built-in way to restrict the dropdown options in transaction lists based on user access rights at the selection stage. This is a known limitation.
But you ca use the workaround provided by ​@Chahat (Thanks for you help!). You can restrict dropdown options dynamically through dependent dropdowns, but these are based on relationships between properties, not user access.
I invite you to submit an idea in the Ideas section of the Pigment Community for future product consideration.
I remain available if you have any questions.

Best regards,

7 replies

Chahat
Master Helper
Forum|alt.badge.img+14
  • Master Helper
  • September 12, 2025

Hi ​@tjain02 ,

Can you try to apply the access rights rule to that “dimension” list,
and then the users shall be able to view only those items in the dropdown to which they have access to.


Forum|alt.badge.img+5
  • Author
  • Author
  • September 12, 2025

@Chahat , I have already tried this but it does not seem to work. I can still see all items in the dropdown. I am trying to apply this rule on the community dimension. This dimension is being used in the capex input list as a property. Can you confirm if I have applied the right rule?
 

 


Chahat
Master Helper
Forum|alt.badge.img+14
  • Master Helper
  • September 12, 2025

Can you try to use the following?
Apply Read & Write accesses to ‘Specific List Properties’ .

Also, have you tried using the Impersonate feature if you’re able to view all the options or only the applicable options/items in the dropdown?


Chahat
Master Helper
Forum|alt.badge.img+14
  • Master Helper
  • September 12, 2025

Hi ​@tjain02 ,

Since you need to show the selective dropdown, hence, you’d need to apply the access rights to the dimension list directly.
Please use this:
Choose List : Community
and select all the properties of the community list in this rule.


This approach should work for you, let me know if you need any help.​​​​​


Chahat
Master Helper
Forum|alt.badge.img+14
  • Master Helper
  • September 12, 2025

By following the above rule configuration i.e. “Specific List Properties”, and then choose list “Community” and apply configuration to all properties of the “Community” list


Luiza
Employee
Forum|alt.badge.img+1
  • Employee
  • Answer
  • September 16, 2025

Hello ​@tjain02 ,

Thank you for your question!

There is no built-in way to restrict the dropdown options in transaction lists based on user access rights at the selection stage. This is a known limitation.
But you ca use the workaround provided by ​@Chahat (Thanks for you help!). You can restrict dropdown options dynamically through dependent dropdowns, but these are based on relationships between properties, not user access.
I invite you to submit an idea in the Ideas section of the Pigment Community for future product consideration.
I remain available if you have any questions.

Best regards,


Forum|alt.badge.img+5
  • Author
  • Author
  • September 18, 2025

Hi ​@Luiza , Thanks for your response! I did try to restrict access using the relationship between properties but that does not fit the use case I am working on. So, I’ll be sure to submit an idea regarding this.