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.
Can we add columns at the end of the google sheet that is linked to a jotform?Asked by cherrihsu on March 09, 2015 at 09:55 AM
Hi we have added columns (such as the edit link, and other links we generated from the submission data) to the google sheet that's been integrated with a jotform. In the past weeks of test, these data has been there without a problem. However, over the past weekend, all the additional columns are deleted. I wonder if such a use is forbidden/discouraged? How should we expand the database in the subsequent management then?
JotForm sheet problem edit link expand
Did you recreate the integration recently? If you have, this is why the file was regenerated again and the extra columns were removed. We usually recommend leaving the sheet unchanged since the integration might break or the extra info might get lost if a reintegration is performed.
What you could try is to create a second spreadsheet to capture the extra info and then merge the 2 sheets so you can see all the info.
Let us know if this would be a viable solution for you.