- April 18, 2021 at 5:15 pm #32834mkassowitzParticipant
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?
Attachments:You must be logged in to view attached files.April 19, 2021 at 10:06 am #32840AllySupport StaffApril 23, 2021 at 12:47 am #32885mkassowitzParticipant
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.
- You must be logged in to reply to this topic.