The Pledge Search is available from the Interactive Summary Card on the Home Dashboard.
The main searches in Crimson 3 auto save your 10 most recent searches, allow you to save your favorite searches so you can create your own reports, and let you customize the output fields so that your exported results only show the data you select.
There is a Quick Search tool fixed at the top of Crimson that allows you to select which search type you want to use via the drop-down menu. Use the Quick Pledge Search to find a specific record or use the Filtered search on the Home Dashboard to find a list of records.
Quick Pledge Search
Use the Quick Pledge Search tool by searching for the First Name and/or Last Name, part of the Organization Name, and Pledge ID. You can also search for PID, Flags, Keywords, City, State, and Zip Code by entering the “:” colon symbol into the search bar and selecting the search type from the drop-down list. To learn more about the Quick Search, see the Crimson 3 – Quick Searches guide.
The “All Name Fields” search field normalizes the name you enter in the Quick Pledge Search and tries to look for that record using a combination of all name fields.
Detailed Filtered Search
The detailed Filtered search can be used to find either a specific pledge or a group of pledges. The filtered search is helpful in producing a list of all pledges from a single record, pledges belonging to a specific source code, event, and much more. Below are helpful tips when running a Filtered search:
- You can look-up criteria based on any combination of options.
- Search with partial information. For example, search for part of a name by using the Starts with option from the field’s drop-down menu.
- By changing Starts with to Contains, you can search for a string of characters anywhere in the field. For example, if you were looking for a PAC record with “Health” in the name, the Contains search option would search for that word to occur anywhere in the Last Name.
- Search for pledges based on pledged details such as expected and pledged date, amount, fundraising codes (Fund Codes and Source Codes), paid amounts, and tracking #s in the Pledges This includes options to search for amounts that are equal to, greater than or equal to, less than or equal to, not equal to or between ranges.
- Enter criteria in the Suppression section to exclude records from a search. For example, under Flag select the drop-down option “in list of” and list “DNM, DNC” (common for Do Not Mail and Do Not Call) to exclude any pledges from people records that have those flags from the results.
- If you are using the Channel Suppression Flag setting, you can use the Apply Channel Suppression Flags This will suppress all flags marked as Channel Suppression flags in People Settings from your results. Please see the How to Use Channel Suppression Flags FAQ on the HelpDesk for more details.
- To view the selected search fields being used, enable the Selected Only toggle at the top right hand corner so that it is blue. You can also use the Search Filters search to find a particular field to use/view.
- Click the button to display the summary for that particular search. It will show you the filters being used and the output fields included in the results.
- Click the button within a search field to reset and clear out that filter.
- At any time clicking the red button at the bottom right corner of the screen will clear all of your selection criteria and allow you to start a new search.
- Click the button at the footer of the Pledge Search to see a drop-down of your most recent searches for the Pledge Search only.
- Once you have selected the recent search you want to run again from the list, the fields will auto-populate and you will need to press the button.
Save a Search
- Enter the desired search filter criteria.
- Click to indicate if a saved search field should ask you to select the criteria for that particular field at run time. This allows the saved search to function more like a report because instead of saving the exact criteria that should be used for a saved search every single time, the field is more flexible and can be used with different amounts, dates, codes, etc.
- Click to run the search.
- To save a search, click after running the search. A summary of the Filters used and the Output Fields selected will display under the Search Summary.
- Update the title of your saved search in the Query Name Be sure to click Save in the Query Save As window when done.
- If you need to update the output fields for the results, exit the Query Save As page and select the Output Fields Select which fields to include in the output results. Click Save when done.
Run a Saved Search
- To run a search that you previously saved, click . A list of saved searches for the Pledge Search will be displayed. Saved searches are not saved across the different searches so a saved People Search will not be available in the Pledge Search’s Saved Searches.
**Please note, Saved Searches are unique to each user and currently cannot be shared across a database between different logins.
- Click to open a saved search and auto-populate the search fields with what was previously saved. You can make edits to that saved search and click the Save button to update it. Then click to run the saved search.
- Click to see a summary of that saved search and view the Filters and Output Fields
- Click to duplicate a saved search so that you can modify it and then click the Save button to save that as a new saved search.
- Click to delete that saved search.
The Output Fields can be used to select which data you want to include in the results for export. This is helpful in producing lists that will have information you need and exclude information you do not need.
- After entering the criteria into the search fields, click the Output Fields
- There, you can select the fields you want included in your output or unselect the ones you do not. When a field is highlighted and bolded in blue, it will be included in your export.
- Click to reset any changes to the output fields and return to the default search results/export options.
- Once the selection criteria has been entered, click the green button in the bottom right corner.
- The number of records in your results will appear in the bottom left of the page .
- Click a column header, like Expect Date, to sort results.
- Click on the button in the top left to manage the columns.
- Click the check boxes to remove or add a column to the results and drag the column names to change the order they appear.
- Click save to save the order and selection as your column preferences for future searches.
- Click reset to revert to Crimson's default columns and order.
- Any record in the list can be opened by double-clicking on it or clicking the green button.
- The button will export the results to a Microsoft Excel document.
- The button will reset all search fields and start a brand new search.
- The button will restore a saved search or a recent search’s criteria if edits were made to the original search.