How can I automatically parse form data from an email notification

  • Profile Image
    Lorraine Bias
    Asked on October 23, 2011 at 10:45 AM

    I am trying to automatically parse information from a jotform email notification - but am having difficulties with the format received.  The end of line marker isn't clear and there are imbedded tabs causing issues.  Reading your website, it appears you suggest downloading the information submitted in a csv or excel file to collate multiple form transmissions.  Can you please advise?

  • Profile Image
    allanftd
    Answered on October 23, 2011 at 12:11 PM

    Hi Lorraine,

    Thank you for posting your message here. I'm imagining you want to use the data from email notifications into your database. While there is no direct automatic database integration available in JotForm at the moment, the fastest way would be to export your submissions data into an Escel or CSV file. Most, if not all, database platforms support data import of CSV or Excel files. For more information about downloading CSV files of your form submissions, please visit http://www.jotform.com/answers/32947-Can-I-download-info-from-my-form-into-Excel.

    We hope this information will address your current requirements. Let us know if you need further assistance.

    Thanks for using JotForm!

    Allan
    JOTFORM SUPPORT