https://legacy.forums.gravityhelp.com/topic/dynamic-population-notification-strategy Gravity Support Forums Topic: Dynamic Population Notification Strategy ??? en-US Sat, 04 Apr 2026 18:29:45 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/dynamic-population-notification-strategy#post-33868 Mon, 29 Aug 2011 23:59:46 +0000 Chris Hajer 33868@https://legacy.forums.gravityhelp.com/ <p>Glad you figured it out. For the benefit of anyone following along, that code goes in functions.php in your theme:</p> <p><a href="http://www.gravityhelp.com/documentation/page/Where_Do_I_Put_This_Code%3F" rel="nofollow">http://www.gravityhelp.com/documentation/page/Where_Do_I_Put_This_Code%3F</a></p> <p>p.s. I changed the email addresses so you won't receive any submission notifications. </p> https://legacy.forums.gravityhelp.com/topic/dynamic-population-notification-strategy#post-33864 Mon, 29 Aug 2011 21:02:21 +0000 muhromatic 33864@https://legacy.forums.gravityhelp.com/ <p>Chris:</p> <p>It is all up and running... THANK YOU... </p> <p>I have always said that you guys rock... But...</p> <p>"Gravity Forms has the best support team in the industry. Period."</p> <p>Thanks Again, Glenn </p> https://legacy.forums.gravityhelp.com/topic/dynamic-population-notification-strategy#post-33859 Mon, 29 Aug 2011 19:06:07 +0000 muhromatic 33859@https://legacy.forums.gravityhelp.com/ <p>WOW... Unbelievable... Thank you so much...</p> <p>One "stupid" question... Exactly where do I drop this code once I modify it?</p> <p>Once again, Thanks a lot... </p> https://legacy.forums.gravityhelp.com/topic/dynamic-population-notification-strategy#post-33853 Mon, 29 Aug 2011 18:13:06 +0000 Chris Hajer 33853@https://legacy.forums.gravityhelp.com/ <p>Thanks for the email addresses. </p> <p>Here is a sample form:<br /> <a href="http://gravity.chrishajer.com/customer-survey/" rel="nofollow">http://gravity.chrishajer.com/customer-survey/</a></p> <p>Try submitting without an accountID and the results will be sent to the address that is set in the admin notification area (currently me.)</p> <p>Try submitting each of these:<br /> <a href="http://gravity.chrishajer.com/customer-survey/?accountID=123456789" rel="nofollow">http://gravity.chrishajer.com/customer-survey/?accountID=123456789</a><br /> <a href="http://gravity.chrishajer.com/customer-survey/?accountID=abc123" rel="nofollow">http://gravity.chrishajer.com/customer-survey/?accountID=abc123</a><br /> <a href="http://gravity.chrishajer.com/customer-survey/?accountID=555-1212" rel="nofollow">http://gravity.chrishajer.com/customer-survey/?accountID=555-1212</a></p> <p>The 123456789 will be sent to mac and the abc123 will be sent to the other. 555-1212 will fall back to the notification email in the admin settings. If no accountID is sent or the accountID is not found in the database, the email address from the admin notification settings will be used.</p> <p>You need to have a hidden field in your form with the "populate dynamically" box checked and the parameter name of "accountID" (case sensitive.)</p> <p>Here's the code <a href="http://pastebin.com/Rws5p0T5" rel="nofollow">http://pastebin.com/Rws5p0T5</a></p> <p>You will have to change the database connection details including the table name. You will have to change the form number (28 in my case) to your actual form number, and the $lead[4] to the actual field from your $lead (mine was form field #4). You will also have to change the field names in line 27 to your field names (the one that holds the accountID and the one that holds the email.)</p> <p>That should cover it. You might have some submission notifications from me already. After you check it out, I will change the email addresses so you don't continue to get notification of form submissions.</p> <p>Please ask if you need any additional help. </p> https://legacy.forums.gravityhelp.com/topic/dynamic-population-notification-strategy#post-33840 Mon, 29 Aug 2011 15:43:13 +0000 Chris Hajer 33840@https://legacy.forums.gravityhelp.com/ <p>Glenn, please send me an email at <a href="mailto:chris@rocketgenius.com">chris@rocketgenius.com</a> that contains a couple email addresses you own, so I can use those in the dynamic population and you can see it working. Otherwise, you'd submit my form and I would be getting all the notifications :-) Thanks. </p> https://legacy.forums.gravityhelp.com/topic/dynamic-population-notification-strategy#post-33790 Mon, 29 Aug 2011 12:13:03 +0000 muhromatic 33790@https://legacy.forums.gravityhelp.com/ <p>So, now that hurricane Irene is out of the way... I have some time to try an get this working... </p> <p>Any help with the code to get me started would be very much appreciated.</p> <p>I would like to be able to dynamically populate an "email field" from an existing sql table using the QUERY STRING to dynamically populate the "memberid field" which will be used to identify the proper row in the existing sql table. if that makes any sense at all...</p> <p>I understand the logic involved but I am clueless with the code...</p> <p>Thanks, Glenn </p> https://legacy.forums.gravityhelp.com/topic/dynamic-population-notification-strategy#post-33719 Sat, 27 Aug 2011 21:59:32 +0000 Chris Hajer 33719@https://legacy.forums.gravityhelp.com/ <blockquote><p>Question, could the email be pulled from and existing table that already contains both the email and accountID?</p></blockquote> <p>Yes</p> <p>And not a complicated implementation, but more than just a couple lines of code. (Not 50 though.) I think you will hook your function to the gform_notification_email hook. In your function you will read the parameter accountID from the query string, then pull the email associated with that from your database, and populate the notification email with that address. In your function you can deal with what happens when there is no match.</p> <p>It will not be too hard for someone familiar with Gravity Forms. You can find a current list of developers familiar with Gravity Forms here:</p> <p><a href="http://www.gravityhelp.com/forums/topic/help-customizing-gravity-form-image-upload-functionality#post-32767" rel="nofollow">http://www.gravityhelp.com/forums/topic/help-customizing-gravity-form-image-upload-functionality#post-32767</a> </p> https://legacy.forums.gravityhelp.com/topic/dynamic-population-notification-strategy#post-33712 Sat, 27 Aug 2011 16:17:53 +0000 muhromatic 33712@https://legacy.forums.gravityhelp.com/ <p>Chris:<br /> Cool... but... my programing skills are non-existent.</p> <p>I can create the "accountID" field and I can setup it's dynamic population via a QUERY STRING.</p> <p>then I veer off into the weeds... @#$%^&amp;^ ... and CRASH/BURN...</p> <p>Question, could the email be pulled from and existing table that already contains both the email and accountID?</p> <p>I use Digital Access Pass (DAP) ...</p> <p>I guess I am asking for help with the "hook" code to make this happen...</p> <p>Are we talking about a complicated implementation or a few lines of code?</p> <p>Any help/guidance would be appreciated.</p> <p>Also, I had posted this in a developers support ticket last night... Can you update that ticket with the above progress so as not to waste someones time walking me through the above.</p> <p>Thanks for your time,<br /> Glenn </p> https://legacy.forums.gravityhelp.com/topic/dynamic-population-notification-strategy#post-33705 Sat, 27 Aug 2011 14:38:12 +0000 Chris Hajer 33705@https://legacy.forums.gravityhelp.com/ <p>Please share more information. You didn't mention 100,000 members. Managing 100,000 conditionals would not work very well with AJAX in a browser.</p> <p>Now that we know it CAN be done, it's up to you to decide how to do it. You're going to have to use a hook (probably <strong>gform_notification_email</strong> to change the notification email address based on the value of the query string parameter accountID. That hook has access to the $FORM object so you can get the value of accountID. Then you just need to match that accountID with the email address. Maybe you have that stored in a MySQL database table somewhere, or a text file. You will need to write some code to return the proper email based on the value of accountID. It's all very doable with a bit of custom code.</p> <p><a href="http://www.gravityhelp.com/documentation/page/Gform_notification_email" rel="nofollow">http://www.gravityhelp.com/documentation/page/Gform_notification_email</a> </p> https://legacy.forums.gravityhelp.com/topic/dynamic-population-notification-strategy#post-33703 Sat, 27 Aug 2011 14:31:16 +0000 muhromatic 33703@https://legacy.forums.gravityhelp.com/ <p>Chris...</p> <p>So, is there a problem having 100,000 routing conditionals? OUCH... :o)</p> <p>would love to just be able to update a table... with search functions etc...</p> <p>Thanks, Glenn </p>