Capture infomation from user daily summarize it monthly

I don't have a url to share because I haven't created the form yet.

I'm building a membership site for a client who needs their members to visit a page each day to do a quick check in. The check-in has them answer a series of questions by checking 5-6 check boxes. At the end of the month we want to generate a report that summarizes the answers from the checkboxes. Obvously the data has to be linked to the mmeber's WP user id.

In addition each member is to check in monthly by entering a number in one field and some text in 3-4 text fields. We need to display that data on the daily check-in page through out the month.

Before I get too far down the road I thought I'd ask if Gravity Forms is a good application to capture the data? I've been using GF for several months but only to create simple forms. I'd like to use it for this application if it's a good fit.

Hopefully this is enough information.

Thank you very much.

Bob

David,

Thanks for the quick reply. After I wrote the post I looked through the database tables of a site with several GFs and see that it will do what I want. One thing I need to figure out how to capture the WP user id in the background. Do you have any links for this?

Bob

Thanks David. I see why they gave you that crown.

Bob

Your basic database query is going to look something like this:

function get_field_value($field_id, $entry_id){
global $wpdb;

$value = $wpdb->get_var("SELECT value FROM wp_rg_lead_detail WHERE lead_id = $entry_id AND field_number = $field_id");

return $value;
}

echo get_field_value(4, 12);

In this example, it assumes you know the users entry ID (12) and the field ID (4) of the value you want to retrieve.

At this point in the game, you're going to want to get comfortable with the Gravity Forms table structure so take a peek in wp_rg_lead_detail and you'll see what information is available to you ( http://grab.by/8BoN ).