I'm trying to analyze gift data using SQL. I can't find how Raiser's Edge relates the GIFT table to the FUND table. There isn't a FUND_ID field in the GIFT table, nor a join table, such as GIFT_FUND. I'd think I should be able to run a very simple query such as SELECT [fields] from GIFT g JOIN FUND f ON g.FUND_ID = f.ID or…
Hello, I've been working in RENXT for 3.5 years now with the nonprofit I am employed at. I'm considering attending bbcon this fall for the first time. Before I purchase the tickets I wanted to get opinions on the best takeaways and/or recommendations for this. Its obviously a huge investment. Not only for the pass to…
Our organization has not collected birthdays. We are thinking about how to segment our fundraising efforts to target different demographics with different efforts. Has anyone ever heard of a service that can find and append birthdates to records? I'm thinking of something along the lines of emailfinder but for dates. Do…
Is there any way to EXCLUDE certain constituents (by Constituent Code or some other criteria) in the Work Center overview page? Our fundraiser portfolios include normal constituents to be tracked, but also some “special” constituents who are treated differently and whose numbers shouldn't be counted toward a fundraiser's…
We currently have 4 schools utilizing the same RENXT system, because we are one organization. Is there a way to separate/clean up/organize constituents so each school can appropriately find their constituents or have them in one place to make it easier to pull reports? Is constituent code the best way? Any help is…
Hi, I signed up for this but didn't get a chance to see it “live”, so I just watched the replay. Intent of this post is to help those that may be thinking the same question as I have previously got asked before.. do i need paranthesis? I thought it would be best if the session actually went into a query that NEED to use…
I'm sure this feature is still in progress, but does anyone currently have the capability to include inactive record types in web view query? For instance, I was trying to build a list of individuals who had certain assigned appeals on their records. All of the appeals were marked inactive in the system; therefore, I had…
I'm new to RE after using a custom Advance CMR for years. I'm currently enrolled in what feels like all the BB training but I need help creating an all-inclusive major & leadership donor and prospect list from the past 15 years that's time sensitive. Would someone be able to help me figure out how to arrange the fields,…
We have been recording volunteer information in the volunteer tab of RE7 for years, and we are mainly recording; * the department that was volunteered for * the volunteer category * volunteer task * volunteer type * start / end dates. Outside of that we are not really recording much further detail, which we are keen to…
I am looking to integrate with Raisers edge NXT and wanted to see if there is any way that I can get to know which form was used for a Gift record. I am not able to find any form id or anything in the Gift record that I am fetching from Get Gifts API
It looks like you're new here. Sign in or register to get started.