Two users add records simultaneously, problem with google sheet

[ilprofbianco]

If two users add records simultaneously, some cells of the row in google sheet translate to the right.
So the record is badly recorded and is not read by the other app’s views.
How can I solve? Thank you.
PS: the records have ID = CONCATENATE ([Date], “:”, [Time], “:”, [Name Surname])

[Aleksi]

Hi, do you mean that values are not saved in correct field? If that’s the case, please check that the user has the latest app version in his/her device.

[ilprofbianco]

Thanks Aleksi, so the error is not due to simultaneity with another user. I have now activated “Sync on start” to remedy the problem.
Also, today I found that some users’ adds were synced up to two hours later. Could this be due to the fact that I had set “Delayed sync”?

[Steve]

ilprofbianco:

some cells of the row in google sheet translate to the right

What does this mean?

ilprofbianco:

the record is badly recorded

How so?

ilprofbianco:

is not read by the other app’s views

What does this mean?

ilprofbianco:

Also, today I found that some users’ adds were synced up to two hours later. Could this be due to the fact that I had set “Delayed sync”?

I recommend these settings:

[ilprofbianco]

Aleksi:

values are not saved in correct field

Steve, I meant that values were not saved in correct field.
Now I have activated the three options you suggest.
I have also enabled “Server caching” even if only 3 tables are read-only, three others allow user adds, is that correct or should I deselect Server caching?

[Steve]

ilprofbianco:

Steve, I meant that values were not saved in correct field.

This typically happens when you reorder the columns in the spreadsheet but don’t also update the app, or a user using an older version of the app that isn’t aware of the new column order submits data updates.

In general, it’s best to: (1) avoid reordering columns in the spreadsheet; (2) avoid deleting columns from the spreadsheet; and (3) add new spreadsheet columns to the right of existing columns.

If you must make changes to the existing spreadsheet structure (removing or reordering columns), best to ensure that all users manually sync to get the reconfigured app before they make any data changes. How to accomplish this can be a challenge.

[Steve]

ilprofbianco:

I have also enabled “Server caching” even if only 3 tables are read-only, three others allow user adds, is that correct or should I deselect Server caching?

Unless your data set is large and you’re experiencing performance problems that you have reason to believe will benefit from server caching, I recommend leaving it off.

[ilprofbianco]

Ok, thanks Steve!