I am struggling to export certain database values entered by the contact form.
My contact form is for real estate enquiries, such as:
name, email, buying/selling, enquiry type (e.g house, land), location (e.g america, africa, new zealand), subject, and message.
What I am wanting to do is export emails only for different variables.
An example would be I want to get the email for people wanting to buy, house, in america.
I have got to the stage where I can get e.g email for, "buying", but when I add more filters it just includes all listed locations no matter if its a house or unit.
an example of the filter is:
the results given can be correct, but it will show emails from people who are also "selling" if the locations are there.
I have no idea if the filter is capable of doing this, I am only using the "database short code" page and the filter towards the bottom.