Restricting selections in enum columns? I ha...

(Dialect Junk) #1

Restricting selections in enum columns?

I have 2 enum columns:

Column #1: “Asset Status” with options for “In Service” and “Out Of Service”. Column #2: “Work Order Status” with options for “Started” and “Completed.”

If “Out Of Service” is selected in column 1, I want to restrict column 2’s option to “Started,” only.

Is this possible with enum column? Any other strategies?

Thanks, all.

(Aleksi Alkio) #2

You can use something like… IF([Col#1]=“Out Of Service”,{Started},{Started,Completed})

(Dialect Junk) #3

@Aleksi_Alkio Aleksi, I entered the expression and it partially works as desired - when “Out Of Service” is selected as my asset status, the “Work Order Status” defaults to “Started”. Perfect.

However, if “In Service” is selected, nothing appears under “Work Order Status”; it’s totally blank and my options have disappeared. I’m stumped…

Thanks for your help!