Skip to content

Instantly share code, notes, and snippets.

@hfaerber

hfaerber/Deleting-and-Saving-Old-Responses-from-Google-Forms.md

Created September 30, 2021 21:48
Show Gist options
  • Save hfaerber/1edd420ff82521899586094fae34b630 to your computer and use it in GitHub Desktop.
Save hfaerber/1edd420ff82521899586094fae34b630 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Deleting-and-Saving-Old-Responses-from-Google-Forms.md

How to use a new tab to capture incoming responses on a google form while saving the old responses in a tab.

  • Open the google form

    • Click Responses

    • Click the ants-on-a-log menu (in the response sheet area, not the very top right corner of the page)

      • Click Delete All Responses. Click Ok on the pop up.

    • Click the ants-on-a-log menu AGAIN

      • Click Select Response Destination
      • Choose Select Existing Spreadsheet option. Click Select
        • Doubleclick the form's corresponding Responses spreadsheet (may need to search)
        • Wait for it to process

    • Click the spreadsheet icon to the left of the ants-on-a-log menu to open the spreadsheet

      • Notice new tab has been created. Rename the tabs as needed (ideally with cohort)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment