I'm working on moving from an awful Excel document to a Google Sheet where employees can type in notes on a "Form" and have it record the data as a "record".

enter image description here____________ enter image description here

When the user opens the document, I would like the datepicker validated cell A1 to default to today and the cell B2 to populate with the note corresponding to that date on the "Records" sheet. Easy enough.

The tough part is I'd like to be able to have the user change data and save it to the records sheet.

Is this outside of Google Sheets? I was looking at Google Forms but that just seems awful to try and customize and work with.


1 Answer 1


Short answer

To edit the form responses you need the edit response URL. As a form owner, the usual way to get them is by using a script.


Google Forms has a setting to allow respondents to edit their answers but it's not recorded anywhere. The good news is that by using Google Apps Script you could list all the edit response links next to the responses. Please take a look to the related question linked in the references section.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.