What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
My Google Spreadsheets doesn't collect some form dataAsked by itskrug on January 14, 2014 at 05:53 AM
Hello, I met with a bug in Google Spreadsheets integration.
Here is my form - http://form.jotformeu.com/form/33641560294353
Here is my spreadsheet - https://docs.google.com/spreadsheet/ccc?key=0Ank_xZIY46kudDlBVnNEVHloR3dJRzhwOTJlRWJ3RGc&usp=sharing
When I reintegrate form with Google Spreadsheet, new spreadsheet catches all the data... But it isn't quite convenient for me...
Thanks in advance!
Thank you for contacting us.
Unfortunately, the only way to correct the error (field mapping, mismatch and form changes could cause this) is to re-integrate with a new spreadsheet.
The form will transfer all previsous submissions to the new integrated spreadsheet.
How about putting a link on the original Google Spreadsheet directing the spreadsheet users to the new spreadsheet location?
Please let us know if this helps.
Thanks for answering!
I did reintegration already, I now this way, but it isn't quite comfortable...
Can you explain your sentence "How about putting a link on the original Google Spreadsheet directing the spreadsheet users to the new spreadsheet location?" in other words... sorry, but I don't understand it clearly...
Thank you for your response.
My statement presumed that you have a number of people accessing the spreadsheet, which is why you do not want to use another instead.
If that is the case, you could redirect all who visit the spreadsheet to the one you are currently re-integrated to.
Perhaps you could clarify what you want to accomplish with the original spreadsheet, and we can provide some additional guidance.
Ok, thx for answer!
As I understood you there is no way to resolve this issue except to re-integrate form each time I need form data and send new link to the new spreadsheet to my colleague. Is it right?
Fields between your form and the Spreadsheet are mapped with intricate accuracy - even a change in your form might result in errors on your integrated spreadsheet.
Since Google Spreadsheet is a third-party product, having strict operational requirements for integration is the only way for everyone to 'play nice'
Does this clarify things?
Please let us know.
Thx, I understood you. Everything is clear now!