- sdsignAsked on November 19, 2014 at 04:37 PM
I wanted to know if it's possible to have HTML automatically added to some fields when I export to CSV.
For example, to automatically add <p></p> around someone's name or comments.
Is this possible?
- raulAnswered on November 19, 2014 at 05:42 PM
Unfortunately, that's not possible and also wouldn't work correctly since a CSV file doesn't render HTML when it's viewed in Excel for example. A CSV file basically works with text values separated by commas.
If you are looking for a web report for your submissions, may I suggest that you create a visual report instead?
Let us know if you need further assistance.
- sdsignAnswered on November 19, 2014 at 06:08 PM
I wasn't looking for it to render the HTML, just add the text in front and behind the submission.
So user would enter "Joe Smith"
But the CSV cell would contain "<p>Joe Smith</p>"
That way I could just import the CSV without adding markup.
- raulAnswered on November 19, 2014 at 06:46 PM
In this case you could modify the file directly in Excel to add these tags in the cell.
I mean, you can change the cell format using a custom format like this: <p>@<\/p>
And then copy this format to all the cells in which you need to add these tags automatically and re-save the file as CSV so you can import it.
Let us know if this helps.
- sdsignAnswered on November 20, 2014 at 12:58 PM
Close to working but Excel says "...cannot use the number format you typed." when I try and save the custom format.
- raulAnswered on November 20, 2014 at 01:21 PM
Can you post a screenshot of the error message and also another screenshot showing us how are you configuring the custom format? Please check this guide on how to do this: https://www.jotform.com/answers/277033-How-to-add-screenshots-images-to-questions-in-support-forum
This will make easier for us to see why are you're receiving this message.