I have a list dropdown for our users to select from. However, I am wondering the best way to "hide" certain list items. I want to ensure users don't have the ability to see or select an incorrect item, however I can't delete these list items since they have data tied to them from past years.
Attached is a photo for reference of the items I would like to "hide".
When I tried this idea of creating an "Active Drivers" subset, it deleted the data where there was a nonactive driver previously.
In the photo attached, Driver Selection uses the new active drivers subset and Driver Result is what it was previously. Since "DONT USE Trailing..." list item is not included in the subset, it clears the data.
I am hoping for a solution that keeps the data on the backend, but would limit the list items available to the user from the UX to select.
Correct. If I'm understanding your second question correctly, the module with the data does retain the entire list and the line item used for the dropdown is formatted on the subset of active members.
I think I may have found a solution along the lines of what you were alluding to -- I created a new line item used for the dropdown that utilizes just the active subset members. In the formula, I set it equal to the line item that included all list members. Then I deleted the formula, so the value was saved, but it could be user edited. Now when a user goes to select an item from the dropdown, they can see the past incorrect value but cannot select it again from the dropdown items.
I've attached a photo of a warning I get on the model building side, but hopefully this is okay?
When enabling selective access on the list, it warns me that "Users will be denied access to any item in this list until explicitly granted read or write permission." Does this imply that past data in the module will be cleared?