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

  • Profile Image
    Asked 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
    Answered 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 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
    Answered 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.