How to reduce the dropdown list of a column

Options
lokeshsinghal70
lokeshsinghal70 Member, ALL USERS, Community Member Posts: 5 Occasional Contributor
in Planning & Modeling

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!

Tagged:

Comments

  • lokeshsinghal70
    lokeshsinghal70 Member, ALL USERS, Community Member Posts: 5 Occasional Contributor

    I tried that but it still removes the Data related to previous graders.

    Its an input field (Graders input into this field)

  • RHerz
    RHerz Member, ALL USERS, Master Anaplanner - Employee, Employee, Certified Model Builder Posts: 4 Occasional Contributor

    It sounds like you may be combining 2 conflicting requirements (preserving historical data points, collecting new data points) into a single solution.  Try creating 2 modules, one for each purpose:

     - Module A is used for data entry with your list subset of active graders as a line item.  Create an action to move entered data to Module B.

    - Module B is your data repository that contains historical data and is not restricted by your subset.

     

Categories