Filter Enum choices in sequence

[Heino_Matthee]

Hi is there a way to remove Enum choices that are previous possibilities. For example if I have Enum values A,B,C,D,E and the current value of a column is C the only available Enum values in the drop down should only be D,E. Is that possible? It has to do with processing of beer batches for example I don’t want the user to be able to set a batch to “fermenting” status when it has in fact already been filtered and almost ready to package.

[Aleksi]

Yes you can do that with the Suggested values. One way is for example with SWITCH statement like… SWITCH([STATUS],
“B”,LIST(B,C,D,E),
“C”,LIST(C,D,E)
…
LIST(A,B,C,D,E)
)