- jotithowardAsked on November 20, 2012 at 03:10 PM
If my form has lost integration. How can i reintegrate so that new submissions are added to the form as they once were?
Jotform --> google docs spreadsheets
- JotForm SupportidarktechAnswered on November 20, 2012 at 03:42 PM
When you re-integrate your form with GDocs, existing submissions will be automatically added as well. Here's a short visual guide on how to re-integrate your form with GDocs.
- jotithowardAnswered on November 20, 2012 at 03:54 PM
Yes, existing submissions will be added. What about new submissions?
I tried to reintegrate to an existing google doc that was created from a previous integration. It appears to be integrated, but all new submissions create a new, separate spreadsheet. Is there anyway to change this.
so all new submissions appear on the original spreadsheet that the form was integrated with?
FYI: all headers will remain the same.
- jotithowardAnswered on November 20, 2012 at 04:03 PM
I need it to go to the same Google Doc. not create a new one.
- JotForm SupportidarktechAnswered on November 20, 2012 at 04:11 PM
I think I've missed your point on the first place but thanks for your prompt response and for giving such details. I appreciate it very much.
Sorry though but each integration generates unique spreadsheet URL therefore there's no direct way to have it inserted on the previous integration link.
However, you can still have the new submissions to be inserted on your previous google spreadsheet by using google's importrange feature. This is like linking your new spreadsheet to your previous spreadsheet, see here for more details. http://support.google.com/drive/bin/answer.py?hl=en&answer=155183
Do let us know if you have further questions. Thanks!
- jotithowardAnswered on November 20, 2012 at 04:33 PM
yes but you only get 50 fields with import range. :-( this is not good for me at all. if anyone ever stumbles upon this and can recommend a workaround, Id really appreciated it..
- JotForm SupportidarktechAnswered on November 20, 2012 at 05:32 PM
Thanks. Unfortunately, that's the only workaround I could think as of now. Thanks for giving us a new information about the importrange limit, I did a research on it as well, it's just new to me :)
I found it here: http://support.google.com/drive/bin/answer.py?hl=en&answer=2505921, it says ImportRange formulas: 50 cross-workbook reference formulas does it means 50 workbook not fields? I did a test on it and I was able to import almost 100 rows with data on each cell. You can actually modify the range to be imported. Example:
If I have overlooked something, please let us know. Thanks!