How to reset the value of a field, if the value has changed show if

Hello

How to reset the value of a field, if first it was visible and filled, then the field was hidden, after hiding it should be cleared, because when saving the record it will also include this information that should not

appsheet.gif

Hi, I speak spanish.

Me puedes explicar un poco mejor lo que intentas preguntar?, es algo confuso

Gracias

Si lguien selecciona algun mes tiene que llenar los campos “RePorcentaje, ReFijo” segun sea el caso como en la imagen, yo he llenado ambos solo como ejemplo, alli todo bien

Sin embargo si selecciona un mes, luego digita valores en los campos como la imagen, luego cambia a matricula u otro valor que nosea un mes porque se equivocó, esos campos ya no se muestran pero siempre quedan llenos al momento de guardar

he intentado usar un Reset on edit, pero sin éxito aún

Espero me hayas entendido

What’s the problem with just ignoring these values and hiding these columns based on the option the user finally selects?

The problem is that it also saves in the table

Then you will have two or more columns, with values that should not go there, only one

As marked in the picture

These values will have no effect if you don’t use/show them, so they can just be ignored. If for some reason you absolutely don’t want these values to be there, then you can manage their removal afterwards with automation or a Form Save action.