- abbdhananiAsked on September 19, 2014 at 09:20 AM
When I intrgrate to a google spreadsheet not all the fields come through.
The Matrix question doesnt come through, although it does in the notification email.
- JotForm SupportdavidAnswered on September 19, 2014 at 11:57 AM
Please add some titles to your Matrix fields and then re-integrate the jotform with the Google Spreadsheet service. I think that you will need to use different titles to be able to accept the data on the spreadsheet. For example:
It should fix the problem. The columns in the spreadsheet are based off the field titles. Without a title the widget will have a column created for it.
If you need any further assistance, please let us know. We will be happy to help.
- abbdhananiAnswered on September 19, 2014 at 01:15 PM
Thanks for your response.
Not sure I understand, I already have a title on the question. I've looked in the options for the Matrix and cannot see where I need to add a title.
- JotForm SupportdavidAnswered on September 19, 2014 at 02:34 PM
My apologies, I thought that was a header above the matrix. I did a bit of testing with a clone of your form and I am also unable to get the matrix data to populate to a Google spreadsheet. This is the data included in the email, so the data is being passed properly at least to the email.
However the widget is not included at all in the spreadsheet:
I have submitted a bug ticket to our development team to see what may be causing this behavior. We are very sorry for the inconvenience and hope to have a resolution for you soon.
- JotForm SupportsteveAnswered on September 19, 2014 at 05:46 PM
I tested this a bit further and it looks like this occurs when the matrix input type is set to numeric. Our development staff will work on resolving that. In the meantime, a workaround is to select a different input type. Or you can leave it as numeric, and set up the integration later once this issue is resolved.
We apologize for the inconvenience.
- alp_denizAnswered on October 06, 2014 at 01:04 AM
This issue was a temporary bug and should be already fixed. Please let us know if you experience any issues.
- JotForm SupportsteveAnswered on October 06, 2014 at 07:28 PM
I just retested this in a new form/integration and it still doesn't work.
Image of spreadsheet. Note no matrix info since the data type is set to numeric:
Thanks for taking another look at this.
- alp_denizAnswered on October 08, 2014 at 07:26 AM
Thank you very much for following up on this. The issue has just been permanently fixed.
All the best!