Clear field content when it has been modified

I am creating an embed form in AppSheet and I want the fields to auto-clear when a specific field that has already been filled in is changed.

I have tried to check in the "Reset on Edit" column but it doesn't work, I don't know the reason, maybe it's because I have the free plan?

And I have also tried to perform a new action: > Do this: set the values of some columns in this row.

vicoor_0-1680692172700.png

And I have linked it to the form but it doesn't do any function.

I do not know what else to do.

 

0 2 608
2 REPLIES 2


@vicoor wrote:

I want the fields to auto-clear when a specific field that has already been filled in is changed.


Give this a try.  Set the "Reset on Edit" to an expression like:

AND(
ISNOTBLANK([_THISROW_BEFORE].[specific field]),  
    [_THISROW_BEFORE].[specific field] <> [specific field]
)

[specific field] obviously needs to be changed to the column you need.

"Reset on Edit" simply fires off the Initial Value expression when conditions are met on the EDITING of a row.  If the Initial Value of the columns you wish to clear is empty, then those columns should reset. 

If the Initial Value expression of those columns is NOT empty, then you will need to update them to include logic to set them to empty when the Reset conditions are met.

I try this option and a lot others.

Look, i try do this:

1. Put a option in this form page with one enum field

form1.PNG

2. In second form page, I fill all the fields.

form2.PNG

3. If I prefer go to the first step of the form to select other option:

form3.PNG

4. When I go to the second form page, the fields which I filled, are still filled in:

form4.PNG

So, how I can reset the fields, when the first option of my form have a change?

Thanks!

Top Labels in this Space