and @Simon_Robinson . Here’s my project, as far as I can lay it out right now. I want a separate app for each Responsibility covered by my current app, i.e an app for: -staff management -contact management -client intake and setup -client allocation and relationship/pipeline management -client progress notes -accounts recievable -accounts payable and payroll -incident and hazard management -task and project management -policy and compliance management -performance dashboard
Each app would need read only access, for example, to our Person table, which contains every client, staff, and contact relating to the business.
Question 1: Would it be wise then, for only the Contact Management app to have Update, Delete and Create access to that table?
The whole goal here is to minimise sync time.
Question 2: Would it be wise to start using different Google sheet files, instead of 50 plus seperate tabs on a single Google Sheet file?
Question 3: What are the general principles to minimise sync time? E.g. running smaller apps is one. Using Read only tables when possible is another one. What about number of different files vs having a number of different tabs in the same file?
Question 4: If I have multiple different apps, referencing the same backend table, is it important that only one of those apps is able to modify that table and the rest need to be read only? Might this be essential to avoid data corruption across multiple users?
Question 5: My thought on how to get this project
happening is to keep my current app in operation, but build these small apps on the side, and when they are tested, deprecate the part of the current app with that Responsibility. Can you see any pitfalls in this approach, based on work you have done in a similar context?