I'm trying to set up the contact form on a client's site so that the e-mail address it is sent to depends on which option the site visitor selects from a drop down menu. Basically the client has representatives in different countries and wants the relevant country rep to receive the e-mail when the visitor selects which country they are from - so if they select UK it goes to the UK rep only, if they select USA it goes to the USA rep only, etc...
The addition of pipes to the form code allows us to achieve this, and using the [_raw_field]) enables us to have the original value (rather than the conditional e-mail address) in the e-mail that's received. However, we are also using the paid version of the Contact Form to DB Extension, and rather than capturing the original value from the form, it is capturing the conditional e-mail address. Basically we want the database to capture the value before the pipes, but it is capturing the e-mail after them.
Is there a way to rectify what's being captured in the database so that it contains the correct information?