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

    Google Spreadsheet Integration missing information

    Asked by snit99 on May 08, 2016 at 09:51 PM

    Please excuse the look of my form.  This is in the beginning stages.  I wanted to test to see what the integration would look like before continuing on.

    I am having trouble with the integration to Google Spreadsheet.  

    I have read many posts regarding this issue in the forum.

    This is what I have done so far:

           - Removed Integration, then connected again.

           - Cleared Cache and browser history from both Chrome and Safari

           - removed integration again.  then connected again.

     

    When you click on the furthest right column in the Google Spreadsheet "Edit Submission", it shows the form with all the numbers filled in.  But on the spreadsheet, the numbers are not filled in.

    Also, the "Submission Date" and "Date Submitted" format has changed.  I don't know why.  I do like the look of the latter better, but it really doesn't matter.  I do not know why the formatting changed.

    BUT more importantly, I would like to know why the integration is no long working.  

    Page URL:
    https://www.jotform.com//?formID=61265378947974

    Screenshot
  • Profile Image
    JotForm Support

    Answered by liyam on May 09, 2016 at 12:23 AM

    Hello,

    Thank you for reporting your concern to us.

    I have made my series of tests and apparently, like the one you're experiencing, I'm not able to populate the cells which are set for the field matrix even if I have them properly filled upon my submission.

    However, the possible problem I see is that your matrix field has no label in it. As a fix, please try adding a label in it, and if you really do not want to show a label, we can hide it by inserting this code via CSS injection:

    #label_17 {
    display: none;
    }

    Looking forward to your updates.

    Thanks.