In the past month or so, I’ve made a couple of apps that take data that have been submitted via a Google form and then stored in a Google spreadsheet and display them.
I’m particularly pleased with the capability that AppSheet provides to display apps in browsers, instead of on a smartphone or tablet.
In a university lecture context, this allows me to ask the students to use their smartphones to respond to a few questions and then display the results on a screen using AppSheet almost instantaneously.
I’d like to share these as sample apps because I think many educators and people who make presentations to groups might find them to be useful, but there’s one problem.
When an app I’ve made in this way is copied, the Google spreadsheet is copied with it but not the form.
Of course, the form can be rebuilt, but that strikes me as a lot of extra work and something might go wrong in the process.
When one copies a Google spreadsheet that is attached to a form in the Spreadsheet interface, the form normally gets copied with it.
However, on AppSheet, it doesn’t work that way yet.
Could AppSheet do something to make the spreadsheet AND the form get copied together?