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.
Prepopulate a jotform using data from a Google Spreadsheet and concatenation scriptsAsked by bedelman0731 on September 18, 2014 at 12:10 PMThe demonstration looks to be close to what we are seeking. In our case, we could have links in the Google Spreadsheet that would then launch a form that would then show some information from that row. But that form would need to be able to collect new information from the form that would then be fed back to a spreadsheet (perhaps into the same row or perhaps into a row in another sheet)
JotForm Support Manager
Yes, you can pre-populate data from the spreadsheet as explained in this thread, in a jotform that may contain more fields. This new form can be integrated with Google spreadsheet that will create a new spreadsheet upon submitting with the previous and new submitted data.
Thank you for the reply and I did some additional experimentation after my posting. I now have a working prototype that others within my company are going to review to see if it will fit their needs.
Thank you for taking the time updating us on this.
Please contact us again anytime should you require further assistance.