Form Support

Is it possible to email out a CSV of your forms results?

  • Profile Image
    worknetcs
    Asked on July 26, 2012 at 04:59 PM

    Hi

    We use your service to great effect and are very happy with it. I was wondering if it was possible to configure a form to email out a CSV file containing the results of form entry rather than having to log into the site and running an export that seems to gather all submissions?

     

    Many thank

     

    Simon Whittington

    simonwhittington@wknet.co.uk

  • Profile Image
    jonathan
    Answered on July 26, 2012 at 06:44 PM

    Hi Simon,

    You can setup the email Notification to plain text mode, and add commas in between the labels and fields like this..

    I cloned your form and tested the email result with csv data here.

    Please inform us if you have further inquiry.

    Thanks.

  • Profile Image
    barq
    Answered on September 17, 2012 at 07:30 AM

    Hi,

     

    I'm wondering if there is a way to do this, without manually having to create e-mail youself? (Which would be very useful if you have a 100+ field form with lots of dynamic fields.

    Simply something like, mail notification as csv/excel?

  • Profile Image
    pinoytech
    Answered on September 17, 2012 at 09:19 AM

    Hi,

    I have now submitted a ticket to our development team regarding on this request but unfortunately, we can't give you ETA to when this be implemented.

    Thank you!

  • Profile Image
    aytekin
    Answered on September 17, 2012 at 09:25 AM

    Another possible solution is to just create a CSV report and bookmark it or link to it from your email. Here is a tutorial on how to do that:

    http://www.jotform.com/help/103-Create-a-CSV-Report

  • Profile Image
    worknetcs
    Answered on May 21, 2013 at 06:59 PM

    Hi

     

    I wonder if there had been any progress towards being able to being able to email out a CSV file containing form answers?

     

    We use your form site (which we think is excellent) for obtaining details on how to set up new users on our system. Currently I manually transcribe the details into a CSV file which is then picked up by a Powershell script which provisions AD accounts and mailbox settings etc.

     

    Obviously if I could get the details straight into a CSV file it would save time. Our perfect scenario might also to be able to upload a CSV into a Dropbox account which our Powershell scripts could automatically poll every hour and set up the accounts without human involvement.

     

    Many thanks

     

    Simon Whittington

  • Profile Image
    Welvin
    Answered on May 21, 2013 at 07:42 PM

    Hi Simon,

    Unfortunately, the ticket has been cancelled. You may consider exporting the CSV Report instead: Generate CSV Report.

    Or, how about creating a Grid Listing Report or HTML Listing Report?

    Create Grid Listing Report

    Create HTML Table Listing Report

    Is your system cannot automate this one?

     

    Thank you!

  • Profile Image
    worknetcs
    Answered on May 22, 2013 at 07:20 AM

    Unfortunately creating reports means that we have to log in to go through the process whenever someone completes a form. This would actually increase the work rather than minimise it.

     

    Thanks anyway.

     

    Regards,

    Simon

  • Profile Image
    Welvin
    Answered on May 22, 2013 at 09:47 AM

    Hi Simon,

    No, you do not need to login again to generate a new report to bring all the recent or new submissions. Just save the link or bookmark the link. Whenever there's new submissions, you can pull them out using the existing report link.

    Thank you!