I want to make a spreadsheet in Google Sheets with a user friendly editable front end and a back end with an arbitrary number of rows containing the data to be displayed. There should be a dropdown on the front end that allows me to select which row (or a new row) in the back end is displayed in the rest of the front end fields; and any edits on the front end should be saved to the back end.
I know vlookup can be used to show data from the backend on the frontend, but I'm pretty sure it's not going to send edits back to the backend. Is there a way to accomplish this using Google Sheets, either alone or with other Google web apps?