https://legacy.forums.gravityhelp.com/topic/custom-queries-in-notification-message Gravity Support Forums Topic: custom queries in notification message en-US Sun, 19 Apr 2026 14:52:46 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/custom-queries-in-notification-message#post-7697 Fri, 23 Jul 2010 09:00:06 +0000 David Smith 7697@https://legacy.forums.gravityhelp.com/ <p>Hey Mex,</p> <p>You're probably going to want to use the <strong>gform_pre_submission_filter</strong> filter. This filter runs after the entry has been validated, but before the entry is saved to the database.</p> <p>The form object is passed as an array to this function, but you can modify the entry values as well by adding/updating the $_POST array. This would be an ideal place to query your database for the voucher code and then (building on Carl's suggestion) add a value to the $_POST that corresponds with the id of the hidden field. When the form is saved (and emailed to the user) the field will be populated for you. </p> https://legacy.forums.gravityhelp.com/topic/custom-queries-in-notification-message#post-7640 Wed, 21 Jul 2010 15:22:04 +0000 Mexx 7640@https://legacy.forums.gravityhelp.com/ <p>Hey Carl,</p> <p>can I accomplish this with these hooks?</p> <p><a href="http://www.gravityhelp.com/documentation/hooks-and-filters/" rel="nofollow">http://www.gravityhelp.com/documentation/hooks-and-filters/</a></p> <p>thanks, Max </p> https://legacy.forums.gravityhelp.com/topic/custom-queries-in-notification-message#post-7610 Tue, 20 Jul 2010 16:31:32 +0000 Mexx 7610@https://legacy.forums.gravityhelp.com/ <p>Hi Carl,</p> <p>thanks for that very quick respond. That sounds like a good solution.<br /> I'm quite comfortable with PHP but not with API hooks.</p> <p>Its probably some PHP thats resides in the function.php of my theme I guess.<br /> But I haven't developed a plugin yet and therefore haven't done any WP API stuff.<br /> I guess I could read a bit through Codex and figure out how to add a hook.<br /> But then, how do I address that Gravity input field from that hook?</p> <p>If you could provide me with some code, that would be nice.</p> <p>thanks, Max </p> https://legacy.forums.gravityhelp.com/topic/custom-queries-in-notification-message#post-7599 Tue, 20 Jul 2010 13:26:56 +0000 Carl Hancock 7599@https://legacy.forums.gravityhelp.com/ <p>The Notification to User message body won't support a query or PHP code. </p> <p>Probably the easiest way to accomplish this would be to use a hidden field in your form that would represent the voucher code. Then use a PHP hook to populate that hidden field with the voucher code that you query from your custom table when the form is submitted.</p> <p>Then in your notification email you can just output the value of that hidden form field that would contain the voucher code.</p> <p>How comfortable are you with PHP and API hooks? </p> https://legacy.forums.gravityhelp.com/topic/custom-queries-in-notification-message#post-7596 Tue, 20 Jul 2010 12:56:46 +0000 Mexx 7596@https://legacy.forums.gravityhelp.com/ <p>Hey,</p> <p>I have a gravityform for my users to order voucher codes with. I store the voucher codes in a separate table of my wordpress DB. When a user submits the form, there should be an email immediately send to them with a code in it. I could use another plugin for that or write an own solution, but then the form does not feel, look and behave the same way other forms on my website do. Also the form data does not get stores in Gravaty's statistic.</p> <p>I tried to put a SQL query in the message box of "Notification to User". But this code is not executed and just printed out: </p> <pre><code>&lt;?php $sq = &quot;SELECT code FROM vouchers WHERE used&lt;&gt;&#39;yes&#39; LIMIT 1&quot;; $query = mysql_query($sq); $dsatz = mysql_fetch_assoc($query); echo $dsatz[&#39;code&#39;]; ?&gt;</code></pre> <p>I tried to find and hack the place in the plugin files where this codes gets escaped. Couldn't find it.<br /> Can you point me to that place and give me a hint how to archive that?</p> <p>thanks, Max </p>