I am using the Paypal add-on, and my site sells these two items:
1 - A competition entry fee
2 - A competition shirt
I have three forms, which do the following:
A - Pay the entry fee and optionally buy a shirt
B - Buy a shirt only
C - Does the same as form A, but non-Paypal (e.g., a manual bank deposit; purchaser provides the detail via the web site, and an admin manually updates the entry when the bank deposit is made).
What I need to do is to provide the following reports:
* - List of people who paid the entry fee (via both forms A and C)
* - List of people who purchased a shirt (via forms A, B and C)
The standard export isn't an option in this case; these reports are pretty specific, and need to be available on demand.
I've looked through the database, and have worked out the mapping of the form data in the wp_rg_lead_detail table. The SQL statements are going to horrible.
My question is this, what would you recommend as the best way of extracting this data out of the GF tables? I'll probably implement the export as a plugin with an admin panel. Is there a function with GF that can help me get the data I'm after quicker than just using SQL.
Cheers, and thanks for the great product.