Nov 4, 2023
I want to pre populate a google form with the previous response.
I want the form to show the previous response, so that they do not have to re-answer every question, just the ones that they wish to change.
Visually, the simplest approach is to allow users to edit their responses, unfortunately this overwrites the original response in my Google Sheet; and I want to track the changes in answers over time.
Any ideas?
Details
Informational notification.
This question is locked and replying has been disabled.
Community content may not be verified or up-to-date. Learn more.
Last edited Nov 4, 2023
Nov 4, 2023
Hi Ian BBB,
Welcome to the Google Docs Editors help community.
This can be done by creating "pre-filled" links and sending updated links to the users after each tie they submit a new response.
See here for basic mothod of getting pre-filled links.
To have these made automatically, and sent to the users will require formulas in a linked Sheets file to create the links, then apps script to create and send the email containing the links.
To help with your apps script development, see this list of resources I have compiled.....
Documentation for learning Google Apps Script:
- Apps Script Introduction (website with French & English versions available)
- Google Apps Script Community (Google Group)
- Google Apps Script overview (Google Developers)
- Google Developers Guide to Extending Google Sheets (Google Developers)
- Google Developers Guide to Extending Google Docs (Google Developers)
- Fundamentals of Apps Script with Google Sheets codelab
- Beginner's Guide to Apps Script (Ben Collins)
- Guide about the New Apps Script Editor (Ben Collins)
- Introduction To Google Apps Script (Ben Collins, free course)
- Clean Code JavaScript (Ryan McDermott)
- javascript.info
- Mozilla Developer Network
Youtube channels for (mostly Google Sheets) video tutorials:
- Code With Curt - YouTube
- Laurence Svekis - YouTube
- Learn Google Sheets & Excel Spreadsheets - YouTube
- Sheets Ninja - YouTube
- Spencer Farris - YouTube
- Yagisanatode -Scott- - YouTube
Other sites and groups to get help with more technical aspects of Apps Script:
If you are lucky, you may get someone to volunteer to write all the code for you, but it would be best if you learned how to do it yourself so that you know how to maintain the code when changes are required.
Alternatively, you can hire a Google Apps Script consultant to work on your project.
See this: Register of Consultants.
Finally, in case you're interested, here's some FREE Google Apps Script samples that you may find useful for your projects. Just follow the guided instructions to complete the setup of the included files:
- Automatically create draft email replies to feedback submitted through Google Forms
- Simultaneously upload and organize files in Google Drive using Google Forms
- Automatically create and send PDFs with information from a Google Sheets spreadsheet
- Generate Google Slides Employee Certificate from data in Google Sheets
- Automatically create agenda documents in Google Docs and attach them to your Google Calendar meetings
- Automatically create Calendar events (and email attendees) from an event sign-up Form
Original Poster Ian BBB marked this as an answer
All Replies
Hi Ian BBB,
Welcome to the Google Docs Editors help community.
This can be done by creating "pre-filled" links and sending updated links to the users after each tie they submit a new response.
See here for basic mothod of getting pre-filled links.
To have these made automatically, and sent to the users will require formulas in a linked Sheets file to create the links, then apps script to create and send the email containing the links.
To help with your apps script development, see this list of resources I have compiled.....
Documentation for learning Google Apps Script:
- Apps Script Introduction (website with French & English versions available)
- Google Apps Script Community (Google Group)
- Google Apps Script overview (Google Developers)
- Google Developers Guide to Extending Google Sheets (Google Developers)
- Google Developers Guide to Extending Google Docs (Google Developers)
- Fundamentals of Apps Script with Google Sheets codelab
- Beginner's Guide to Apps Script (Ben Collins)
- Guide about the New Apps Script Editor (Ben Collins)
- Introduction To Google Apps Script (Ben Collins, free course)
- Clean Code JavaScript (Ryan McDermott)
- javascript.info
- Mozilla Developer Network
Youtube channels for (mostly Google Sheets) video tutorials:
- Code With Curt - YouTube
- Laurence Svekis - YouTube
- Learn Google Sheets & Excel Spreadsheets - YouTube
- Sheets Ninja - YouTube
- Spencer Farris - YouTube
- Yagisanatode -Scott- - YouTube
Other sites and groups to get help with more technical aspects of Apps Script:
If you are lucky, you may get someone to volunteer to write all the code for you, but it would be best if you learned how to do it yourself so that you know how to maintain the code when changes are required.
Alternatively, you can hire a Google Apps Script consultant to work on your project.
See this: Register of Consultants.
Finally, in case you're interested, here's some FREE Google Apps Script samples that you may find useful for your projects. Just follow the guided instructions to complete the setup of the included files:
- Automatically create draft email replies to feedback submitted through Google Forms
- Simultaneously upload and organize files in Google Drive using Google Forms
- Automatically create and send PDFs with information from a Google Sheets spreadsheet
- Generate Google Slides Employee Certificate from data in Google Sheets
- Automatically create agenda documents in Google Docs and attach them to your Google Calendar meetings
- Automatically create Calendar events (and email attendees) from an event sign-up Form
Original Poster Ian BBB marked this as an answer