Pre-select Enum value

[WalterWong]

Hi

[OrderType] is Text column type.

[Options] is Enum column type.

[Options] - Suggested Value formula is SomeTable [ List_Of_3_Enum_Values ]

Desired Outcome whenever [OrderType] changes value

When Order Type = A, show all 3 enum_values but set (pre-select) enum_value_1

When Order Type = B, show all 3 enum_values but set (pre-select) enum_value_2

When Order Type = C, show all 3 enum_values but set (pre-select) enum_value_3

Thanks,

[Suvrutt_Gurjar]

AppSheet calls the preselected value" initial Value". However as the name suggests, once selected and record saved, the  value does not preselect again on record edit unless 'Reset on edit" is also checked to yes or has a suitable expression to reset  initial values  on record edits..

In the "Initial Value" of column [Options], please have an expression something like 

SWITCH([Order Type], "A", "enum_value_1", "B", "enum_value_2", "C" , "enum_value_3", "")

Please take a look at the article below on "Initial Values"

https://help.appsheet.com/en/articles/961507-app-formulas-and-initial-values

[WalterWong · Accepted solution]

Thanks Survutt. I will try it.

Unfortunately, the linked article doesn't address my question.

Let me get back to you.

[Suvrutt_Gurjar]

Hi @WalterWong 

The linked article is about how the initial value  attribute works.

[WalterWong]

@Suvrutt_Gurjar Thanks! Your solution works! 

[Suvrutt_Gurjar]

Excellent. Thank you for the update.