- ooehsAsked 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?
- BorisAnswered 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:
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:
I hope this helps.