Hi, I'd like to send different forms to different spreadsheets, however

  • Profile Image
    Devin Quinn
    Asked on January 02, 2014 at 03:14 PM

    Hi, I'd like to send different forms to different spreadsheets, however I'm not getting prompted to enter in a new spreadsheet name. How can I add a second or third one?

    Also, is it possible to send two forms with different titles but same content to 1 spreadsheet?

    Thanks, Devin



    This is a re-post of a comment on How to Integrate Forms with Google Sheets

  • Profile Image
    Devin Quinn
    Answered on January 02, 2014 at 04:20 PM
    Hi Eliezer,
    1 - Yes. I was working this morning on form 'Small Ships booking' and
    integrated it with google spreadsheets with no problems.
    Next, I move to form 'Small ships request' hoping to set up a separate
    itegration for this form as well. After selecting the type of
    integration i'd like (google spreadsheet) the next window showed me teh
    link where I could view the spreadsheet. However, i want to create a new
    spreadsheet with different name, but that option was never given. If i
    followed the link, I'd end up in my browser with a message that told me
    I was not authorized, despite having my gmail account open, and nothing
    further would happen.
    Originally I wanted the content of 'small ships request' and 'euro river
    cruises request form' to integrate into the same spreadsheet.
    Thanks again!
    Devin Quinn
    Euro River Cruises - eurorivercruises.com
    Small Ships - smallships.travel
    365 Route 304 Ste. 206
    Bardonia, NY 10954
    (888) 863 1212
    ...
  • Profile Image
    Jonathan
    Answered on January 02, 2014 at 06:09 PM

    Hi Devin,

    Every time you integrate a form to Google spreadsheet (guide: How-to-Integrate-Form-with-Google-Spreadsheet), a NEW spreadsheet will be created for that form alone. 

    There is no means to have 2 forms = 1 spreadsheet

    During the integration process (please refer to the guide I mentioned), you will have the chance to give NAME to the spreadsheet. This will be the name of the google spreadsheet that will be created in your google account. This was mentioned in the guide I provided

    Next, choose a folder name where you would like this new Google Spreadsheet document to be created. You may also change the name of the document on this step. 
    google docs wizard

     

    I hope this clarify the matter. Please inform us if further assistance is needed.

    Thanks.

  • Profile Image
    Thundatest
    Answered on June 08, 2014 at 11:01 AM

    Hi there - I had the same problem as Devin:

    When trying to integrate a new form I was working on, to integrate with a Google Spreadsheet, I found it was already connected to a sheet and did not ask for a new spreadsheet name.

    Think I have discovered why - The new form I worked on was a clone of a previous form; so it had carried over the integration with Google from the original form: I "removed integration" in the wizard, and then relaunched the integration wizard, it then asked for new spreadsheet name etc and it seems to be working fine now.

    Just adding this comment here, as I believe the last answer from Jotform didn't address that part of Devlin's issue.

  • Profile Image
    BryanPaulo
    Answered on June 08, 2014 at 01:19 PM

    @Thundatest,

    Thank you for sharing your experience, it will help a lot of users having the same kind of problem. It must be a rare situation and must not be happening when cloning a form, I tried to test my forms to make sure this is not happening and fortunately, after cloning the first form with Google Spreadsheet integration, it was not carried over to the cloned form. Should this happen again, kindly report the problem along with the link of the 2 forms in question so we can investigate the problem. We want to see that 2 different forms are integrated to the same spreadsheet.

    @Devin,

    Even if it will give you the option to choose which folder you want the submissions to be uploaded, and name the spreadsheet exactly the same name as the other form, google spreadsheet will create another spreadsheet for the other form with the same name. So, to answer your question, no, it is not possible to have 2 forms share the same spreadsheet. As suggested above, please disconnect and re-integrate your google spreadsheet. That shuld give you the option to set the folder and name of the spreadsheet.

    Let us know if you need further help.