Create new query field called "Second-to-last-gift"

Currently in query and export, there exists a field for Last Gift. Sometimes at our organization, the last gift isn't necessarily helpful (i.e. Gift-In-Kind, Event Ticket, etc.) when we're specifically looking for general donations. It would be helpful if there was a selection of fields for "Second-to-last-gift". Sage had this feature and we miss it!
Thanks for considering our idea!

  • Guest
  • May 22 2014
  • Attach files
  • Guest commented
    March 18, 2016 00:46

    You can pull more than just the last gift using export.

    Instead of "last gift", select "gifts". You can specify the number to export and also sort them in either ascending or descending order on the "general" tab. If you also exclude Gifts in Kind on the Gift Types tab, and event tickets however they are coded (you can use filters and queries for your Campaigns, Funds, and Appeals on one of the tabs), you should be able to refine this information pretty easily.

    Maybe that helps?

    Attachments Open full size

Related ideas