View and edit data in Google Spreadsheets in a form

Question: Is there any way to view and edit data in Google Spreadsheets in a form, like Microsoft Access or OpenOffice Base can do that? It would be perfect if you could cycle through each record, which would be the respective row in Spreadsheets. I've heard that you can include an HTML UI into Spreadsheets via Script. Would that be a possible approach? Background: I'm working on a seniors book in a group for my school and want to enter students data, e.g. name, birthday, favourite movie etc. Because we have over 150 students, it would take ages if only one person has to enter in all the data. I want to create a cloud-based solution in which everyone who is working for the seniors book can enter student data via an user-friendly form which can be accessed via browser. If there is some data missing from a student yet, we could easily edit it later on by using the form. Eventually, we would export all the data as .csv

52.8k 42 42 gold badges 165 165 silver badges 312 312 bronze badges

asked Aug 22, 2015 at 12:36

31 1 1 gold badge 1 1 silver badge 3 3 bronze badges