Is there any way to view and edit data in Google Sheets in a form, like MS Access or OpenOffice Base can do that? It would be perfect if we could cycle through each record, which would be the respective row in Spreadsheets.
The background is that we're storing personnel-type records in Sheets. We'd like to see (and edit) all the fields in a record in one screen, instead of stretched across multiple screens. The "Forms" program seems to be solely intended for collecting information, like a questionnaire, which isn't what we want. Ideally, we'd have some formatting controls so that "first name" could be placed right up against "last name", for example.
Does anyone know of an Add-on, etc, which can provide this functionality?