Prohibition (block) on simultaneous editing of an existing record by multiple users

English Forum Questions
1

Hello!

There is one important point regarding data integrity on the user side: setting the impossibility of simultaneous editing of the same record by two or more users.

For example, there is an Order record. First, a sales manager opened it in the editing form and began to make some changes to the fields. On the other hand, the finance manager opened the same record and also began to edit the data (even if in different fields). After submitting (saving) the record, only the last user’s information will be saved. Any changes made by the user who submit the record earlier will not be saved. Does my observation make sense, or is this already provided for in NocoBase?

If not, would it be possible to add a feature that would “track” an existing record opened in edit mode and block the ability to edit it (or deactivate the button with a tip “the record is being edited by another user, please wait until they finish and then you will be able to edit it”)?
How technically difficult would it be to implement this? Or is there a “workaround” for this problem (through workflows or conditional rules)? Does anyone have any ideas? Have there been similar problems?

2

Hello, you can use the pre-operation workflow to determine if the update time of the updated data is up-to-date. If it is not up-to-date, remind the user that the data has been changed and ask them to refresh and edit it again.

1 Like
3

Yes, thank you for the tip! This may partially solve the problem, and it can be used as a workaround. However, the point is that this solution may confuse users’ physical work processes. Users will also be forced to re-enter changes if the previous changes were not successfully saved. The only help available will be a notification about the previous change to this record by another user. This is not entirely effective, so we hope that in the future your team will add a restriction on simultaneous editing of records, which will prevent errors and conflicts when editing records at the same time.