New "Dynamic Single Select" Field Type

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:

  1. Don’t automatically change the illegal value, but display the field in a distinctive way to flag the condition.
  2. Allow the condition of an illegal value to be detected by a Rule, so it can be addressed by automation.

Related:

1 Like