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,
Solved! Go to Solution.
Thanks Survutt. I will try it.
Unfortunately, the linked article doesn't address my question.
Let me get back to you.
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
Thanks Survutt. I will try it.
Unfortunately, the linked article doesn't address my question.
Let me get back to you.
Hi @WalterWong
The linked article is about how the initial value attribute works.
@Suvrutt_Gurjar Thanks! Your solution works!
Excellent. Thank you for the update.
User | Count |
---|---|
43 | |
25 | |
23 | |
14 | |
13 |