I am developing an application with offline functionality for my company which digitalize a form with about 200 columns. I am stuck on two of the requirements.They are-
1) To create an incremental unique key, concatenated with location code.As the backend is in sharepoint list and considering the application to work in both online and offline scenario, can anyone suggest the best way to achieve this task. Eg. Lets assume application has two location i.e. "A" and "B", so first record for "A" should be "A1" and first record for "B" should be "B1" and so on.
2) The user wants to save some of the records in collection which they want to edit a couple of time before making the final submission. For this case, Do I need to create new screens to show records to the user before they can edit it considering there can be upto 200 columns which needs to be edited ? Can anyone suggest the best way on how to fulfill this requirements ?