- Devin QuinnAsked 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?
This is a re-post of a comment on How to Integrate Form with Google Spreadsheet
- EliezerNAnswered on January 02, 2014 at 04:02 PM
1- Are you saying that when you are building the integration in two different forms it automatically use the same spreadsheet for both forms? Could you please provide more information about the issue you are having so that we can further assist you?.
2- No, it is not possible. You need to create one spreasheet for each form.
We will for your reply.
- Devin QuinnAnswered on January 02, 2014 at 04:20 PMHi 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.
Euro River Cruises - eurorivercruises.com
Small Ships - smallships.travel
365 Route 304 Ste. 206
Bardonia, NY 10954
(888) 863 1212
- JotForm SupportjonathanAnswered on January 02, 2014 at 06:09 PM
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 providedNext, 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.
I hope this clarify the matter. Please inform us if further assistance is needed.
- ThundatestAnswered 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.
- BryanPauloAnswered on June 08, 2014 at 01:19 PM
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.
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.