- smithkimAsked on April 07, 2013 at 04:32 PM
I have seen other posts relating to this in the past but I dont think it has been resolved.
I have integrated my jotform with google spreadsheets and the integration worked well but when I enter new test data into the form and click submit, it does not appear in the spreadsheet. It appears on the submissions page of jotforms and i get an email to say that the submission has been received but its not automaticall populating the spreadsheet.
This was previously working so what is wrong?
- JotForm SupportjonathanAnswered on April 07, 2013 at 05:23 PM
I was able to reproduced the same issue when I tested a cloned of your form https://www.jotform.com/22973654693366
BUT I also found a temporary solution for it.
The integratation seems to be broken when the fields on your form starts with numbers
I changes this labels to not begin with number...
and the integration was fixed.
Please test this form http://www.jotformpro.com/form/30966365485971
This the shared integrated google spreadsheet
Please try applying the solution on your end. Test if it works also.
- smithkimAnswered on April 07, 2013 at 05:51 PMThanks for that. It does seem to work better but the spreadsheet only seems to update when I refresh the page. However, this might be because I'm using my ipad to test it, I'll try it with the laptop tomorrow and let you know if its still an issue.Kim
- JotForm SupportjonathanAnswered on April 07, 2013 at 06:18 PM
Thank you Kim. Do update us again later of the results.
- smithkimAnswered on April 09, 2013 at 12:46 PMThis was working perfectly until I added some more fields to my form. It has now created another submissions spreadsheet by the same name. Since I have already some complex calculations to the original submissions spreadsheets, I would like the submissions to still go to the original one rather than the second it has created. How can I do this?
- JotForm SupportWelvinAnswered on April 09, 2013 at 01:41 PM
Note that adding more fields will most likely break the integration. It does not automatically add the fields to the spreadsheet result. I know that it will need another time, but I'd suggest you re-create the integration to correct and include the new fields.
Anyway, a report is already created. We'll let you know if updates will be made about this.
- smithkimAnswered on April 09, 2013 at 02:01 PMWhen you say re-create the integration, that would mean starting all over again with the submissions data, ie recreating my added field in the spreadsheet.
- JotForm SupportWelvinAnswered on April 09, 2013 at 02:53 PM
Yes, you will have to start from scratch again. Including the custom Calculations or any formulas you have on the spreadsheet.
Also note, to never modify the first row which contains the field labels because that will also break the integration.
I'd also like to suggest to create another spreadsheet and add/create the calculations or formulas there and just copy/paste the results from the Google Spreadsheet Integration. This way to avoid breaking the spreadsheet result.
- JotForm SupportliyamAnswered on July 21, 2013 at 10:07 PM
We apologize on missing to update you on this matter, smithkim. We've made some changes just recently that handles the problems reported on Google Spreadsheets integration.
Please do let us know if you continue to experience problems with any of your forms with integrations.