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

    Asked by bluejock on April 03, 2013 at 12:06 PM

    I set up my form just fine and integrated with Google spreadsheets.  Here is my form: http://form.jotform.us/form/30918095581157  First three submissions went fine.  Then all that followed did not import into the spreadsheet.  They went to my dropbox which I also want and I got a cinfirmation email, but they are just not showing up oin the spreadsheet.  I checked the integration url and its the same as my spreadsheet in google docs.  https://docs.google.com/spreadsheet/ccc?key=0AhvUY-s92JzgdGc0RTB2dlhyZ1FqSmplejFNekkyV0E

    Help!

    Page URL:
    http://form.jotform.us/form/30918095581157

    Submissions JotForm email dropbox
  • Profile Image
    JotForm Support

    Answered by Welvin on April 03, 2013 at 01:21 PM

    Hi,

    Please share your Google Spreadsheet as Public or Unlisted. Your form is also not available, it says "deleted".

    One suggestion is to never use any symbols on Field Labels because that is sometimes the cause of the failure of the integration. Edit your form and re-integrate the form to Google Spreadsheet. That should help.

     

    Thanks

  • Profile Image

    Answered by bluejock on April 03, 2013 at 01:45 PM

    Here is my spreadsheet:https://docs.google.com/a/imovechicago.com/spreadsheet/ccc?key=0AhvUY-s92JzgdFVMQ3R1WGw4YXJwaVdMT1BXdFItenc#gid=0

    Its shared.

    Here is my form: http://www.jotform.us/bluejock/Case_Files_Form

    When I reintegrate, I get the prior submissions but when I try to submit another, it doesn't show up.

  • Profile Image
    JotForm Support

    Answered by jonathan on April 03, 2013 at 04:56 PM

    Hi,

    Can you please share your gdocs again. This time, please make sure to allow View to the links. We cannot view it right now due to access permission denied.

     

    Can you also modify some of your form's labels/questions... try removing apostrophe(') for those labels that have them.. i.e. Doctor's Counsel 

    Btw, your form http://www.jotform.us/bluejock/Case_Files_Form has no required fields, so it is possible to submit the form without answering any of the question. I thought I should let you know that.

    Please try this and test submit the form again. Inform us if this does not make any difference.

    Thanks.

     

  • Profile Image

    Answered by bluejock on April 03, 2013 at 05:06 PM
    OK Added jotform@jotmails.com to view spreadsheet. Here is link:
    https://docs.google.com/a/imovechicago.com/spreadsheet/ccc?key=0AhvUY-s92JzgdFhSandnZzJWSG9rTW8wWE5zbHNjeHc&usp=sharing
    Here is my form: http://www.jotform.us/bluejock/Case_Files_Form
    Removed ' from form fields.
    Re-integrated. It brought in ll prior form submissions but then would not
    accept a new one.
    **
    *
    "I appreciate that you have chosen me to represent you. *
    * If I have served you well, please consider referring your *
    * friends, family and colleagues. Thank You."*

    Rusty A. Payton
    Attorney at Law
    161 North Clark, Suite 4700
    Chicago, Illinois 60601
    312-702-1000 [Phone & Fax]
    e. rustypayton@me.com
    w. attorneypayton.com
    *Please consider the environment before printing this email.*
    The information contained in this email communication is intended only for
    the personal and confidential use of the designated recipient named above.
    This message may be an attorney-client communication, and as such is
    privileged and confidential. If the reader of this message is not the
    intended recipient, you are hereby notified that you have received this
    communication in error, and that any review, dissemination, distribution,
    or copying of the message is strictly prohibited. If you have received this
    transmission in error, please notify us immediately by telephone and/or
    reply email.
    *Circular 230 notice*
    To ensure compliance with requirements imposed by the IRS, we inform you
    that any U.S. federal tax advice contained in this communication (including
    any attachments) is not intended or written to be used, and cannot be used,
    for the purpose of (I) avoiding penalties under the Internal Revenue code
    or (II) promoting, marketing or recommending to another party any
    transaction or matter addressed herein.
  • Profile Image
    JotForm Support

    Answered by jonathan on April 03, 2013 at 06:56 PM

    Hi Rusty,

    I could not access the form anymore http://www.jotform.us/bluejock/Case_Files_Form , it seems you have removed the custom URL.

    And also the shared google spreadsheet have message that it was already in the item trash.

     

    I could not do any test at this time.

    Please update us.

    Thanks.