How to query submission data from a spreadsheet

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?

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.