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.

  • Profile Image

    Prepopulate a jotform using data from a Google Spreadsheet and concatenation scripts

    Asked by bedelman0731 on September 18, 2014 at 12:10 PM
    The 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)
  • Profile Image
    JotForm Support Manager

    Answered by Jeanette on September 18, 2014 at 12:16 PM

    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.


  • Profile Image

    Answered by bedelman0731 on September 18, 2014 at 04:56 PM

    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.


    - Bob

  • Profile Image
    JotForm Support

    Answered by jonathan on September 18, 2014 at 05:02 PM

    Hi Bob,

    Thank you for taking the time updating us on this.

    Please contact us again anytime should you require further assistance.