I have created a web form that allows users to enter some details and click a submit button.
This then links to a google sheets script so that the data is added to the bottom of a live google sheet, along the row.
I am trying to allow the user to edit a submission after its been sent (and the website / window closed)
I have added an allowance in the google script so that one of the fields is a c2id value. This is created at random when the user loads the form. My thought being that if I do a save state at the same time as the submission is created, I just have to work out a way to load that state back to the user. Ideally I'd like to email the user a link they can click to edit their submission.
Does this sound like its possible? I can't think of a simple / strait forward way of doing it.
Worse case I'll made a load button where you can type in the 6 digit c2id to load your state. (Users can do more than one submission