Hello,
I wonder if one of you has a good solution on how to disable a value from an enum (so canno't be selected anymore) BUT not remove it (so old records and reports are still valids) ?
For instance, a enum field with 4 values
- A
- B
- C
- D
Let's suppose that A what an option that was valid for old record but no more for new ones. Is there a proper way to remove this option when you create or update a record, but that will keep this old values for searches, reports etc.
Currently, without dev (that is an option) we
- has a enum field : A, B, C, D
- has another field enum field :version : V1, V2, V3 ...
- the first enum field as a visibilty dependency according to the second one
- the second one is set a default value for any new record so it will trigger the correct visibilty ; so any new version, you need to set up the default value correctly
- of course we need an initial setup for all records
So it's a bit anoying and not really
any better idea or suggestion is welcome.
Regards,
Fred