How do I, on an input form, “reset” or change selection in an Enum dropdown based on user input in another form field?
I am building a Custom Pricing app that allows a client to override normal pricing structure in special circumstances.
The client can set the custom price to cover an entire customer,
a product or a specific product for a single customer.
The custom price can be a discount % or simply a different price than normal.
I have a Price Coverage Enum column, values are = “Customer Only”,
“Product Only”, “Customer+Product”.
The Price Type Enum column has values = “Discount”, “Custom Price”.
For these two columns, I want my Custom Price input form to help the client in three ways: 1)
If the “Customer Only” value is selected, I want the Price Type to default to “Discount” and not be allowed to change (not editable). 2)
If “Customer Only” is chosen but then changed,
I want Price Type selection to “clear” and become editable again. 3)
If value is switched TO “Customer Only”
then I expect same result as 1)
To make this short, I’ll just say I have tried several implementations in Initial Value,
App Formula and Editable If expressions but can’t seem to get this to work correctly for all use cases.
This seems like a common need.
Is this feature possible and if so, how do I go about implementing it?
Please ask your questions for more details if needed.