require / Reset on edit

[coldcoffee]

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?

[WillowMobileSys]

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.

[JuneCorpuz]

You can check this thread too: https://www.googlecloudcommunity.com/gc/Tips-Tricks/quot-Reset-on-Edit-quot-when-anything-in-a-speci...