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

    Syncing with Google Drive.

    Asked by lee@marren.co.uk on April 09, 2014 at 10:37 AM

    Hi there,

     

    We currently use the business version of Google Apps.

     

    I have been using Jotform for a little while and wondered the best way to roll it out to all the other users in the organisation.

     

    Also can you tell me if it is possible to automatically record a users email address or username when they submit a response as is possible in Google Forms?

     

    Many thanks

    Lee

    syncing JotForm email thanks apps
  • Profile Image

    Answered by jedcadorna on April 09, 2014 at 11:45 AM

    Hello,

    Thank you for contacting us..

    I'm not sure if I understand your concern correctly. You want your forms to integrate to google drive? We have integration with google drive you can follow this guide on how to http://www.jotform.com/help/192-How-to-Integrate-a-Form-with-Google-Drive.

    For me the easiest way access would be google drive and reliable as well. You can also use google spreadsheet to capture submissions of your form if that's what you want. You can just add email field then integrate your form to spreadsheet http://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet.

  • Profile Image

    Answered by walledgarden on April 09, 2014 at 12:06 PM

    Hi Lee,

    If your website requires registration and you want their username and email address automatically populate the username and email field of your form, it is not possible. Your website's is hosted somewhere else so any data stored in your database cannot be automatically filled the form fields. 

    Technically speaking, it would still be possible if you have knowledge with the programming language used in your website. Let's say, it is created with PHP and MySQL for your database, you can fetch the data you want, in this case, the username and email address, once data is fetch, you can add some script to put that data in their corresponding field in your JotForm form.

    Bryan

  • Profile Image

    Answered by lee@marren.co.uk on April 10, 2014 at 04:11 AM

    Hi Bryan,

     

    Thank you for getting back to me. Sorry if I wasn't very clear but I wasn't refering to our website login details.

     

    In Google apps (business) we have 80+ users. When we create a Google Form we have the option to share the form publicly or just within our organisation.

    If we only share it within our organisation it asks if we want to record the users email address when they make an entry.

    Basically I need a foolproof way of knowing who has made the entry without having to rely on the user typing their name in correctly everytime.

    We are using formulas in the spreadsheet that look for a unique username in order to sort the information that comes in.

     

    Thanks again

     

    Lee

  • Profile Image
    JotForm Support

    Answered by TitusN on April 10, 2014 at 07:15 AM

    Hello Lee,

    I wish I had a Google Domain access to test this out.

    You can use the the Autocomplete script to get the logged in session details as described here

    Then, populate the session email variable using Javascript onto a form embedded to a shared Google Apps Drive like the one on this page:

    https://googledrive.com/host/0B0jzctT0ecYzd2hTN2djSk5EOTQ/getsession.html

    The session email field will be hidden from view.

    I tried to implement the script - apparently it needs API access for Google Contacts for your domain. 

    Would you consider this method? Perhaps we can test it out.

    This is short of me submitting a feature request to our developers for a Google Apps Domain method for getting session information for a form.

    Let us know.

  • Profile Image

    Answered by lee@marren.co.uk on April 10, 2014 at 07:29 AM

    Hi Bryan,

    It sounds like this could work.

     

    Let me have a play about with it and I will update you on the outcome.

     

    Thanks again.

     

    Lee