Google & Dropbox Integration - Multiple Spreadsheets and Incorrect file URL.

  • Profile Image
    Sam McCay
    Asked on July 15, 2012 at 08:22 PM

    Hi, 

    I have created a form that integrates with both Dropbox and Google spreadsheets. The uploads appear in Dropbox just fine, but the corresponding file information is not appearing correctly in Google Docs: 

    1. Each file submission creates a new spreadsheet (see screen grab), even after deleting and rebuilding the form itself and its Google/Dropbox integrations. Ideally, all submitted form data should appear on only one spreadsheet. 

    2. In the Google spreadsheet, the link URL to the downloadable file points to a Jotform address, not Dropbox as intended. My users will be submitting large files and must be able to upload directly to Dropbox with no file duplication in my limited Jotform storage area. 

    Please advise on how to resolve these two issues. 

    Thanks. 

    Sam 

     

  • Profile Image
    jonathan
    Answered on July 15, 2012 at 09:31 PM

    Hi Sam,

    1. Each file submission creates a new spreadsheet (see screen grab), even after deleting and rebuilding the form itself and its Google/Dropbox integrations. Ideally, all submitted form data should appear on only one spreadsheet.

    I was able to reproduce the issue using a clone of your form.

    However when I tried it on my own created form, I could NOT produce the issue. I was able to integrate both on google doc spreadsheet and dropbox without the issue.

    Would you like to test clone my form and integratate to google doc and dropbox? Check if you are able to produce the issue.

    2. In the Google spreadsheet, the link URL to the downloadable file points to a Jotform address, not Dropbox as intended. My users will be submitting large files and must be able to upload directly to Dropbox with no file duplication in my limited Jotform storage area. 

    This is the normal behaviour of the form when upload fields are used. Uploaded files will always go to JotForm server.

    I do not know how you meant to direct the uploads in google integration to your dropbox. Can you describe the step how you do this?

    Please inform us if you require further assistance.

    Thanks.

     

  • Profile Image
    GoAskErin
    Answered on July 17, 2012 at 03:22 PM

    Hi, 

    Thanks for your response, a couple of followup questions: 

    1. How do I clone your test form? 

    2. When a file is submitted, it uploads to both my integrated Dropbox account, and to the JotForm uploads accounts. I would prefer that 1) Submitted files upload to ONLY my Dropbox account and 2) that the file's Dropbox URL appears in the form's corresponding Google spreadsheet. Is this possible? 

  • Profile Image
    jeanettebmz
    Answered on July 17, 2012 at 05:35 PM

    @GoAskErin

    I am providing you the answer in the same order:

    1.Kindly follow this guide to clone the test form of my colleague

    2. Since the form will be hosted into our servers, there is no way to bypass our servers and let the uploads files to just go to dropbox, therefore the integration cannot generate  just an URL to dropbox and show it in gdocs

    Cheers!

    Jeanette

  • Profile Image
    GoAskErin
    Answered on July 17, 2012 at 06:22 PM

    So what happens when I run out of storage room on Jotform's servers? My dropbox account has over 100gb of storage, how much will Jotform allow me to store? 

  • Profile Image
    NeilVicente
    Answered on July 17, 2012 at 06:32 PM

    @GoAskErin

    Free accounts can store files up to 100MB. When your account is about to reach this limit, our system will automatically send you an email notice so you can log in to your JotForm account and delete files via the form's submissions page.

  • Profile Image
    GoAskErin
    Answered on July 18, 2012 at 01:52 PM

    100mb is too small for my needs. My Dropbox account has 100GB, so the goal is to have all uploads go there and not to Jotform. What it the purpose of Dropbox integration if I'm limited by JotForm's storage capacity? This makes no sense. Please advise on how to workaround. 

  • Profile Image
    jeanettebmz
    Answered on July 18, 2012 at 07:09 PM

    Hello again

    Jotform makes available all the features for free accounts such as integrations; however, like in any business, free accounts have limitations, and in our case, it is related to space. That is why you see limitations in the number of submissions or the upload space.

    You can have more room in a Premium (10GB) or Professional (100GB) account, though

    Best regards

    Jeanette