I have created a calculator in excel which references tables of data within the spreadsheet in the process of computing the desired result.
Therefore my App must sync with the spreadsheet in order to compute the result from the user’s new inputs - there is no performing the calculations solely within the App to avoid having to sync!
How can I modify the App so that each user isn’t inundated with a huge bank of previous users’ saved calculations?
Ideally I would want a user to be presented with a blank form, which they complete and are then delivered the correct result of the calculations from the spreadsheet.
Also, multiple users should be able to use the App simultaneously - I am having trouble working out how to allow this without each user over-writing the other’s data and without the App filling up with previous calculations.