Google Drive and Spreadsheet: the feature to select which folder to store the form submissions and file(s)

  • DPCREATE
    Asked on March 14, 2016 at 9: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

  • Welvin Support Team Lead
    Replied 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. 

  • DPCREATE
    Replied 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

  • Welvin Support Team Lead
    Replied 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/ 

  • DPCREATE
    Replied on November 4, 2016 at 5: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

  • Welvin Support Team Lead
    Replied on November 4, 2016 at 6: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/