Hello!
I have two dropdowns:
Column A [colour] (enum) options are: purple or orange or red
Column B [flavour] (enumlist) which is *required only if A was chosen as either "purple" or "red"
When we come back later to edit the record, I'd like to reset the value of column B [flavour] to null *only if column A [colour] gets changed. Is that possible?
Yes, in the Reset on Edit property you can insert an expression. There is also the [_THISROW_BEFORE] keyword you can use to test the before/after of another column. So in your [flavour] column you could insert an expression like:
[_THISROW_BEFORE].[colour] <> [colour]
Note that "Reset on Edit" simply re-fires the Initial Value expression. If it is empty then the column will get reset to empty.
You can check this thread too: https://www.googlecloudcommunity.com/gc/Tips-Tricks/quot-Reset-on-Edit-quot-when-anything-in-a-speci...
User | Count |
---|---|
40 | |
32 | |
30 | |
17 | |
16 |