I’d like to see a new Single Select field type that uses a Formula to filter or create the choices presented in the UI on a per-entity basis.
Such a formula might be as simple as:
[DB_of_all_Possible_Options].Filter(Type = SelectedType)
I’m aware that there’s the question of what to do when a previously selected option becomes “illegal”, but this same problem exists when a Rule or Formula references a deleted field.
For this situation I suggest:
- Don’t automatically change the illegal value, but display the field in a distinctive way to flag the condition.
- Allow the condition of an illegal value to be detected by a Rule, so it can be addressed by automation.