For the purposes of our app, we need to have complete ownership and editing access to the spreadsheet that is attached to our app. How can we solve this based on the fact that we are working from an app template with an already-attached google spreadsheet, which we do not have access to?
This also poses a problem when we want to delete pre-existing data… it cannot be deleted, only replaced. How can we delete information in cells (again, this ties back to us not being able to access the spreadsheet which the app is tied to-- we can make additions, but we cannot take away the data that was already there when we first began building from this template).
If it helps-- the template is called “Time Sheet”, it’s by Robert Petito.