Pre-Render and Single Line Text / Name

I'm trying to pre-render info into a single line text input with a field['id'] of 2 - I can pre-render the label and description just fine, but I can't get my variable to show up in the single line input text box!
I've tried "value", "input".. what am I missing?

// Loop through the fields and look for the single line text with field id of "2"
foreach($form["fields"] as &$field)
     if($field["id"] == 2)
     {
        $field["label"] = "This is the Label";                // Pre-Render the field label
	$field["value"] = "This is the value";                // Pre-Render the field value
	$field["description"] = "This is the Description";    // Pre-Render the field description
     }

Chris,

Thanks for the explanation, but..

I'm pulling data out of Form 1 to pre-populate fields in Form 2 using custom MySQL queries to the wp_rg_lead_detail table utilizing $_POST['form_id'] and $_POST['lead_id'] passed through the URL to get the info I need.

I see how your explanation works to get hard-coded data to pre-render, but would you still suggest this strategy of adding filters and do the my_sql query with-in the filter functions for each field I need to populate in form 2?

Thanks!

Hi Chris,

Thanks for the prompt reply.

I can populate a single line text input on my form with a hardcoded message - no problem.

But what I need to do is a database lookup to get some form inputs out of Form 1, then populate some form fields in Form 2.

Here is my code, but this isn't populating anything when I return $my_field. Can you point out anything I'm doing wrong?

Thanks a ton!

Code:
http://pastebin.com/dAyDtHFm

Chris,

Thanks for the suggestion - 1.3 was changed to '1.3', and the checkbox for "allow field to be populated dynamically" is checked and the parameter name singlelinetext is used (w no quotes).. but it didn't make any difference. Do you see anything else in the code that is wonky?

Thanks!

I think you're right Chris, but I can't seem to fix it.. I added a couple of counter variables that increment as I go through the iteration, and it appears $field["field_number"] has no values..

Here is the var_dump($form_data):
http://pastebin.com/GJuGcG77

And here is a link to the code that contains the filter to populate the singlelinetext input box on one of my forms (and the var_dump above):
http://pastebin.com/MMguScMU

When I var_dump or print_r, I see that I have the correct record I'm looking for, but how the heck do i access the data once I have the right record??

Chris,

I tried as you suggested, but changing it to
'foreach($form_data as &$field)'
breaks the script.

Hi Chris,

I wound starting over with this and now it works like a top. I'll include the code so other people can use the the solution I worked out last night.

As a summary, I'm using the gform_field_value_$parameter_name filter as you suggested. The documentation is here:
http://www.gravityhelp.com/documentation/page/Gform_field_value_$parameter_name

I'm doing custom MySQL queries to the wp_rg_lead_detail table to get data out of a form that's been previously submitted (Form 1), then populating that data into a new form (Form 2).

The following code pulls the cell phone number out of Form 1, and dynamically populated the cell phone input box in Form 2.
Key things to remember:
1) you must change the following code to reflect your form number.
2) you must enable the "Allow field to be populated dynamically" under the Admin tab on the form input you want to populate.
3) you must use "cellphone" (with out quotes) as the dynamic population parameter.

<?php

	add_filter("gform_field_value_cellphone", "populate_cellphone");
	function populate_cellphone($value) {
		global $wpdb;
		// Change this to be the number of the form you're using
		$form_id = 1;
		// Do a direct MySQL lookup based on the entry_id you need
		$sql = "
			SELECT
				ld.lead_id,
				ld.field_number,
				ld.value
			FROM
				wp_rg_lead_detail ld
				INNER JOIN wp_rg_lead l ON ld.lead_id = l.id
			WHERE
				ld.form_id = %d AND lead_id = '".$_REQUEST['entry_id']."'
			ORDER BY
				ld.lead_id,
				ld.field_number
		";
		$sql = $wpdb->prepare($sql,$form_id);
		$results = $wpdb->get_results($sql, ARRAY_A);
		$form_answers = array();
		foreach($results as $row) {
			$row = (object)$row;
			$major_num = (int)$row->field_number;
			$minor_num = (int)(($row->field_number-$major_num)*10);
			$form_answers[$row->lead_id][$major_num][$minor_num] = $row->value;
		}
		// Iterate through the array of data pulled from the dB
		foreach($form_answers as $i => $lead) {
			foreach($lead as $j => $form_answer) {
				$form_answers[$i][$j] = implode(' ',$form_answer);
			}
		}
		// DUMP the variables to see what's in the array
		// Uncomment the line containing print_r below to see everything
		// that's pulled from the MySQL Query. This will show you the correct
		// position for the data you're looking for
		//echo '<pre>'; print_r($form_answers); echo '</pre>';

		$my_lead_id = $_REQUEST['entry_id'];

		// Return the requested variable - note, 14 is the position of the
		// cell phone number in the array of data pulled from the dB
		return $form_answers[$my_lead_id]['14'];
	}
?>