Overwriting records

[Emilian_Bem]

Hi!
I have a very serious problem, I noticed that some lines in Google Sheets are getting overwritten. For example, an order has been completed a long time ago, and after a while, the status “pending execution” is assigned to the same line. I have looked through the audit history and noticed that there are edit row operations. In the details of this event, I can see that the status is being given back to “pending execution”.

The problem is that users can only create new tickets, they cannot edit them. I don’t know where to look for the cause of this problem.

I also did tests and if I filled out the form but did not save it yet and copied the link and then pasted it in a new browser window, all responses are saved with the generated ID. And if I saved the first form, and then in the second form with the same ID, I changed the data, Appsheet allows me to save it and thus overwrites the data. I suspect that application users may copy the link to the form and this is where the problems begin.

I would very much ask for guidance, because this problem affects the clients and their billing.

UPDATE:
I have investigated the matter carefully and concluded that the problem was in a very specific case. If the user creates a form in the browser and fills it in, but before saving, he copies the link to the completed form and pastes it in a new window, the same ID is assigned, which is not stored in the link but in the browser’s cache. And if the user fills in the originally opened form and then goes to the tab with the copied link and changes the values in the form, he will overwrite the old data. Is it possible to somehow prevent this?

[Lynn]

Hi @Emilian_Bem
Im not sure I follow what is happening, but which is your key column and how is it being created?

[Emilian_Bem]

Hi @Lynn! Thanks for reply
I have a column called “ID” with the following properties:
Type: text
Require: true
Initial value: UNIQUEID()
Key: True
Editable: False

[Lynn]

@Emilian_Bem
A row with the same Key will overwrite the previous one. I don’t know what your users are doing but maybe you could set your key column to not show. I don’t have any other suggestions sorry. Someone else may be able to help further.

[Emilian_Bem]

Lynn:

A row with the same Key will overwrite the previous one. I don’t know what your users are doing but maybe you could set your key column to not show. I don’t have any other suggestions sorry. Someone else may be able to help further.

Thank you for your time anyway! I hid the ID but that didn’t change anything: /. It seems to me that somehow the id is stored in the link when the form is opened. Unfortunately, I do not have enough knowledge to clearly determine if this is perhaps a starting point.

[Ravshan]

I also have a similar problem. Some users use mobile and desktop version. Sometimes they forget to sync and re-change the order status to "approved". At that time, the order itself may be already paid. I don't know how to force the user to sync before data changes. (disabling Delayed sync is not suitable for me since I have large data and users will panic if they have to sync after each change)

[Kmark3]

I also have a similar problem. I have users filling out a log and if they try to post multiple entries back to back while the syncing is still going on, the new posts overwrite the previous posts. For my key, I have a column called No. with this formula pasted in data validity under the initial value. "(MAX(PostPaint Log[No.]) + 1)"