JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Form with Google Spreadsheet integration from dev to production migrationAsked by sgaudrea on April 18, 2015 at 02:13 PM
Im using my form with the google sheet plugin to send all my db data to a sheet. Based on my google sheet data, Im showing graph on my website. Everytime im adding fields, its breaking my graph and I need to fix (i can live with this). My question is, what is the best way to develop my form then push it on my production website when Im ready. I can clone my prod form, then when Im ready, I just change the iframe url in my website to target my new form. My problem is that I need my data to follow my forms all the time because my graphs needs all the submissions. The only option I see is to develop directly on my production form to be able to always get the submissions in the same db. Im using jotform.com, not the vm.
My problem is that I need my data to follow my forms all the time because my graphs needs all the submissions. The only option I see is to develop directly on my production form to be able to always get the submissions in the same db
You can only use the Google Spreadsheet integration to one form at a time.. so, this means that if you need the submission of the specific form to be up to date, you will have to use this one form only.
You should finalize the form that you were using in the Google Spreadsheet integration.
Because if you still keeps on modifying the form (adding/removing fields on it), you will have to update the integration every time also. To update the integration, you will need to disconnect and then integrate again.
Redoing the integration process will be the only way the spreadsheet will become up to date with the existing and new incoming submission data from the form.
Hope this answers your inquiry. Please let us know if you need further assistance.
It partially respond to my question. Basicly, if I have 500 submissions in form-A and I need to do some major additions to this form, I need to clone it to a have DEV form. When form-dev will be ready, I want to use it on my website instead of form-A. I can't because form-A 500 submissions aren't clone in form-dev. i need to keep those 500 submissions and I also need to do developpement without impacting form-A until everything is working and tested.
Thank you for the clarification.
You shouldn't use clone method just to move the submission data from Form-A to a Dev-Form.
Please check out the JotForm Combine Submissions App also.
Using this App you can move/copy/combine the submission data between the 2 forms.
This will eliminate the need to modifying and cloning the form because you will be able to move data without touching the front-end which is the form.
Let us know if still not the solution to your requirement.