How to query submission data from a spreadsheet

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