https://legacy.forums.gravityhelp.com/topic/populating-form-with-data-from-second-database Gravity Support Forums Topic: Populating form with data from second database en-US Mon, 20 Apr 2026 06:32:26 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/populating-form-with-data-from-second-database#post-35795 Tue, 20 Sep 2011 18:06:39 +0000 David Smith 35795@https://legacy.forums.gravityhelp.com/ <p>Hi WizardGuy,</p> <p>Might be easier to add the filters dynamically using the gform_pre_render function. Here is some sample code:</p> <p><a href="http://pastie.org/2565423" rel="nofollow">http://pastie.org/2565423</a> </p> https://legacy.forums.gravityhelp.com/topic/populating-form-with-data-from-second-database#post-35451 Thu, 15 Sep 2011 18:06:41 +0000 TheWizardGuy 35451@https://legacy.forums.gravityhelp.com/ <p>So the steps are:</p> <p>1) Go to form design and check off "Allow field to be populated dynamically".<br /> 2) Give the field a unique parameter name (unique for all forms). For example, if the field name is "fname" (first name) the parameter might be "pfname".<br /> 3) Add a filter in functions.php<br /> <code>add_filter(&quot;gform_field_value_pfnam&quot;, &quot;populate_pfname&quot;)</code><br /> <code>function populate_pfname($value)</code><br /> <code>return [some code here to figure out what the first name is]</code><br /> <code>}</code></p> <p>4 And rinse and repeat 17 more times for the rest of the fields in the form, changing the parameter name and the function name each time. You have to "hard code" all of the parameter names and popluate_whatever functions.</p> <p>Is there some way to grab all 18 fields once, stuff 'em in an array and then pass the array along to the 18 add_fitler's?</p> <p>Not as confused, but still in Thornhill,</p> <p>Lawrence </p> https://legacy.forums.gravityhelp.com/topic/populating-form-with-data-from-second-database#post-35440 Thu, 15 Sep 2011 17:17:30 +0000 Carl Hancock 35440@https://legacy.forums.gravityhelp.com/ <p>If you are trying to populate fields dynamically there is a tutorial on how to do so here:</p> <p><a href="http://www.gravityhelp.com/documentation/page/Using_Dynamic_Population" rel="nofollow">http://www.gravityhelp.com/documentation/page/Using_Dynamic_Population</a> </p> https://legacy.forums.gravityhelp.com/topic/populating-form-with-data-from-second-database#post-35436 Thu, 15 Sep 2011 16:57:47 +0000 TheWizardGuy 35436@https://legacy.forums.gravityhelp.com/ <p>Ihave successfully used the code in the discussion "Grabbing $_POST to simulanteously store in a second database" (<a href="http://www.gravityhelp.com/forums/topic/filling-gform_field_value-with-values-using-post" rel="nofollow">http://www.gravityhelp.com/forums/topic/filling-gform_field_value-with-values-using-post</a>) to take user input into a form and create a row in an external MySQL table (thanks to all who participated--it works like a dream!)</p> <p>But now I have to go the other way--pull a row from that database and populate a Gravity Form so that association members can change their data (and then post it back..which just repeats the stuff in the paragraph above).</p> <p>I can query the database and retrieve the record just fine, but for the life of me I can't figure out the next step or which hook to use (gform_pre_render or gform_field_value.) </p> <p>If I have 18 fields to fill, do I need 18 separate gform_field_value functions?</p> <p>(And last but not least, are the gform_field_value functions defined as part of the gform_pre_render or as separate functions? If so, how do they know which form's fields to fill in?)</p> <p>Confused in Thornhill,</p> <p>Lawrence </p>