Multiple tributes on gifts

Suzanne Pasch 4

We have the Tribute module. It's now Annual Report time and I'm finding people have been entering multiple tributes per gift--up to 10 in some cases. My old procedure to pull out IMO/IHO listing was a gift export, but with 10 on one gift row that's going to prove a manual formatting challenge. Does anyone know a trick to get a row per each tribute on a gift?

Alex Wong

@Suzanne Pasch
if you want a row per tribute, you can use gift query to export, as long as you pay attention to what you filter/output/sort and not use other “1-many” field, you will be ok (i.e. campaign, fund, appeal, etc).

As I am not sure what your goal is here with the “excel file” you will want to be careful that having multiple row for each tribute will “double/triple” count your gift amount.

Suzanne Pasch 4

@Alex Wong Thank you! It's just a listing for the Annual Report, no dollar amounts, thankfully. I ended up exporting a canned Tribute listing report for the time period and doing some formatting.