What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
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.
Google Spreadsheet submissions - can I add columns and rows?Asked by L1H on September 18, 2014 at 09:31 AM
we have created a form for user-submitted details. We would like to use the Google Spreadsheet submissions spreadsheet to add input from the team (e.g. comments, prioritization etc.) - which should be several more columns at the end of the spreadsheet.
I have noticed that with new submissions - or after a certain time, one of the two - the additional columns are deleted. I guess the spreadsheet updates itself from the available form fields.
My first workaround was to create a second spreadsheet with formula links to the original submissions spreadsheet. This sort of works (don't know if it will be deleted once the spreadsheet updates) but instead of filling the existing lines for each new submission, the submissions spreadsheet appears to insert new lines.
Hence, the formula links of the second spreadsheet are 'broken':
In the original sheet, Cell B10 is a data point for one submission, B11 is the same data point for the next submission. I duplicate all data with the formula ='OriginalSubmissions'!B10 . I replicate this so that B11 in the duplicated sheet is ='OriginalSubmissions'!B11.
Once a new submission comes in, a new line is inserted - so every time a new submission comes in, I have to update the formula links (because if I don't, the duplicated sheet jumps from ='OriginalSubmissions'!B10 to ='OriginalSubmissions'!B12 in the next line.
Can you help me? Am I doing it wrong? Is there another way to make annotations to submissions and keep them?
A quick update:
The second sheet in the submissions document was deleted, probably after the last new submission came in. The workaround is not stable. Linking to a different document is not possible in Google Spreadsheets.
What would you recommend me to do?
As far as I know you should be able to update your spreadsheet as long as you do not alter the fields that are associated with your JotForm. The key here is the column names use in the spreadsheet. As long as you do not change the column name created on the spreadsheet when the form was integrated, all succeeding submissions will still map the appropriate fields even if you move the column number (by adding/inserting new columns).
Here is a screen of my test, wherein I appended the new column "Issue Resolved" right before the 1st original column (Submission Date). As you can see I was able to submit the last data (3rd row).
It should retain the added columns in the sheet as long as the form itself is not changed. If the form itself is changed the sheet will update accordingly and potentially delete added columns and data.
Thank you very much!
This helps a lot. I will try to have the final names for questions and columns asap so there are no further changes.
You are very welcome! Let us know if you have any further questions and we will be happy to help.