Hello everyone,
I have a small problem with the automatic data export that goes directly to Google Sheets when someone sends a message via Contact Form 7.
In order to send the contact data to the proper location, I’m using a drop-down menu option that looks like the example here:
<label>\* Where is your business located?\[select\* business-location include\_blank “Canada|[[email protected]](mailto:[email protected]), [[email protected]](mailto:[email protected])”\]</label>
The data being passed to the sheet are the email addresses, not the “Canada” location. CRM Entries records the location properly on the actual plugin (it has a built-in database of submissions), but doesn’t seem to send the same info to the Google Sheets.
Does anyone know how to grab the information before the pipe via a short code perhaps?
Thanks for the help!
[ad_2]