I am planning to export my collected data to an Excel CSV (data Collected via Fast Secure Contact Form plugin, exported using a connection to Contact Form DB plugin). I have several fields in my form that collect long number/digit strings (international phone numbers, for example).
I am beyond frustrated with Excel that it can only read number strings of 15 digits or less. Anything 16 digits or longer shows the 16+n digits as 0, which is useless when you’re trying to collect an exact phone#, etc! If you format an Excel cell as text, THEN it accepts more than 15 characters/digits, so I can do this, go through each submission individually, and recopy the info into Excel. But we receive a lot of submissions and this is quite time consuming, increases the possibility of error, etc…
So here’s where I’m hoping for help in the plugin: In Excel, if you preface a digit entry with an apostrophe ( ‘ ), Excel reads it as text. It doesn’t try to auto-format the number, and a text cell can be much longer than 15 characters. Is there a way that I can force an ‘ to be added to the front of a form field? I can’t use a regex to force the subscriber to enter this themselves, as we are trying to keep the form simple for an audience that may have limited English and/or tech skills.
Is there any way that I can have the plugin automatically add an apostrophe to a field submission? Subscribers/users would not see this, but it would show up in the data that is collected and sent to us, thus fooling Excel?
I’m sorry for the confusing explanation, and I also know this is ultimately a problem in Excel, and not this plugin. But I hope the plugin might be able to help!! Ugh… If anyone knows of a way I could auto-append the apostrophe (or any character, text, etc, for the sake of learning!) to a form field submission, I will be extremely grateful. And if there’s definitively not a way to do this, I would appreciate knowing that as well, so that I will stop hunting for a solution…
- The topic ‘Automatically add a character to field upon submission?’ is closed to new replies.