Get submitted data (Google Form), Google Sheet (Responses), edit and add as new record.

Radcliffe Bromfield

unread,

Feb 4, 2021, 11:56:37 AM2/4/21

to Google Apps Script Community

So I created a Google Form and after I click Submit the responses are recorded on a Google Sheet, GREAT. Now I have columns and rows of data and would like another Google Form to Retrieve the said information from the Google Sheet (Responses) so I can edit that Response(s) and either overwrite the existing one or create a new record after clicking submit.

cbmserv...@gmail.com

unread,

Feb 4, 2021, 12:01:15 PM2/4/21

to google-apps-sc...@googlegroups.com

Hi Radcliffe,

Is this just to modify the original form submission or to create a different form all together?

If it is just to modify the original form data, you can create a script that will generate a URL for you to click on which would allow you back into the form to modify the data. Note this would just resubmit against the same row and not generate a new record.

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/4793a7eb-a44b-41a4-8f0c-2fedd7682725o%40googlegroups.com.

Radcliffe Bromfield

unread,

Feb 4, 2021, 12:53:41 PM2/4/21

to Google Apps Script Community

Good Day Sir George,

Your suggestion is noted as I want to edit the entry via the form and the entry is replace with the new info and not create a record. But I also want to do the same and option is there to create a new record or update existing one.....

Thanks for Replying..