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

    reintegrating form with google docs

    Asked by jotithoward on November 20, 2012 at 03:10 PM

    If my form has lost integration.  How can i reintegrate so that new submissions are added to the form as they once were?

     

    Jotform --> google docs spreadsheets

     

  • Profile Image
    JotForm Support

    Answered by idarktech on November 20, 2012 at 03:42 PM

    Hi,

    When you re-integrate your form with GDocs, existing submissions will be automatically added as well. Here's a short visual guide on how to re-integrate your form with GDocs.

  • Profile Image

    Answered by jotithoward on November 20, 2012 at 03:54 PM

    Yes, existing submissions will be added.  What about new submissions?  

     

    I tried to reintegrate to an existing google doc that was created from a previous integration.  It appears to be integrated, but all new submissions create a new, separate spreadsheet.  Is there anyway to change this.

    so all new submissions appear on the original spreadsheet that the form was integrated with?  

     

    FYI:  all headers will remain the same.

  • Profile Image

    Answered by jotithoward on November 20, 2012 at 04:03 PM

    I need it to go to the same Google Doc. not create a new one. 

  • Profile Image
    JotForm Support

    Answered by idarktech on November 20, 2012 at 04:11 PM

    I think I've missed your point on the first place but thanks for your prompt response and for giving such details. I appreciate it very much.

    Sorry though but each integration generates unique spreadsheet URL therefore there's no direct way to have it inserted on the previous integration link.

    However, you can still have the new submissions to be inserted on your previous google spreadsheet by using google's importrange feature. This is like linking your new spreadsheet to your previous spreadsheet, see here for more details. http://support.google.com/drive/bin/answer.py?hl=en&answer=155183

    Do let us know if you have further questions. Thanks!

  • Profile Image

    Answered by jotithoward on November 20, 2012 at 04:33 PM

    yes but you only get 50 fields with import range. :-(   this is not good for me at all.  if anyone ever stumbles upon this and can recommend a workaround, Id really appreciated it..

     

      thanks.

  • Profile Image
    JotForm Support

    Answered by idarktech on November 20, 2012 at 05:32 PM

    Thanks. Unfortunately, that's the only workaround I could think as of now. Thanks for giving us a new information about the importrange limit, I did a research on it as well, it's just new to me :)

    I found it here: http://support.google.com/drive/bin/answer.py?hl=en&answer=2505921, it says ImportRange formulas: 50 cross-workbook reference formulas does it means 50 workbook not fields? I did a test on it and I was able to import almost 100 rows with data on each cell. You can actually modify the range to be imported. Example:

    =importrange("0AsdV9QbdAmEtdE9RM2lNVWgwSDVxcEF0b3JnQWNra2c", "Submissions!A1:Z100")

    If I have overlooked something, please let us know. Thanks!