I have created some specific hidden fields in Quform to coordinate with a plugin that captures UTM data from PPC campaigns. The capture of this information is working perfectly. The problem is that when we export the data in a CSV file with Excel compatibility, or any other export format, some entries in column V have zeroes substituted for the actual digits.
Files included below. The first is a screen shot of an entry. Showing what is in the database. The field we are concerned with is “vt-c.” This corresponds to Column “V” in the sample spreadsheet. You can see the difference between the two. This problem is preventing simply importing this information into a CRM system.
Is there a bug in the export function? Or am I doing something wrong?
Thanks! This code snippet worked. I added to the child theme functions.php and ran a new test with the same date selections and got clean output. Results were correct in Excel and Numbers were correct.
.
