[oddlyaromatic]

Google Apps Script is great for tools like this: I have used some at work for a while to manage gig listings for a musician... just the tiny bit of automation happening at midnight let's them add shows via a Google form and forget all about them, knowing that geocoding, and removing of old shows, and other funny business, will all happen without them needing to maintain it. BUT if they ever do need to modify a show, they are dealing with a google sheet, which they understand.

[paulcole]

Yep that’s pretty much exactly why they wanted it built around a spreadsheet. Before they had an app somebody built and never maintained. It was buggy and the data was more or less inaccessible.

Now with the spreadsheet they not only have access to the data when/if they want it, it’s also super easy to roll back if something goes haywire.