0

I have wrongly submitted a google form to two different groups of people. So I have created a copy of the form after generating the spreadsheet. However, in the responses tab of the copied form, I get zero responses.

Can I duplicate a form retaining both responses and summary tables & charts, and even allowing people to continue to submit one of both of them and update existing summary tables & charts?

  • @Tedinoz You should turn your comments to an answer so it can be accepted or upvoted. Not many people read comments and you also help reduce the unanswered list – marikamitsos Nov 16 at 4:11
0

This is not a built-in feature but you can use Google Apps Script with some limitations copy the responses from the original form to the copy.

One of the limitations is that timestamp will not be the same.

From https://developers.google.com/apps-script

Many Google apps, one platform in the cloud

Increase the power of your favorite Google apps — like Calendar, Docs, Drive, Gmail, Sheets, and Slides.
Apps Script lets you do more with Google, all on a modern JavaScript platform in the cloud. Build solutions to boost your collaboration and productivity.

| improve this answer | |
0

Q1:"duplicate a form retaining both responses and summary tables & charts".

Yes.
Refer Importing data into a Google Forms response sheet - your question is arguably a duplicate.

I've just used this to do a proof-of-concept (also, the 1st answer provides a great explanation of the relationship between form and spreadsheet). As @Rubén notes, the downside is that you can't edit the timestamp.

Q2:"submit one of both of them and update existing summary tables & charts".

No and yes.
TTBOMK each form requires its own destination sheet (that is, one sheet cannot be used by two forms), so I would allow each to submit to its respective response sheet.

Then I'd create a third sheet that "merges" the data from each destination sheet and use that merged data for summary tables/charts.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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