Google spreadsheet (Automatic Randomly Deleted Cell)

[JhunePol]

Hello, 

This past day, I encountered a randomly deleted cell. I created bot for my app last week. My bot is Automatic delete the child when the parent is deleted. Please see my bot.

Can someone help me how to prevent this randomly auto deleted cell.

BTW this is the example of deleted cell in my google spreadsheet.

Is my bot wrong?

Thank you! 

[AleksiAlkio]

Your Bot should delete the whole row, not a value in a cell. It sounds something else is doing that. Do you have any other Bots or actions that could explain this behavior? Have you verified from the Sheets cell history when this has happened and what the Audit history shows with the same timestamp?

[JhunePol]

Hi @AleksiAlkio 

Well my other bot is the creation of pdf file. I have 2 bot only.

And yes i got a history when the value is deleted. I was bothered because i need to show edit history to get back the details of that specific cell. This happened to me 2 times. Lastweek and today.

[AleksiAlkio]

If you check the cell history from Goolge Sheets..
#1 - When was the value added?
#2 - When was it cleared?
#3 - When was the Bot triggered?

[JhunePol]

Hi @AleksiAlkio 

#1

#2

#3 The bot will trigger depends on the user. When my user delete the parent, automatically delete also the the child. I didn't set a schedule for deleting.

[AleksiAlkio]

Is the timestamp kind of a same as when the Bot was triggered? Like within a  few seconds?  You said in the beginning that this is happening randomly. What do you mean by this? Is it happening with the same column but sometimes it happens and sometimes it doesn't? Or.. is it happening with different columns? Or something else? 

[JhunePol]

Hi @AleksiAlkio  I don't have a timestamp in my table and Yes, it happens in different column. Actually I encountered this issue in 3 different apps. Last week, Yesterday and earlier morning but not on the same apps. I have not yet encountered in same apps.

Now, I disabled my 1 bot which is the Deleted of the parent and child. I will observe this.

[AleksiAlkio]

E.g. in your case, you could check from the Audit history at 12/19 2:29 PM what happened at the same time. If the Bot is doing this, you should be able to see the Bot triggered at the same time (almost). Please remember the timestamp you are seeing from the Google Sheet is showing the time per your own timezone whereas the Audit history shows time per UTC+0.

[JhunePol]

Okay, let me observe first cuz i disabled my bot. Hoping that this issue will never happen again. Thanks @AleksiAlkio.

[TeeSee1]

Maybe you should simply depend on the delete behavior of "is a Part of" relationship instead of a bot?

[Steve]

Similar complaint: bot populates field in google sheet but then deletes it

[JhunePol]

Thanks steve!