Member Directory

I had purchased this plugin because I thought it would be a good way to create a member profile - by creating a form that they could complete all the necessary information to be displayed on the profile - granted it would not be tied to the user profile in the database it would allow for members information to be displayed to the network, would be easy to complete, and could be edited easy - BUT -- I have had a terrible time trying to get this plugin figured out -- I can't get forms to post and I'm not sure how to create the custom template. I have a custom template that has worked using tdo min forms - but I really don't care for the clunkiness of that plugin and would really like to figure out how to do this with gravity forms. Any suggestions?

Newport - I would love any help I could get on this. I think what you have done would work for me, but I still want to be able to understand how to use this plugin per the features highlighted - so that is why I also posted the reply to Carl. Thank you so much for your help!

I'm having the same issue as erueschhoff. I think that what we're both attempting to do is to pull the submitted form information from the database and display it within a page. Each page would show the details that the visitor submitted: Business Name, Telephone, etc. I don't want a new post for every entry, rather would prefer that I can query the database and display the fields I want.

It's basically a public view of the Gravity Forms 'Entries' for a specific form.

Can you offer any further insight such as what database table(s) to look in? I'm good with PHP, and learning SQL, so any info/tutorials/resources, etc. will be very helpful.

You guys are looking to do exactly what I just did. Here's the quick rundown.

Gravity Forms stores form entries as field number = field value. Each entry also includes the form number. There isn't an easy way to work with that unless you make a chart of your field numbers and what they represent. As in, field 5 = email address; field 6 = work phone number; etc. When you have that, you can simply query the Gravity Form table to display your info. on the front end using INNER JOINs. But that does get pretty tedious.

What I did was make a plugin that sets up some new tables -- members, member_meta, etc -- and then uses the post_submission hook to call up a function that adds members to those tables. Then I can easily work with them. So right now I have a table with the standard gravity forms entries and completely separate tables that have the same info. as the forms (initially, anyhow) which are what I then work with.

If you want to just do simple lists of info. from your forms, a great work around is to install the Shortcode Exec PHP plugin. That lets you create a short code from the backend and stick whatever code you want as the shortcode's action. So if you want to get a list of names and email addresses from a form, you can use the plugin to make a new short code. In the dashboard you just the text you want to use for the shortcode, like 'my-list' and below that you get a WYSIWYG box where you can enter the php code to display the list. As an example: If you have a form whose ID is 1 and two fields you want to display, a name field with ids 3.3 for first name and 3.6 for last name, and an email address field with id 5, then you could paste the following.

global $wpdb;
$results = $wpdb->get_results("SELECT f.id, f1.value as first_name, f2.value as last_name, f3.value as email FROM ".$wpdb->prefix."rg_lead as f INNER JOIN ".$wpdb->prefix."rg_lead_detail  as f1 ON (f.id = f1.lead_id AND f1.field_number = '3.3') INNER JOIN ".$wpdb->prefix."rg_lead_detail  as f2 ON (f.id = f2.lead_id AND f2.field_number = '3.6') INNER JOIN ".$wpdb->prefix."rg_lead_detail  as f3 ON (f.id = f3.lead_id AND f3.field_number = '5') WHERE f.form_id = '1');
foreach ($results as $result){
echo "Name: ".$result['first_name']." ".$result['last_name']."";
echo "Email: ".$result['email']."------------";
}

Then you can use your new shortcode [my-list] in your pages and posts.

For each form field you want to display, just do another INNER JOIN. At the start of the sql statement you're listing all of the fields you want returned and using aliases so that you can easily access them. So if you had another field, age, you could add f4.value as age and then another INNER JOIN ".$wpdb->prefix."rg_lead_detail as f4 ON (f.id = f4.lead_id AND f4.field_number = '6') -- making sure to change the field_number to whatever corresponds to your age field.

I'm trying to implement Newport's SQL solution above to pull out some form data and display it on a page using Shortcode EXEC PHP. I keep getting an error that says I need to use return instead of echo. I changed the echos to returns, but I still get the error. Here's my code:

global $wpdb;
$results = $wpdb->get_results("SELECT f.id, f1.value as first_name, f2.value as last_name, f3.value as city, f4.value as state, FROM ".$wpdb->wp."rg_lead as f INNER JOIN ".$wpdb->wp."rg_lead_detail  as f1 ON (f.id = f1.lead_id AND f1.field_number = '1') INNER JOIN ".$wpdb->wp."rg_lead_detail  as f2 ON (f.id = f2.lead_id AND f2.field_number = '2') INNER JOIN ".$wpdb->wp."rg_lead_detail  as f3 ON (f.id = f3.lead_id AND f3.field_number = '3') INNER JOIN ".$wpdb->wp."rg_lead_detail  as f4 ON (f.id = f4.lead_id AND f4.field_number = '4') WHERE f.form_id = '4');
foreach ($results as $result){
return .$result['first_name']." ".$result['last_name']."";
return .$result['city']." ".$result['state']."------------";
}

Any ideas on how to fix this issue?

Thanks in advance,
-Gary