hide a drop down option based on the user /Role

Hi Ghowsiya,

What you are looking for can be messy and complicated when you are trying to do it with multiple fields and formulas, especially for reporting in the future. The way I usually tackle this is I make a table of all my options and then relate it to the table where the decision is made. The advantage here is since the options are coming from another table you can go into the options on the other table and set up permissions for each role so that the dropdown will dynamically show or hide options based on role permissions.

For example if I had a Discount table cause I wanted discount options including 10%, 20%, 30%, 40%, and 50% I could have a record for each and then have 3 checkbox fields for my 3 roles. Sales Rep, Team Leader, and Manager and then I just check those checkboxes for each role that can use that discount. That way I could set up permissions so that everyone can use the 10 or 20, only team leaders and managers get the checkbox checked for 30 and 40 and finally only managers get access to 50% all using typical table permissions. Then I just set up permissions on that table for each role that they can only see records where their permission checkbox is checked. Then it is all one field you can report against and the discount table can be hidden so all your end users don't even see or worry about it. 

The checkbox method is one suggestion but you can also get far more specific with your permissions if you have more rules and more situations. It is also helpful cause then when you need to expand the options or remove an option in the future you just add a record or remove those checkboxes to hide an option going forward. I hope this suggestion is helpful.

------------------------------
Evan Martinez
Community Marketing Manager
Quick Base
------------------------------