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 Drive and Spreadsheet: the feature to select which folder to store the form submissions and file(s)

    Asked by DPCREATE on March 14, 2016 at 09:37 AM

    Hi

     

    I am trying to add google integration to my forms,  both spreadsheet and drive submission.

     

    The issue i am having  is i need them both to be in the same folder on google drive.  however it is creating a new folder all the time.  this is very messy

     

    the structure i would like is:

    folder 1> submissions

     

    I also want place the spreadsheet inside folder 1, i have copied the folder location but it still not working, i have achieved this before.

     

    Thanks

    google drive google spreadsheet same folder
  • Profile Image
    JotForm Support

    Answered by Welvin on March 14, 2016 at 11:08 AM

    I'm sorry, but with our Google Drive Integration, you cannot select the folder where you want to store the form submissions. A new folder will always get created and named after your settings in the integration process. 

    The Google Spreadsheet does the same thing. You have to set the folder name and that will be created in your Google Account. 

    We do not recommend moving any of the folders in your drive account. 

  • Profile Image

    Answered by DPCREATE on March 14, 2016 at 11:21 AM

    Hi

     

    Thanks for your reply, but this renders the integration pretty useless,  this makes the whole process very messy its ok if you a a single personal form but i use it for all my client web forms and  share them.  This make it very messy and unorganized which leads to the potential for problems,  incorrect shares or deletion.

     

    it would be much better to specify existing folders on the drive.

    ie. webforms> client folder> submissions

    the spreadsheet then could also live in the client folder.

     

    please recommend this as without questions jotform as a tool that web developers can realistically use for their client integration.

     

    Thanks

  • Profile Image
    JotForm Support

    Answered by Welvin on March 14, 2016 at 11:32 AM

    I understand your concern. I have now submitted this thread to our developers as a feature request. We can't give you an assurance if our developers will consider adding this, but if there are updates, you should know it through this thread.

    For the meantime, please try the integration to Jotform through Zapier:

    https://zapier.com/zapbook/google-sheets/jotform/

    https://zapier.com/zapbook/google-drive/jotform/ 

  • Profile Image

    Answered by DPCREATE on November 04, 2016 at 05:53 AM

    I agree, this is pretty much useless for any sort of organisation. Previously I used to be able to specify the spreadsheet folder.

     

    I already pay for Jotform and its integration i should have to rely on an external application in the loop and pay additional subscriptions for the privileged.

    Please rectify this in Jotform as it really is unworkable.

    Thanks

  • Profile Image
    JotForm Support

    Answered by Welvin on November 04, 2016 at 06:38 AM

    As far as I know, this is how our integration works ever since. You may consider doing the integration through Zapier. With Zapier, you should be able to select what folder to save the data.

    https://zapier.com/zapbook/zaps/1924/add-new-jotform-submissions-to-a-google-sheets-spreadsheet/

    https://zapier.com/zapbook/zaps/1949/add-new-jotform-file-uploads-to-google-drive/