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.


  • Profile Image

    Matrix widget not populating to google spreadsheet

    Asked 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.

     

    please advise

     

    abb

    Page URL:
    http://form.jotformpro.com/form/42613705517957

    all email integration spreadsheet
  • Profile Image
    JotForm Support

    Answered by david on September 19, 2014 at 11:57 AM

    Hi,

    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.

  • Profile Image

    Answered by abbdhanani on September 19, 2014 at 01:15 PM

    Hi David

     

    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.

     

    Thanks

    -Abb

  • Profile Image
    JotForm Support

    Answered by david on September 19, 2014 at 02:34 PM

    Hi,

    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.

  • Profile Image
    JotForm Support

    Answered by steve on September 19, 2014 at 05:46 PM

    Hello-

    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.

  • Profile Image
    JotForm Support

    Answered by alp_deniz on October 06, 2014 at 01:04 AM

    Hello,

    This issue was a temporary bug and should be already fixed. Please let us know if you experience any issues.

    Kind regards

  • Profile Image
    JotForm Support

    Answered by steve on October 06, 2014 at 07:28 PM

    Hello @Alp-

    I just retested this in a new form/integration and it still doesn't work.

    Sample form:

    http://support.jotform.com/form/42787653994980

    Image of spreadsheet. Note no matrix info since the data type is set to numeric:

    Thanks for taking another look at this.

    Cheers!

  • Profile Image
    JotForm Support

    Answered by alp_deniz 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!