First Gift field in a Gift Export - does it exist?

Kevin Schaeffer

I've used the search function inside the export module so I'm guessing no, but can anyone confirm that “First Gift” data is not available to export in a Gift Export in RE7? I know that it is available using a constituent export, but I want to export gifts from the past 18 months and append each one with the constituent's first gift information. Thanks in advance.

Alex Wong

@Kevin Schaeffer
It doesn't exist as you already looked.

You can run the constituent query exporting first gift info, and then use XLOOKUP to get the first gift info from the constituent export into the gift report.

Kevin Schaeffer

@Alex Wong Thanks, yeah that's what I was already leaning towards. Will have to tackle it in excel using two separate files.