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

    How to query submission data from a spreadsheet

    Asked by ooehs on November 07, 2016 at 03:58 AM

    I have built a form and integrated it with Google sheet. If I were to create another form to search for specific fields within the spreadsheet and return/display the record sets or specific fields only, how can i do it?

  • Profile Image
    JotForm Support

    Answered by Boris on November 07, 2016 at 06:13 AM

    I'm afraid our forms cannot query data in such a way from outside sources / Google Spreadsheets.

    However, without knowing your exact needs, you may want to try one of the other similar things that come to mind, such as:

    1) Import the data you need from a spreadsheet you have, into your newly created form:

    https://www.jotform.com/help/308-Import-App-Easily-import-your-Excel-or-CSV-data-into-JotForm

    This still wouldn't let you query the data on the second form, but the second form could contain the data you need in a form of already existing (imported) submissions.

    2) Create a searchable submission report of the first form. This will let you search through the submissions made on a first form, and you can choose which columns will be visible to the person that is searching through the report:

    https://www.jotform.com/help/105-How-to-Create-a-Grid-Listing-Report

    I hope this helps.