PLEASE NOTE: These forums are no longer utilized and are provided as an archive for informational purposes only. All support issues will be handled via email using our support ticket system. For more detailed information on this change, please see this blog post.

Can the email routing come from a SQL table in the Notifcation to Administrator

  1. elawsoftware
    Member

    Is it possible to have the Send To Email Routing pull the necessary email addresses from a SQL table? I have hundreds of different customers and they only need to receive the form if its in their territory.

    Posted 14 years ago on Thursday May 20, 2010 | Permalink
  2. You can use a hook to do this but would have to write the custom PHP code yourself. If you can write the PHP, here is a thread that discusses how to do something similar only it sends the email to the author of the post:

    http://forum.gravityhelp.com/topic/sending-form-to-author-of-post

    From this thread you will be able to look at code snippets that do most of what you want to do, minus getting the email from a custom SQL table.

    Posted 14 years ago on Friday May 21, 2010 | Permalink
  3. elawsoftware
    Member

    Thanks. I modified the code was was able to set the email_to field to correct email addresses that are in my SQL table.

    Posted 14 years ago on Tuesday June 1, 2010 | Permalink