Syncing with Google Drive.

  • Profile Image
    Asked 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


  • Profile Image
    Answered on April 09, 2014 at 11:45 AM


    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

    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

  • Profile Image
    Answered 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.


  • Profile Image
    Answered 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



  • Profile Image
    Answered 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:

    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 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.