GoogleSheets shows me questions that were deleted long before the connection was created | Community
Skip to main content
Answered

GoogleSheets shows me questions that were deleted long before the connection was created

  • December 29, 2021
  • 2 replies
  • 196 views
L

I have a form that had 177 questions, I deleted 129, and left only 48.
Now, when I see my forms in the workspace, it always shows me the number of questions is equal to 177.
This doesn't worry me that the form info is incorrect. But the real problem is that when I link the form to a Google Sheets, it displays all 177, (that is to say even the ones that have been deleted)


How can I stop seeing these deleted questions? Knowing that the connection of the form to google sheets was created only after deleting the questions not desired?
Is there any way to do this without having to recreate the form from scratch and do all the work a second time?


Thanks

Best answer by Liz

Hi @LiForm Wow! Sounds like quite the form cleanup ha!

First, have you published the changes to your form? If not, you’ll want to do that step first. 

Then, if you already had the form connected to Google Sheets when you made the change, those questions will still appear because the integration is one-way. This means that Google Sheets won’t know if you made a change to your form. 

You’ll want to completely delete the integration and then re-integrate it to have the correct questions appear. Though, if you already collected data for all these questions, then the questions will still appear in the Google Sheet. 

To avoid this, it may be better to duplicate the form and reconnect to the duplicate. 

View original
Gabriel
S
2 people like this
  • Gabriel
    Gabriel
  • S
    Shujah

2 replies

Liz
Community Team
Forum|alt.badge.img+5
  • Liz
  • Tech Community Advocate
  • 15012 replies
  • Answer
  • December 29, 2021

Hi @LiForm Wow! Sounds like quite the form cleanup ha!

First, have you published the changes to your form? If not, you’ll want to do that step first. 

Then, if you already had the form connected to Google Sheets when you made the change, those questions will still appear because the integration is one-way. This means that Google Sheets won’t know if you made a change to your form. 

You’ll want to completely delete the integration and then re-integrate it to have the correct questions appear. Though, if you already collected data for all these questions, then the questions will still appear in the Google Sheet. 

To avoid this, it may be better to duplicate the form and reconnect to the duplicate. 

Life is a series of awkward moments separated by snacks.
john.desborough
Gabi Amaral
2 people like this
  • john.desborough
    john.desborough
  • Gabi Amaral
    Gabi Amaral
Gabi Amaral
Ex–Typefomer
Forum|alt.badge.img+5
  • Gabi Amaral
  • Ex–Typefomer
  • 1777 replies
  • January 4, 2022

Hey @LiForm! How are you doing today? Just checking if you were able to follow my friend's Liz suggestions to fix your form? Let us know if any of her solutions helped you! :wink:

Everyone you meet is fighting a battle you know nothing about. Be kind. Always. =)

Reply


Still need help?

Don't be shy and ask the community.

Ask your question here!
Community T&Cs