- SNCAsked on February 20, 2014 at 09:39 AM
There seems to be some issues with spreadsheet integration. When I set up the integration, all data is submitted just fine. When a new submittion is recived the data is incomplete and I think is because of the way the field names are being transfered.
Submission Date - when set up it sends data that looks like 02/20/2014 09:19:44 (contains leading 0)
When it is newly added from form it looks like this: 2/20/2014 9:26:46
I have three other fields that are having issue, the data is not being enterd at all. (See screen shot)
Is there a way to correct this? Other than reintergrating the form every time that is..
- EliezerNAnswered on February 20, 2014 at 10:48 AM
We apologize for the inconveniences this may have cuased.
I cloned your form and integrated it to do some tests. And I can confirm that I was able to reproduce the issue upon testing the integration, the data of the three fields with date as label were missing:
Then, I removed the integration, changed the label of the three checkbox questions, reintegrated the the form with the spreadsheet and finally sent some submissions and it worked perfectly at this time:
So, all you need to do is to modify/change the labels so that they cannot be read as Date-time in the spread sheet, you can change them to something like this:
Then you can reintegrate your form with the spreadsheet and it will work correctly.
Please inform us if you need further assistance.
- SNCAnswered on February 20, 2014 at 11:16 AM
Thank you for the quick responce. I was also able to rename the columns in the spreadsheet to match the name of the fields on the form and that worked too.
- JotForm SupportWelvinAnswered on February 20, 2014 at 12:29 PM
It's our pleasure! Am I right to assumed that the issue is resolved? Please do let us know if you need any further assistance.