Let me start by saying I haven't programmed anything in over 25 years, and then it was BASIC and Pascal. Heck I can barely spell PHP! :)
I'm trying to create a form that automatically emails the selected recipient, but also keeps the selected choice (not the email) as the entry. I'll try to explain.
I've created a form that is written to the database using Contact Form to DB Extension. The form contains one drop down (select) item with 40 entries and their email in it. Here is an example:
My goal is for a person to make their choice using the drop down and have the appropriate person notified by email without exposing the email to the user - this works as expected.
The problem is that Contact Form 7 sanitizes the data to the right of the pipe ("|") before it is stored in the database. As a result firstname.lastname@example.org is stored in the database rather than Ford.
Does anyone have any ideas how I can accomplish this? I'm really open for suggestions and any help would be greatly appreciated.