Can CMS integrate with email forms?

Hi Meg,

Do you mean you want to save the contents of an email form to the database?

If so, you can do this by writing a custom SQL INSERT statement. For an example of this, see here:

http://www.interactivetools.com/forum/gforum.cgi?post=91178#91178

Hope this helps

Hi Meg,

Don't know if this idea works for you, but my approach has always been to link to an on-line survey form in the email and not to try to handle the survey directly from the email.

It's pretty easy to set up forms that automatically populate records in the database, (like in the post Jason mentioned), you can even do some math and tabulate results that feed back to the email recipients.

My concern is always the security issues surrounding anyone being able to send/update data in the on-line database.

I've used CAPTCHA, but this too is not a perfect solution, so I've usually restricted form submission to registered users only, using the membership plugin, and that worked for my situations.

Once you've resolved these issues, there are some recipes in my CMSB Cookbook thecmsbcookbook.com, mostly in the "USING THE WEBSITE MEMBERSHIP PLUGIN" section that should give you some ideas. Many of them can be used outside of the membership environment.

Good Luck, and please share any solutions that you come up with.

Jerry Kornbluth

Although it is possible to use the CMSB database to capture email results, I finally found a solution that works well for me. It is an installed solution that runs in conjunction with CMSB and uses it's own MySQL database on your server. The software can be licensed individually or unlimited and has a nice dashboard for creating and editing the forms with an online editor and managing all the forms and surveys data on the site. This also gives the site owner the ability to safely manage their own data.

See Machform at http://www.appnitro.com/

Thanks, rconring. This is more of what I'm looking for. I would be stoked if CMS Builder had a plugin that did the same, but this may be my solution for now.