Hi all,
Has anyone played around with a function that would automatically mark a record in a table as "hidden" if the e-mail field in that table matches the e-mail field in the accounts table?
Here's why...
I'm thinking of setting up a "newsletter signup" form for prospective members of an organization.
I'd be using a 3rd party package like Easylist to create the opt in e-mail and to keep records of those e-mail addresses awaiting confirmation.
When the link in the opt in e-mail is clicked, the prospect would be taken to a form that uses the membership plugin to automatically create a record in a "Newsletter Signup" table. The form would have fields for the prospect's first name, last name, e-mail, a few other fields for preferences.
If a person who is receiving the non-member newsletter becomes a member, I'd like to be able to automatically purge the newsletter list so that these folks never receive another non-member newsletter, and so that up-to-date lists of interested non-members and successful conversions can be created.
Best,
Jerry Kornbluth
The first CMS Builder reference book is now available on-line!
Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php