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".
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.