Once your team has started using Dashpivot daily and collecting lots of information in your forms, you'll want to familiarise yourself with how to search through your data.
The best way to do this is to use the form register view. Click on your template, and then click 'register' to generate a register of all the forms created using that template. From here you can filter by any of the columns, and perform a bulk download.
Multiple filters can be applied to narrow down your data, you can also set multiple conditions within a filter, e.g: for the Weather column: both Wind and Overcast items selected.
Data within a table cannot be filtered - with the exception of list columns in Default tables. The best option to filter table data would be to export the register as .CSV and filter the data in Excel.
More in this video how to use the filters in the Register View:
Notes:
You can edit the columns (hide/show and rearrange) by clicking 'edit columns' but note that only users with team controller permissions (and above) can do this. These changes will affect everyone who views the register, not only for your account.
Filters are available for: Project, Team, Created By, Creation Date, Workflow column, Form Number, Date fields, List fields, Text fields, Yes/No fields, Lists columns in Default tables.
When multiple items have been selected for the filtering in a specific column, all the forms that include one of these items will be displayed.
Changes made to a template will affect the Register View. If a field is deleted, it will no longer appear in the register. If a field is added, it will appear as a new column but will remain blank until some data has been recorded in new forms. If a field is renamed, the associated column in the register will reflect the field name change.