Exact matches only
Search in title
Search in content
Search in posts
Search in pages

Submissions are not properly displayed in Google Docs (Drive). What to do?

This usually happens when you have edited your spreadsheet after you have integrated your form with Google Docs (Drive) and received submissions. Once you have received your first submission, a new spreadsheet is created in your Google Drive account with the name of your form. If you edit the spreadsheet, new entries will no longer be properly displayed in Google Docs.

To fix this, export your submissions in CSV, copy its content and paste it in new spreadsheet in Google Drive.

In the future, if you want to edit your spreadsheet, you’ll need to follow these steps:

1. First, change the names in the column header (label) and make a submission.
2. Reorder the columns as you want and submit the form again. This will prevent the integration from delivering submissions that are not properly displayed in your Google spreadsheet.

Related documentation and FAQ:
Fixing CSV Export in Microsoft Excel
SIGN UP FOR FREE

6 comments

  1. I have linked my registration form to google drive. I want to display the google spreadsheet on my wix website. However, although I need all the information on my registration form, I only want to display a limited amount of that information on my website. can I create a duplicate sheet with limited information, or will that sever the conncections and prevent auto filling?

    1. Hi Judd!

      You may use the option to hide certain columns on your Google spreadsheet. The changes will be applied automatically on the web page where the spreadsheet is embedded. Just remember to enable the option Automatically republish when changes are made. For more information, you may contact Google support.

      As for your 123FormBuilder account, you may contact our support specialists at support@123formbuilder.com whenever you require assistance.

      Thanks!

  2. hi! I had problem with conection 123form and google docs. It worked for a year but now stopped updating. i disconected and conected them again. I deleted and posted the form on site again. I deleted google doc which stopped updaiting and I used 123form. New doc apeared but without any information inside at all! Why did it happen? How else I can fix the problem? I have anouther 123form in the same site – and it work as should.

    1. Hello!

      The new doc is not populated immediately after each submission. It takes about 1 to 5 minutes. Have you checked your doc later to see if the submission has been passed? If you encounter further problems with the integration, please contact our Support Team at support@123formbuilder.com, via our contact form or on Live Chat (9:00 AM – 5:00 PM GMT+2). They will help ASAP.

      Thanks!

Leave a Reply

Your email address will not be published. Required fields are marked *

Frequently Asked Questions

Here is a list of the most frequently asked questions. For more FAQs, please browse through the  FAQs page.

Is this service free?
Yes, we offer a free form builder service. Just sign up to the Basic plan and you are all set. This plan is forever free, but you are limited with a few features only, such as 5 forms per account, 100 submissions per month and you have to keep the backlink to 123FormBuilder on your forms. Check out our features matrix for more information.
How many forms can I create?
It depends on the service plan you are on. Higher service plans enable more features, including more web forms for your account. If you need more forms, go to the My Account section of your account and click the upgrade button. To create an unlimited number of forms, either upgrade to the Platinum service plan or higher. Consult our features matrix for more information.
How can I publish my forms?
You can publish your forms in many ways, by using their direct URL or HTML link, embedding them with a JavaScript code, Inline HTML or iFrame, using the Facebook app or the WordPress plugin, using popups, the Blogger code snippet and many more. Once you have created and customized your form, go to the Publish section to complete your work. Read more in our documentation.
How do I change my form design?
You can change the design of your form in the Themes section, which is located in your form settings. We offer a set of more than 30 predefined form themes for your forms, but you can also create your own from scratch. You can customize the submit button, the logo and more. To apply your own stylesheets, all forms come with a custom CSS editor.

Can't find what you're looking for?