Hi, I’m Hasan. I’m just learning to use appsheet in developing a purchasing application.
I have an issue when there is more than 1 user inputting data at the same time, so that the data overlaps. For example, user A inputs with purchase code 1, then at the same time user B inputs with purchase code 2. The only data recorded is data A.
Is there a solution? thanks
A bit confused about your issue.
Two people entering data with different codes but only one record is recorded? Or there should be one record but two records (duplicates) are recorded?
Edited
You also might want to share the table definition.
the problem is that one of the data was overwritten because the data was entered at the same time by 2 different users
If you mean the same row was edited at the same time by more than one person, then, yes, this is expected.
Unless you implement a business rule that no more than one person edit the same row AppSheet, which is a distributed system, does not provide any mechanism to prevent this. (This has been already discussed multiple times, here for example)
The reason your data is being overwritten is probably because the same KEY is being used in both records.
Can you share which column in your table is your KEY and how is it computed when a record is added?
Thank you sir for the advice, I have tried several times and it turns out this is one of the problems.
This reference opened my mind to be able to develop business rules and systems to be more stable.