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 is not including all the form submissions

    Asked by davibiel on June 18, 2013 at 04:31 PM

    Good afternoon

     

    I'm having problems integrating with Google Spreadsheets. Completed forms site www.maquinadecartao.com.br stopped being imported into the worksheet. Removed integration, but the problem remains:

     

    1) By integrating form, is only importing submissions until 04/16/2013. Not matter fully.

     

    2nd) The completed forms are not being updated in the spreadsheet.

     

    3) The spreadsheet formatting lost.

     

    There are many, many problems!!

     

    Clayton Leal

    www.gooal.com.br

    Rio de Janeiro - Brasil

    Page URL:
    www.maquinadecartao.com.br

    Screenshot
    problem Submissions Updated site
  • Profile Image
    JotForm Support

    Answered by KadeJM on June 18, 2013 at 04:50 PM

    Normally when you reintegrate it should repull all of the old and have new incoming data for submissions into your spreadsheet. Can you try reintegrating one more time but before you remove it and then add the integration again first remove the integration then clear your form cache, now try this time to reapply the integration and see if everything comes through. Please let us know if the problem is still happening.

  • Profile Image
    JotForm Support

    Answered by KadeJM on June 18, 2013 at 04:58 PM

    I additionally took a further look at the google integration and so far it appears to be working as it should so please try the above method first to see if it works and let us know.

  • Profile Image

    Answered by davibiel on June 18, 2013 at 05:36 PM

    And this formatting is lost?

    How do I return with this formatting?

     

  • Profile Image

    Answered by davibiel on June 18, 2013 at 05:38 PM
    Dear,
    And this formatting is lost?
    How do I return with this formatting?
    [image: Imagem inline 1]
    *Clayton Vaz Leal*
    Gercia Comercial e Marketing
    Rua Sete de Setembro 63, sala 602 - Centro.
    Rio de Janeiro - RJ.
    (21) 2242-2590 / 8670-9399
    www.gooal.com.br
    N n geramos apenas Leads. N sonhamos com o crescimento da sua
    empresa em conjunto com a Gooal. N facilitamos a vida de consumidores que
    esperam encontrar na internet produtos e servis com qualidade e pres
    competitivos. Permitimos que os vendedores da sua empresa atendam
    consumidores que podem efetivamente se tornarem grandes clientes. Isso a
    Gooal.
    "Aumente suas vendas. Seja uma empresa Parceira da Gooal"
    2013/6/18 JotForm Support Forum
  • Profile Image
    JotForm Support

    Answered by jonathan on June 18, 2013 at 06:17 PM

    Hi Clayton,

    Have you formatted the integrated google spreadsheet?  

    I'd like to inform you that everytime you removed and re-integrate the form on Google Docs Spreadsheet, it will create a new instance of the spreadsheet to pull all the submissions into it. Meaning, it will be a new spreadsheet. This is the reason why the previous formatted spreadsheet is not used anymore.

    You may try formatting again the newer integrated spreadsheet.

    Hope this answers your inquiry. Please inform us if issue persist.

    Thanks.

  • Profile Image

    Answered by davibiel on June 18, 2013 at 06:30 PM
    Ok,
    Longer a problem. When importing the form, submissions leap from 04/16/2013
    to today. Where are the other submissions in April, May and June?
    [image: Imagem inline 1]
    *Clayton Vaz Leal*
    Gercia Comercial e Marketing
    Rua Sete de Setembro 63, sala 602 - Centro.
    Rio de Janeiro - RJ.
    (21) 2242-2590 / 8670-9399
    www.gooal.com.br
    N n geramos apenas Leads. N sonhamos com o crescimento da sua
    empresa em conjunto com a Gooal. N facilitamos a vida de consumidores que
    esperam encontrar na internet produtos e servis com qualidade e pres
    competitivos. Permitimos que os vendedores da sua empresa atendam
    consumidores que podem efetivamente se tornarem grandes clientes. Isso a
    Gooal.
    "Aumente suas vendas. Seja uma empresa Parceira da Gooal"
    2013/6/18 JotForm Support Forum
  • Profile Image
    JotForm Support

    Answered by jonathan on June 18, 2013 at 09:18 PM

    Hi,

    I am not able to reproduce this issue. I test on my form with submissions as old as 2012, and they were all included in the integrated google spreadsheet(it has 400 total submissions).

    See image below

     

    Please take note that in the integrated spreadsheet, the submission is usually ordered from oldest to newest submission's date. The older data should be on row 1st of the spreadsheet...

    Please check again. Continue updating us if the issue persist.

    Thanks.