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

    Intergration with Google Drive issues

    Asked by stevenyilin on December 12, 2012 at 08:17 PM

    hi folks,

    thanks so much with all the improvements - i can now have my teams following up with clients inquiries over our form and it has helped overall automation greatling.

    however, i would like to have 2 teams following up on the same inquiries, because they perform different tasks.

     

    hence, questions:

    1. how can i integrate my form with google docs so i have TWO separate spreadsheets that have exactly the data?

    2. i have the EXACT same form on my website in GERMAN and ENGLISH - is it possible to intergrate data from BOTH into one SET of spreadsheet in google drive?

    3. how do i make sure the newest data is always at the top of the google spreadsheet ... WITHOUT having to MANUALLY copy past "DateValue" as some JotForm Staff have suggested previously.

    4. how come the number of hours my service is needed in only displayed on google spreadsheet INTERMITTENTLY (see screenshot); while it always appears on the email notifications and it is a required value?

    thanks for helping.

    steve

    Page URL:
    http://www.myshoot.at/hochzeitsfotograf-buchen/

    Screenshot
  • Profile Image

    Answered by jeanettebmz on December 12, 2012 at 11:12 PM

    I'll try to answer in the same order

    1. how can i integrate my form with google docs so i have TWO separate spreadsheets that have exactly the data?

    This is not possible as for the moment , each form will create 2 different folders always

    2. i have the EXACT same form on my website in GERMAN and ENGLISH - is it possible to intergrate data from BOTH into one SET of spreadsheet in google drive?

    No, like I said, this is not possible, it's like question one

    3. how do i make sure the newest data is always at the top of the google spreadsheet ... WITHOUT having to MANUALLY copy past "DateValue" as some JotForm Staff have suggested previously.

    This is a feature that has already been requested , so I will be sending a message in order to get an update about it. I cannot promise any estimated time for when this might be available.

    4. how come the number of hours my service is needed in only displayed on google spreadsheet INTERMITTENTLY (see screenshot); while it always appears on the email notifications and it is a required value?

    I can see that your page where our form is embedded contains A LOT of jquery libraries,  and our platform is java prototype, so in order to prevent the malfunction of the form, the code will disable the required fields. To prevent this, please replace the current embedded code with the iFrame code of the form

     

    Cheers!