I am getting ready to give my app to other users not in my organisation to test it out. The app has 37 tables with some data pre loaded. How do I give a new user access to the app but point it at a new googlesheet that only they are able to edit other than me. I can see how to copy the app with a new set of data but I want all users to be using the same version that I will modify and update with new versions over time.
I don’t want to give them a private table as I want to have the ability to modify the columns/sort their data in bulk for them by going into their sheet. I’m expecting the app to be used by up to hundreds not thousands of users so was planning on having a file with a googlesheet for each organisation in it. At the moment I have lots of versions of my app that are pointing at the same googlesheet - I’m looking for the opposite - everyone using one version but with their own sheet.