Using a Google Spreadsheet like a database
October 9, 2014 Leave a comment
There are many cool and useful things you can do with Google Apps for Work like collaborative editing of documents, inexpensive storage and so on. But add frevvo to the mix, and you can take it to the next level and solve real business problems.
One example is dynamic web forms and approval workflows that treat the underlying spreadsheet as a database. The applications are endless – Sales Orders, Employee Records, Student Information and so on.
Check out the video below. It’s not even 2m long and shows you an example from Education. Teachers, administrators or parents can securely access student information stored in a Google Spreadsheet without actually having access to it. They’ll only see information relevant to their particular need, edits are controlled (e.g. data is validated, rules can perform computations etc.) and the user experience is so much nicer.