Gravity Support Forums Topic: Pre-Render and Single Line Text / Name

Gravity Support Forums Topic: Pre-Render and Single Line Text / Name https://legacy.forums.gravityhelp.com/topic/pre-render-and-single-line-text-name Gravity Support Forums Topic: Pre-Render and Single Line Text / Name en-US Mon, 20 Apr 2026 01:13:02 +0000 http://bbpress.org/?v=1.0.1 <![CDATA[Search]]> q https://legacy.forums.gravityhelp.com/search.php Chris Hajer on "Pre-Render and Single Line Text / Name" https://legacy.forums.gravityhelp.com/topic/pre-render-and-single-line-text-name#post-109182 Thu, 27 Dec 2012 15:53:39 +0000 Chris Hajer 109182@https://legacy.forums.gravityhelp.com/ Thank you for posting your solution. SomethingSeven on "Pre-Render and Single Line Text / Name" https://legacy.forums.gravityhelp.com/topic/pre-render-and-single-line-text-name#post-109104 Thu, 27 Dec 2012 11:59:08 +0000 SomethingSeven 109104@https://legacy.forums.gravityhelp.com/ 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: <a href="http://www.gravityhelp.com/documentation/page/Gform_field_value_$parameter_name" rel="nofollow">http://www.gravityhelp.com/documentation/page/Gform_field_value_$parameter_name</a> 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. <pre><code><?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']; } ?></code></pre> Chris Hajer on "Pre-Render and Single Line Text / Name" https://legacy.forums.gravityhelp.com/topic/pre-render-and-single-line-text-name#post-108555 Wed, 26 Dec 2012 18:44:10 +0000 Chris Hajer 108555@https://legacy.forums.gravityhelp.com/ What is the error which shows up? I don't think I can help any more from here. Is this a live site or can I log in and take a look at the code you have and the data and form that you have? If I can log in to this site, please send me at WordPress administrator login to <a href="mailto:chris@rocketgenius.com">chris@rocketgenius.com</a> - thank you. SomethingSeven on "Pre-Render and Single Line Text / Name" https://legacy.forums.gravityhelp.com/topic/pre-render-and-single-line-text-name#post-108553 Wed, 26 Dec 2012 18:35:53 +0000 SomethingSeven 108553@https://legacy.forums.gravityhelp.com/ Chris, I tried as you suggested, but changing it to 'foreach($form_data as &$field)' breaks the script. Chris Hajer on "Pre-Render and Single Line Text / Name" https://legacy.forums.gravityhelp.com/topic/pre-render-and-single-line-text-name#post-108548 Wed, 26 Dec 2012 18:24:50 +0000 Chris Hajer 108548@https://legacy.forums.gravityhelp.com/ It's hard to guess without having the code, the data and the form, but I think we're getting closer. Can you change line 11 in your last example FROM this: <pre><code>foreach($form_data["fields"] as &$field)</code></pre> to this: <pre><code>foreach($form_data as &$field)</code></pre> I'm not sure why "fields" was there. SomethingSeven on "Pre-Render and Single Line Text / Name" https://legacy.forums.gravityhelp.com/topic/pre-render-and-single-line-text-name#post-108534 Wed, 26 Dec 2012 17:34:16 +0000 SomethingSeven 108534@https://legacy.forums.gravityhelp.com/ 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): <a href="http://pastebin.com/GJuGcG77" rel="nofollow">http://pastebin.com/GJuGcG77</a> 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): <a href="http://pastebin.com/MMguScMU" rel="nofollow">http://pastebin.com/MMguScMU</a> 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 Hajer on "Pre-Render and Single Line Text / Name" https://legacy.forums.gravityhelp.com/topic/pre-render-and-single-line-text-name#post-108520 Wed, 26 Dec 2012 16:47:52 +0000 Chris Hajer 108520@https://legacy.forums.gravityhelp.com/ Also on line 13, I'm not sure you're iterating over the array correctly. Since you are doing foreach($form_data["fields"] as &$field), you would normally check each $field, not each $form_data['whatever']. I would be curious to see what $form_data looks like on line 10 (with var_dump or print_r). That might give us a clue to the correct way to get at the values. You could also echo the value of $form_data["field_number"] around line 12.5 (between line 12, and 13, outside the loop.) SomethingSeven on "Pre-Render and Single Line Text / Name" https://legacy.forums.gravityhelp.com/topic/pre-render-and-single-line-text-name#post-108512 Wed, 26 Dec 2012 16:30:31 +0000 SomethingSeven 108512@https://legacy.forums.gravityhelp.com/ 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! Chris Hajer on "Pre-Render and Single Line Text / Name" https://legacy.forums.gravityhelp.com/topic/pre-render-and-single-line-text-name#post-108506 Wed, 26 Dec 2012 16:19:58 +0000 Chris Hajer 108506@https://legacy.forums.gravityhelp.com/ I think on line 13 the 1.3 should be quoted, since it's a string. Like this: <pre><code>[php] if($form_data["field_number"] == '1.3')</code></pre> Also, be sure the field you want to populate is marked "allow field to be populated dynamically" and that this is the parameter name: 'singlelinetext' (without the quotes.) SomethingSeven on "Pre-Render and Single Line Text / Name" https://legacy.forums.gravityhelp.com/topic/pre-render-and-single-line-text-name#post-108463 Wed, 26 Dec 2012 15:25:48 +0000 SomethingSeven 108463@https://legacy.forums.gravityhelp.com/ 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: <a href="http://pastebin.com/dAyDtHFm" rel="nofollow">http://pastebin.com/dAyDtHFm</a>