Entering actions for later queries
Options
I'm in the process of getting my organization recording actions more and I was wondering how you query on actions at your organization. For example we just sent out an invitation to 100 people for an event. How would you set up an action so that in the future we could go back and make a query to pull all of those people together. I added the action through loading defaults, so they would all have the same notpad description. I'm wondering if I should keep an exel spreadsheet with the action description for each FY to refer back. I know you can query on action date, but what if there are different actions on one date, or if you don't remember the date in a year.
Tagged:
0
Comments
-
If you have entered those 100 people into your event record as Invited, you can then always create a query based on this data in the event record. No need for an action at all ...0
-
As Gina said, using Event & Participant Records makes it easy...provided you have the Events Module.
If you don't have the Events Module, I would use Actions, but create an Action Type for Events. Then I would (and have done so in my db) create a dummy Constituent Record (ours is ConstID 456123) and put the same Action there, including any additional relevant Notes. This way in the future, you can go to that dummy record and look thru the Actions to find the Event you want...then write a Query to find those records with the same Action on them. In fact, I'd probably use an Action Attribute to create an Event ID, assign each Event an ID number, and put it on each "Event" Action, including the dummy record.
See this post and also this post for more.2 -
Thanks Gina and Jen!
We have the events module but when I started with the organization 3 months ago my supervisor said they were not going to keep the module when they renew in September because they had never used it. So I'm trying to figure out a way without the event module, but maybe if I can show her how we can start using it they might decide to keep the events module around!0 -
If you are considering a move to NXT anytime soon, it includes (last I knew) 3 modules. Unless you need 3 others, you would be getting/keeping Events anyways.0
-
I would highly recommend keeping the event module, sounds like perhaps they didn't quite understand how it could be utilized? To me the beauty of the event module is that it keeps everything related to events totally organized -- so you don't have to clutter your system with appeals, actions, notes in order to track your events - it's all bundled right there in the events module.
Good luck!1 -
We use appeals for all solicitations, event invitations, emails, etc.1
-
To answer your question more directly, this all depends on if you are looking for the actual actions or if you are looking for constituents with a particular action on their record.
If you are querying for the action, you'll need to create an action query, and you should include all information that these actions share. Any time you query for anything, you need to think about what makes the object of your pursuit unique. Usually it's a set of things that make the items unique. In this case, perhaps you should look for the date, action type, and notepad type. Or maybe date, action type, and solicitor. Or maybe you need to include "date added" and "added by." There are a lot of fields, so just figure out what combination you need.
If you are trying to find people who have a particular action on their record, then you need to set up a constituent query. Within the constituent query, you need to go all the way to the bottom of the criteria list and look for "summary infomration" and then look for "summary for actions" and then "total number of actions." This is basically a small action query that lives within a constituent query. In the "total number of actions" dialogue, your Criteria tab should probably have the operator of "greater than" and a value of "0." Then in your filter tab, you'll see all of the usual criteria related to action. So just like in the action query verison, you need to grab the set of parameters that make these actions unique.
Also, as to the debate about the Events module, I have it, but I could do without it. We use it for some things, but frankly it's just so slow and cumbersome that I wouldn't mind ditching it and creating workarounds for its features. But that's just me.2 -
Kathryn Hardi:
Thanks Gina and Jen!
We have the events module but when I started with the organization 3 months ago my supervisor said they were not going to keep the module when they renew in September because they had never used it. So I'm trying to figure out a way without the event module, but maybe if I can show her how we can start using it they might decide to keep the events module around!Our org once had the Events module and then dropped it, because it was seen as un-useful. We recently re-subscribed to it. Largely it depends on the types of events you have, how many events you hold, and how large they are. If all our events were like our 5K run or our Alumni reunion -- small, with 200 people or less, and no seating or overnight stays that WE have to track -- we probably would not have been interested in the Events module. However, for our larger dinner-auction, with more people and with individual seating and meal preferences, the Events module makes life so much easier!
The other thing that convinced us to take on the Events module was the fact that it integrates so well with OLX Events forms and saves us having to manually re-enter registrant information from online transactions. So if your org is considering OLX it might be worthwhile to keep the Events module, too.
1 -
I think this is also a good example of different ways that we use our systems -- we can be interested in functionality to help us perform certain tasks and evaluate usefulness based primarily on this, but there can also be an aspect of centralizing and retaining of the data so you can find it in the future, report out on it, analyze, predict future behaviour based on it, etc.
We happen to do a fair amount of analysis on our donors and their event attendance, and also pull those criteria into other queries for other events, mailings, etc. Having the event module to concisely store and be able to retrieve and query on this data is very useful for us.0 -
You may also want to look into creating action attributes and when you create your query you can filter on that specific action attribute.0
Categories
- All Categories
- Shannon parent
- shannon 2
- shannon 1
- 21 Advocacy DC Users Group
- 14 BBCRM PAG Discussions
- 89 High Education Program Advisory Group (HE PAG)
- 28 Luminate CRM DC Users Group
- 8 DC Luminate CRM Users Group
- Luminate PAG
- 5.9K Blackbaud Altru®
- 58 Blackbaud Award Management™ and Blackbaud Stewardship Management™
- 409 bbcon®
- 2.1K Blackbaud CRM™ and Blackbaud Internet Solutions™
- donorCentrics®
- 1.1K Blackbaud eTapestry®
- 2.8K Blackbaud Financial Edge NXT®
- 1.1K Blackbaud Grantmaking™
- 527 Education Management Solutions for Higher Education
- 1 JustGiving® from Blackbaud®
- 4.6K Education Management Solutions for K-12 Schools
- Blackbaud Luminate Online & Blackbaud TeamRaiser
- 16.4K Blackbaud Raiser's Edge NXT®
- 4.1K SKY Developer
- 547 ResearchPoint™
- 151 Blackbaud Tuition Management™
- 1 YourCause® from Blackbaud®
- 61 everydayhero
- 3 Campaign Ideas
- 58 General Discussion
- 115 Blackbaud ID
- 87 K-12 Blackbaud ID
- 6 Admin Console
- 949 Organizational Best Practices
- 353 The Tap (Just for Fun)
- 235 Blackbaud Community Feedback Forum
- 55 Admissions Event Management EAP
- 18 MobilePay Terminal + BBID Canada EAP
- 36 EAP for New Email Campaigns Experience in Blackbaud Luminate Online®
- 109 EAP for 360 Student Profile in Blackbaud Student Information System
- 41 EAP for Assessment Builder in Blackbaud Learning Management System™
- 9 Technical Preview for SKY API for Blackbaud CRM™ and Blackbaud Altru®
- 55 Community Advisory Group
- 46 Blackbaud Community Ideas
- 26 Blackbaud Community Challenges
- 7 Security Testing Forum
- 1.1K ARCHIVED FORUMS | Inactive and/or Completed EAPs
- 3 Blackbaud Staff Discussions
- 7.7K ARCHIVED FORUM CATEGORY [ID 304]
- 1 Blackbaud Partners Discussions
- 1 Blackbaud Giving Search™
- 35 EAP Student Assignment Details and Assignment Center
- 39 EAP Core - Roles and Tasks
- 59 Blackbaud Community All-Stars Discussions
- 20 Blackbaud Raiser's Edge NXT® Online Giving EAP
- Diocesan Blackbaud Raiser’s Edge NXT® User’s Group
- 2 Blackbaud Consultant’s Community
- 43 End of Term Grade Entry EAP
- 92 EAP for Query in Blackbaud Raiser's Edge NXT®
- 38 Standard Reports for Blackbaud Raiser's Edge NXT® EAP
- 12 Payments Assistant for Blackbaud Financial Edge NXT® EAP
- 6 Ask an All Star (Austen Brown)
- 8 Ask an All-Star Alex Wong (Blackbaud Raiser's Edge NXT®)
- 1 Ask an All-Star Alex Wong (Blackbaud Financial Edge NXT®)
- 6 Ask an All-Star (Christine Robertson)
- 21 Ask an Expert (Anthony Gallo)
- Blackbaud Francophone Group
- 22 Ask an Expert (David Springer)
- 4 Raiser's Edge NXT PowerUp Challenge #1 (Query)
- 6 Ask an All-Star Sunshine Reinken Watson and Carlene Johnson
- 4 Raiser's Edge NXT PowerUp Challenge: Events
- 14 Ask an All-Star (Elizabeth Johnson)
- 7 Ask an Expert (Stephen Churchill)
- 2025 ARCHIVED FORUM POSTS
- 322 ARCHIVED | Financial Edge® Tips and Tricks
- 164 ARCHIVED | Raiser's Edge® Blog
- 300 ARCHIVED | Raiser's Edge® Blog
- 441 ARCHIVED | Blackbaud Altru® Tips and Tricks
- 66 ARCHIVED | Blackbaud NetCommunity™ Blog
- 211 ARCHIVED | Blackbaud Target Analytics® Tips and Tricks
- 47 Blackbaud CRM Higher Ed Product Advisory Group (HE PAG)
- Luminate CRM DC Users Group
- 225 ARCHIVED | Blackbaud eTapestry® Tips and Tricks
- 1 Blackbaud eTapestry® Know How Blog
- 19 Blackbaud CRM Product Advisory Group (BBCRM PAG)
- 1 Blackbaud K-12 Education Solutions™ Blog
- 280 ARCHIVED | Mixed Community Announcements
- 3 ARCHIVED | Blackbaud Corporations™ & Blackbaud Foundations™ Hosting Status
- 1 npEngage
- 24 ARCHIVED | K-12 Announcements
- 15 ARCHIVED | FIMS Host*Net Hosting Status
- 23 ARCHIVED | Blackbaud Outcomes & Online Applications (IGAM) Hosting Status
- 22 ARCHIVED | Blackbaud DonorCentral Hosting Status
- 14 ARCHIVED | Blackbaud Grantmaking™ UK Hosting Status
- 117 ARCHIVED | Blackbaud CRM™ and Blackbaud Internet Solutions™ Announcements
- 50 Blackbaud NetCommunity™ Blog
- 169 ARCHIVED | Blackbaud Grantmaking™ Tips and Tricks
- Advocacy DC Users Group
- 718 Community News
- Blackbaud Altru® Hosting Status
- 104 ARCHIVED | Member Spotlight
- 145 ARCHIVED | Hosting Blog
- 149 JustGiving® from Blackbaud® Blog
- 97 ARCHIVED | bbcon® Blogs
- 19 ARCHIVED | Blackbaud Luminate CRM™ Announcements
- 161 Luminate Advocacy News
- 187 Organizational Best Practices Blog
- 67 everydayhero Blog
- 52 Blackbaud SKY® Reporting Announcements
- 17 ARCHIVED | Blackbaud SKY® Reporting for K-12 Announcements
- 3 Luminate Online Product Advisory Group (LO PAG)
- 81 ARCHIVED | JustGiving® from Blackbaud® Tips and Tricks
- 1 ARCHIVED | K-12 Conference Blog
- Blackbaud Church Management™ Announcements
- ARCHIVED | Blackbaud Award Management™ and Blackbaud Stewardship Management™ Announcements
- 1 Blackbaud Peer-to-Peer Fundraising™, Powered by JustGiving® Blogs
- 39 Tips, Tricks, and Timesavers!
- 56 Blackbaud Church Management™ Resources
- 154 Blackbaud Church Management™ Announcements
- 1 ARCHIVED | Blackbaud Church Management™ Tips and Tricks
- 11 ARCHIVED | Blackbaud Higher Education Solutions™ Announcements
- 7 ARCHIVED | Blackbaud Guided Fundraising™ Blog
- 2 Blackbaud Fundraiser Performance Management™ Blog
- 9 Foundations Events and Content
- 14 ARCHIVED | Blog Posts
- 2 ARCHIVED | Blackbaud FIMS™ Announcement and Tips
- 59 Blackbaud Partner Announcements
- 10 ARCHIVED | Blackbaud Impact Edge™ EAP Blogs
- 1 Community Help Blogs
- Diocesan Blackbaud Raiser’s Edge NXT® Users' Group
- Blackbaud Consultant’s Community
- Blackbaud Francophone Group
- 1 BLOG ARCHIVE CATEGORY
- Blackbaud Community™ Discussions
- 8.3K Blackbaud Luminate Online® & Blackbaud TeamRaiser® Discussions
- 5.7K Jobs Board