Skip to main content
Question

Dropdown list depends on another field user

  • March 27, 2024
  • 0 replies
  • 103 views

Forum|alt.badge.img+1

Hi,

I have 2 fields: 'Author role' (user) and 'Category' (dropdown list: A, B, C, D, E).

Is there a way to show just part of dropdown list, depend on the user on 'Author role' field?

For example:

If the user will be PM he will see only the values A,B,C in 'Category' dropdown

and If the user will be PE he will see only the values (C,D,E).



------------------------------
Thanks in advance,
Oriel Dotan
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+9
  • Registered
  • March 27, 2024

Yes, you can create a table for your 'Categories' and then use conditional dropdowns to achieve this. 

In your categories table you would enter them in such a way that you associate the 'Author Role' to the dropdown options so you data looks something like this: 

Role    Option

PM       A

PM       B

PM       C

PE       C

PE        D

PE        E

Then your conditional dropdown is based on matching the author role in the table where the dropdown lives to the role in your Categories table. 



------------------------------
Chayce Duncan
------------------------------