Dropdown list depends on another field user

Question

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------------------------------

chayceduncan · Answer

Yes, you can create a table for your 'Categories' and then use conditional dropdowns to achieve this.&nbsp;
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:&nbsp;

Role&nbsp; &nbsp; Option
PM&nbsp; &nbsp; &nbsp; &nbsp;A
PM&nbsp; &nbsp; &nbsp; &nbsp;B
PM&nbsp; &nbsp; &nbsp; &nbsp;C
PE&nbsp; &nbsp; &nbsp; &nbsp;C
PE&nbsp; &nbsp; &nbsp; &nbsp; D
PE&nbsp; &nbsp; &nbsp; &nbsp; 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.&nbsp;------------------------------Chayce Duncan------------------------------

Forum Discussion

Dropdown list depends on another field user