We use picklists a lot they provide consistency for reporting and reduce clicks. However, we have some piclists that have constantly changing values. For example, on our custom demo request object we have a picklist to select the demo unit being requested. We get frequent requests from the business to deactivate values (taking a unit out of rotation for maintenance or repairs, or retiring it), renaming units, adding new units, etc.
We do releases every 2 weeks, so that can mean that sometimes their changes have to wait longer than they would like, and its also just a lot of piddly maintenance for us.
Is there a way to give a group of users a way to maintain the picklist values? I know I can give them delegated administration rights to a custom object, but that gives them rights to everything and we really want to restrict it to just the picklist values for particular fields. We have multiple business units sharing the same org, so there are a lot of record types, etc and it just seems risky to give product managers or other business users admin rights - too easy for them to inadvertently change something and cause a domino effect. Our org is also almost 20 yrs old, so there's a lot of complexity and historical development that adds to the risk.
Without having to write and maintain a bunch of code, has anyone found a solution to a problem like this? An app exchange app or some custom declarative development you've done to tackle a similar problem?
Personally I might go with (no pun intended) a Picklist Field on the Stooge Custom Object to indicate the status of the value.
This will allow you to have more nuanced filtering than a True/False checkbox
