Is there a way to add html to the generated CSV file of my submissions?

  • Profile Image
    sdsign
    Asked 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?

  • Profile Image
    raul
    Answered 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.
    Thanks.

  • Profile Image
    sdsign
    Answered 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.

  • Profile Image
    raul
    Answered 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.
    Thanks.

  • Profile Image
    sdsign
    Answered 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. 

  • Profile Image
    raul
    Answered 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.

    Thanks.