Query Leads from Gravity Forms

“Gravity Forms for WordPress is a full featured contact form plugin that features a drag and drop interface, advanced notification routing, lead capture, conditional logic fields, multi-page forms, pricing calculations and the ability to create posts from external forms.”

There are multiple options how to handle the confirmation page. Gravity form allows you to send query parameters to the page it is redirecting to.

You can send all form information in the clear, via query variables, but that looks really messy. Its better to use something like this .. lead_id={entry_id}  and query form information on the actual confirmation page.

GET THE LEAD

This will output the submitted form data as an array, with all fields linked by field id.

$lead_id = intval( $_GET['lead_id'] );
$lead = RGFormsModel::get_lead($lead_id);

TRANSLATE FIELD IDS TO FIELD LABELS

When you are reusing the field data for your own purposes, its easier to deal with field  names than with fields ids. So we get the form meta data

$form = RGFormsModel::get_form_meta( $lead['form_id'] );

foreach( $form['fields'] as $field ) {

 $values[$field['id']] = array(
        'id'    => $field['id'],
        'label' => $field['label'],
        'value' => $lead[ $field['id'] ],
 );
}

and extend the lead array.

foreach($lead as $key => $val){
 if(is_numeric($key)){
  $lead_key = str_replace(" ", "_", strtolower($values[$key]['label']));
  $lead[$lead_key] = $val;	
 }
}

Before you needed to know the actual field id to get its value. Now you can use the generated lead key to get that value.

BEFORE

$field_key = 10;
echo $lead[$field_key];

AFTER

$field_key = "e-mail";
echo $lead[$field_key];

Much easier to reuse and remember :)

Enjoy coding ….