How to reduce the dropdown list of a column

lokeshsinghal70

I have graders name as a column in a module. The column datatype is a list (graders name)

I want to reduce the dropdown from that column to only active graders

 

----

I tried creating a subset of the list (graders name) and then using that list as a datatype in the column but that erases all the data related to previous graders that are currently not active

----

Please help!

kavinkumar

HI Lokesh,

 

I have a solution for this!!

 

Step 1: Create a list called "Active" and Create one list item in it as "Active".

Step 2: Create a property in your "Graders Name" list as Active and format it as the above created list. Then select active to the list items that are active.

Step 3: Create a line item in your module and format it as Active list. Then either select Active from the drop down or write a formula in the line item. After you do this now the line item that is formatted as "Graders name" list will have dependent drop down based on the above line item.

 

Now you will be able to see only the Graders name that you have given as active in in the property of the list. I gave 1,3 and 4 as active so i am able to see only those in my drop down.

 

 

Hope this would be helpful to reduce the dropdown list of a column.

 

Let me know if you have any concerns.

 

Thanks,

Kavin.