I have a table that has many columns that depict multi stages of a process, with header, section and data capturing columns.
While doing up the app, it comes to my notice that, there is a possibility that users can be working on different process (column area) on the same row concurrently.
May I know if this will be a problem with data loss or corruption when multiple users update the same row but different columns?
The reason why I do not separate the process into different sheet is because there are many duplication of the same process as batches of the same production. This makes data entry work load increase by many folds.