My app is a housing navigation guide. It lists different types of affordable, subsidized and market place rental Locations. The major drive to put this together was that folks have a tough time finding housing that suits them. I put together a robust search using a form, and a results spreadsheet. I used app scripts to match the search criteria with the housing Data, but I just ran into the issue where only one person can search at a time, since the results sheet gets reupdated.
My question is, is this something that can be fixed with the the local/private tables? It doesn't seem likely since I would have to run my script on the table. Is it possible to alter the private tables? or copy a table to a private table immediately?
I have also thought up the idea of making a new sheet each time the search is run, and clearing them at the end of the day.
My app is supposed to be a public resource so it's really frustrating about all of the security checks there are in place!
LinkedIn
Twitter
