Unless I'm missing something, this only provides a way to display data from a database. But users cannot write to the database via the Google Sheet, and it thus doesn't solve the problem...
Oh god you're right, I just re-read the article and realized what they're doing now.
It didn't even occur to me that anyone would use Excel as the database. Holy hell. Nevermind.
Still, it shouldn't be hard to convert Excel to an SQL database. Then you dump to CSV, and use ImportHTML to have a spreadsheet be your source of information.
It didn't even occur to me that anyone would use Excel as the database. Holy hell. Nevermind.
Still, it shouldn't be hard to convert Excel to an SQL database. Then you dump to CSV, and use ImportHTML to have a spreadsheet be your source of information.