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 Spreadsheets integration creates duplicate spreadsheet

    Asked by Masalamedia on May 09, 2013 at 11:03 PM

    Step 1) Did normal Google Spreadsheet integration. 

    Step 2) Submitted sample data. Works OK.

    Step 3) Submitted 2nd sample data. Spreadsheet not updated. 

    Step 4) Delete integration, save form, exit form, open form.

    Step 5) Re-do integration. First two submissions flow normally.

    Step 6) Submit 3rd sample data. A duplicate spreadsheet is created. Spreadsheet 1 is apparently orphaned and doesn't get data from 3rd submission. Spreadsheet 2 has complete info. 

    Of course if I've given people the URL for spreadsheet 1, they will see incomplete data. And, I can't really tolerate JF creating multiple files in my Google Drive account with duplicate file names as that creates worlds of data integrity hurt..

    YES IVE CLEARED MY CACHE

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

    Screenshot
    Submissions save form cache Updated
  • Profile Image
    JotForm Support

    Answered by EltonCris on May 10, 2013 at 05:48 AM

    Hi,

    I was able to replicate the problem.

    This is probably due to the  slash symbols "/" on your labels and sub-labels because it works fine after removing those. Unfortunately you have to remove this symbol if you require Google Spreadsheet Integration. These are known issues on the integration since it's some sort of Google API limits. The is the best workaround we can offer for now. Kindly removed those and re-integrate your form to Google Spreadsheet, this should fixed it.

    Thanks!

  • Profile Image

    Answered by Masalamedia on May 10, 2013 at 04:07 PM

    You mean that backslashes in field labels on my form break the Google integration?


    What other symbols or characters can't I use?

     

  • Profile Image
    JotForm Support

    Answered by Mike_T on May 10, 2013 at 05:34 PM

    It is better to not use dashes, commas, brackets and other symbols, unfortunately, we do not have the exact list, so each case should be tested separately.

    Also, you should not have any blank labels and lables that start from digits (like '1 option').

    I think that your integration is not working right due to blank label. Please add some label text to the comment text area:

    If you want to hide it, you can inject the following CSS to the form:

    #label_36 {display:none;}

    Please give it a try and let us know if you need any further assistance.

  • Profile Image

    Answered by Masalamedia on May 10, 2013 at 07:45 PM

    Thanks for this explanation. makes sense. I'll get rid of slashes and dashes etc. 

     

    As for the display:none CSS code, how can I self-discover which # goes with any given label so I can custom-write those CSS lines myself? In otther words, how did you know that label #36 was the label in the Comments section which I wanted to show as blank?

  • Profile Image
    JotForm Support

    Answered by jonathan on May 10, 2013 at 11:20 PM

    Hi,

    As for the display:none CSS code, how can I self-discover which # goes with any given label so I can custom-write those CSS lines myself? In otther words, how did you know that label #36 was the label in the Comments section which I wanted to show as blank?

    You can do this on the form builder. Here are the steps you can try

     

     

    OR if you you can use the Chrome browser inspect element tool (in Firefox, use Firebug)

    You have to preview the form first to use the inspect tool in Chrome then do this steps

     

    On the element display you can find the label or input id#

     

    Hope this help. Inform us if you need further assistance.

    Thanks.