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.
Matrix widget not populating to google spreadsheetAsked by abbdhanani 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.
all email integration spreadsheet
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.
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.
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.
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.
This issue was a temporary bug and should be already fixed. Please let us know if you experience any issues.
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.
Thank you very much for following up on this. The issue has just been permanently fixed.
All the best!