RESET ON EDIT when a Quick Column change value

[Fernando_Lopez1]

I’m noticing that the RESET ON EDIT doesn’t work when a Quick Column change value.
Is this an expected behaviour?

[Steve]

Can you explain what specific behavior you expect that isn’t occurring?

[Fernando_Lopez1]

Hi @Steve
I have a [Control_Column] that change when a [Option_Column] is edited (using RESET_ON_EDIT, and INITIAL_VALUE formula)
The [Option_Column] is changed by the user on a Detail_View, and is setted as a QUICK_EDIT_COLUMN
So when the user change the value of the [Option_Column] the RESET_ON_EDIT doesn’t update the [Control_Column]

Thanks

[dauvo]

I understand (I believe) your situation because I've been looking for a similar solution and believe I've found it.
Of course years later, hopefully this helps someone else.
In the dependent drop down explanation here, They use an example for the relationship between the dropdowns written as: IN( [_THIS], SELECT(Regions[Country], [_THISROW].[Lead Region] = [Region])) 

This is said to be the process appsheet follows to connect the dropdowns automatically when using the validity statement Regions[Country]

If you wrap that type of validy statement with a not() expression like so:
not(IN( [_THIS], SELECT(Regions[Country], [_THISROW].[Lead Region] = [Region])) ) and place it within the reset on edit if? for the same column, it changes once the validity doesn't match the dependent dropdown selection. 

I am using a quick edit dropdown filter and it's working beautifully!

[MMMiles]

I have not seen this mentioned anywhere else, but this is a game-changing tip for Quick Edit forms.

[MiguelPilo]

@Fernando_Lopez1 You has formulated the Reset on edit? or just was click selected?

If it have formula, just remove it and try again. You must see the correct behaivor.

If you need to conditioned the Reset on edit? whit a formula just share it and I'll try to help you.

[MiguelPilo]

Here an example of the behavior. Look how the column [Fecha de Inicio] is recalculated to TODAY()+1 when a quick edit is made.