Advanced Query Wizard: Create a Form Type Query

Forms allow you to track information specific to your organization and store this information to individual constituents’ records. Forms also allow you to record information that may constantly change and retain a copy of all of the forms so that you can refer to past information. This functionality combines the best features of Custom Fields and Notes functions. Create an unlimited number of forms within Salsa CRM. Create an unlimited number of fields within each form.

For an overview of the Advanced Query Wizard and its controls, see Advanced Query Wizard Overview.

1. From the main menu, choose Reports > Queries > Advanced Query Wizard. The Advanced Query Wizard launches.
2. Click the Create New Query button at the top of the Query Wizard window. This opens a new browser tab for your new query.
3. From the Query Type panel along the left side of the window, choose Forms.
4. In the Purpose of this Query section, ensure that General is selected. 
5. All output fields, filter fields, and sort fields will be blank.
6. Click Next. The Step 2 window of the Advanced Query Wizard opens.
7. In the Available Fields frame to the left of the window, ensure that the Output radio button is selected.
8. Double-click a form that you would like to query. It will appear in the Output Fields frame in the center of the window.
9. Click the Sort radio button at the bottom of the Available Fields frame.
10. Double-click the criteria you want to you to sort on. The criteria that you selected will appear in the Sort Fields frame to the right of the window.
    
11. To filter on Form Content data other than the keywords, click the Filter radio button; then, click the Form Content field. The Add Filter Criteria box will open.
12. Choose the Operator that you want to use.
    Note: Multiple filters are, by default, connected by the AND. For example, Donor Address Primary? Equals “Yes” AND Donation Received Date is between “01/01/2006”, “08/13/2008”. This means that the data returned must meet both of the parameters. To change the filter so that the data returned matches either filter “A” OR filter “B”, select the appropriate filter item in the Filter Fields list and choose the Or button. A good way to tell if the filter is going to return the data you expect is to read the filter statement to yourself to confirm that it makes sense before continuing.
    
13. Enter the information you wish to filter on in the Value field in the following manner:
    
    

    *Name of Field??fieldValue

    For example, “*Year Founded??2000” would return forms with the Field Name of “Year Founded” and an entry of 2000.
    
    The criteria you enter will appear in the Filter Fields frame to the right of the window.
    
    
14. The only Form data in the Available Fields panel that you can filter on are the 10 keywords you assigned when creating the form.
15. Click OK in the Add Filter Criteria dialog box to add the filter. The field is listed in the Filter Fields section in the top right corner of the wizard screen.
16. Add any additional filters following the steps above.
17. Once the fields, sort order, and filters have been properly set, click Next. The data is returned on Step 3 of the wizard.
    Note: Select the Back button to go back one step in the Wizard if you make a mistake.
18. Click Next. The Step 4: Post-Query Options window will open.
19. Click the Save... button at the top of the list of buttons.
20. Click Save Query Criteria.
21. Enter a query description you will remember when you add it to the Smart Group designation.
22. Click the Finish button.