Creating a query for cash AND check donations
From your Green Screen click on the Donor Icon
Click on the Filter Icon
Here you will be presented with the Select Viewing Criteria window. You will select Tab 2-Other Tables, and select Donations received. At that point you will click on the Query button.
Here you will be presented with the "User defined Query Builder for "donatn01" table menu". Click on the NEW button.
Here is where you will start building your query! In the Data Item menu select Payment Method
Next step is to select Contains from the Type of Comparison menu
In your Compare to field, click on the F2 button. Your payment method menu will appear. Here you will select CASH and click the OK button.
In the Continuation menu you will select OR and click NEXT.
Here you will be presented once again with the Payment method. Here is where you will select Check and click OK.
At this point you will click NEXT
There will be a pop of warning asking if you want to edit the query manually. In this case (as in most) you would click NO.
Here you will be presented with the Save New query popup. You can name your query whatever is easiest for you to remember, then select Save & Run which will save this query in the future and click OK. It will run your query and find all the donors who have donated using either cash or checks.
Our products got an upgrade!
Some screenshots and help videos have been made using older versions of our products. Though your version's colours and themes may appear different than what you see here, the instructions, links and advice in this article are still accurate and useful!
Related Articles
Scopes, Queries & Filters
What is a Scope? A scope is a list of donors from your database. There are several ways that you can create a Scope, but the two main ways are to use Filter or Query. In addition to that you can also Tag records, Flag records and Memorize and ...Memorizing Scopes & Running Saved Queries
Memorize a Scope If you have a filter in place, or have tagged a list of names and wish to save that list for future use, you may want to memorize your current scope. To do this: Click the "Filter" button (it looks like a green funnel). If you used ...Importing CanadaHelps Donations into Silent Partner
If you regularly enter donations your organization receives via CanadaHelps into Silent Partner, you might find it more convenient to import them in bulk: Silent Partner has everything set-up for this process. In order to import donations, you would ...Online Donations - PayPal: Creating buttons
Creating and Testing your Form in the PayPal Sandbox The PayPal Sandbox has been set up to work exactly like the live PayPal site, except no real currency changes hands. You can make and receieve donations, view transaction history, refund donations, ...Creating a Cloud User
You need Administrator privileges to set up Cloud users. Once logged onto the Cloud, go to Admin Settings > Cloud Users Set up the user profile to allow the user to log into Silent Partner Cloud To add a new user, click "Add DMS User." Managing ...
Societ Academy
Learn what you need to know, any time. Free!
- High quality training on demand - sessions are available every day, so you can access training that fits into your schedule.
- Training sessions that are easy to follow - helpful tips throughout each session, and access to training moderators ensure your questions get answered.
- A certificate of completion - you can request a certificate of completion for every session you attend.