Auto replace value without a Bot

[JhunePol]

Hello appsheet community,

I encountered a bug? regarding to the auto replace value.

All Rows from January up to May was already replaced.

I have a column name [Status] and this is a type of enum.

All Rows has been replaced on May 20 in different time.

I don't have a BOT to replace the [Status].

I have only Reset Edit Expression AND(ISNOTBLANK([Start Running Time]), ISBLANK([End Running Time])) but I know this is to reset only by changing a value on Start Running Time and End Running Time.

Please help me because my other apps is same thing happen.

Is there a solution to comeback to the original value?

Thank you in advance!

[a_aleinikov]

hi @JhunePol 

what you’re describing sounds like the Reset on edit behavior is triggering across all rows unintentionally — even without a bot

your expression:
AND(ISNOTBLANK([Start Running Time]), ISBLANK([End Running Time]))

means that any edit to a row (even unrelated) where Start Running Time has a value and End Running Time is blank will reset the [Status] value

if you bulk edited rows (or triggered a sync/edit from another app), this reset might have applied to all matching rows

what to do:

1. remove or adjust the reset expression so it doesn't apply during updates you don’t expect

2. restore data from version history (in Google Sheets: File > Version history) to recover original values

3. if you use forms or automation that edit many rows, make sure the [Status] field is not resetting unexpectedly

you might want to add an extra condition like _THISROW_BEFORE.[Status] = "" to prevent overwriting existing values

[JhunePol]

Hi @a_aleinikov 

Thank you for your response, By the way I asked for help in google appsheet support last week, and they said that remove or adjust my reset expression. In my case, I just removed my expression so there wouldn't be any problems.