Page Comparison

Form Queries are a feature within the Forms section to help analyse the answers that users give to forms. They work similarly to Member Lists in how they are created. They can also be used in Member Lists in order to use the list of users in other places around your site.

In this example, the form being used is a form to report an incident that happened at a racing event.

Instructions

1. Navigate to

...

1. Forms > Forms

...

1. Manager

2. Next to the Form you wish to query, click

...

1. Analyse >

...

1. Queries.

...

1. Image Added

2. Click the green “Add New” button.

...

1. Image Added

2. Name: The name of the Query.

   Image Modified

3. Description: A short description about the purpose of this Query.

4. Design: The Query is created by running a search on the answers to the Form it is attached to. The search will be run each time the Query is used, so it will always be up-to-date. Enter elements to build up the criteria for the Query search.

   Image Modified

   1. Add Criteria: Add another criterion to the Query.

   2. Add Grouped-criteria: Add grouped criteria to the criteria above. Such as a user that answered that the damage was less than £100 and the date or person who hit them is unspecified. For readers with an understanding of logic, these clauses would be contained within brackets e.g. Cost of Damage is less than £100 AND (Who hit you is null or empty OR Date of incident is not specified)

   3. And/Or: Criteria can be used in an “And” or “Or” Capacity. If “And” is chosen, all criteria must be true for a user to be added to the Query, if “Or” is chosen, only 1 criterion must be true.

   4. Delete criterion: Removes this criterion from the Query.

       

5. Test Run: This can be used to test the Query before saving and using it. Just click the “Run” button and you will be shown a list of all matching users along with the count.

...

1. Image Added

2. Save: Save the Form Query.

   Image Modified

Other Functions

In the list of Queries for each form, there are some extra options next to each Query.

...