Gift ID for Searching

Lisa Whatley · May 2022

Does anyone know a way to search for a gift by gift ID in database view?

Mark Guncheon · May 2022

Create a query and enter it as the criteria. Certainly not as easy as searching for a constituent but it will get the job done.

JoAnn Strommen · May 2022

I need to do this frequently. Gift query less clicks than in a constituent query but either works pretty easy. (Gift ID is an option in the Gift fields)

Lisa Whatley · May 2022

We use a gift query today, but I was hoping for a hidden gem.

Austen Brown · May 2022

Gift query is the way to go. No hidden gems unfortunately.

Alan French · May 2022

I've always found it odd that Gift ID is not an available field on the ‘open a gift’ search form - you'd think ID number would be an essential for any kind of search... luckily you can get around it though:

create a gift query with the criterion “Gift ID <ask>”
go to the ‘open a gift’ search form
click on the binoculars next to “search using query” (at the top)
select your query

Now every time you run a gift search, it will prompt you for a gift ID to look for. You'll also need to enter something in one of the other search fields before it'll let you click the ‘find now’ button, but you can just shove a * wildcard in the surname field or something.

Gift ID for Searching

Comments

Categories