JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
Take data from one field and consolidate in new tableAsked by gilparrish on September 17, 2016 at 11:43 AM
I am using the "grid" form report to display all of the entries for my form's submissions. I need to isolate the submissions according to one (or two) field's responses in an automatic subsequent report. Example: Respondent enters "Building A" and "Unit 103" in the two drop-down fields calling for such information. In addition to that information being a part of the standard grid report, I need for that submission to create another grid-type report that is unique to Building A and Unit 103. In other words, it will create a cumulative report of all maintenance for unit A103.
I know that I can use the "search" function in the existing the grid report to gain information on a specific field, but what I need is a way that I can basically have a macro (or something) that will take any and all entries and then generate another hyperlinked report specific to that field or fields.
I think using the Google spreadsheet integration is more suited for the functionality you are looking form.
User guide: How-to-Integrate-Form-with-Google-Spreadsheet
Once the data is in google spreadsheet, you can use the google docs spreadsheet application for your data manipulation or query.
Using the form built in Grid report is just too limited for the process you wanted to achieve.
Hope this help. Let us know how we can be of further assistance.
Jonathan, thanks for the answer. Why isn't Google Docs presented as one of the "Reports" options that users can choose to create reports. Right now, Excel is the only option offered. Help!
That is because the reports are only from JotForm, it means that it is not a third party app integration.
Google Spreadsheet integration is a third party app and this is why it's listed under the integrations option:
You find this while in the Form Builder.
Hope this helps.