What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    How can I append to a CSV file

    Asked by paullong on July 04, 2016 at 05:13 AM

    Hi

    How can I get my form to append to a CSV file in Dropbox or some other file storage?

    Thanks, Paul

    CSV how append
  • Profile Image
    JotForm Support

    Answered by Charlie on July 04, 2016 at 09:48 AM

    I am not entirely sure what you meant by "append", would you like to perhaps send a copy of the submission data on a storage service like Dropbox, Google Drive and Box.com? 

    Here are the possible solutions that may work for you:

    Option #1: If you would like to automatically send a copy of the submission data as an excel report to your Dropbox account, then you can use this app: https://apps.jotform.com/app/reports_to_cloud 

    Option #2: If you would to have a copy of the submission PDF and the file uploads on your 3rd party storage account, then you can check the following guides:

    https://www.jotform.com/help/192-How-to-Integrate-a-Form-with-Google-Drive 

    https://www.jotform.com/help/77-Upload-to-Dropbox-with-JotForm 

    https://www.jotform.com/help/349-How-to-Integrate-your-Form-to-Box 

     

    Option #3: If you want the submission data to be on an online spreadsheet, then perhaps this integration might be useful:

    https://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet 

     

    I hope that helps.

  • Profile Image

    Answered by paullong on July 04, 2016 at 10:00 AM

    Hi

    By append, I mean that each time a form is completed, it will add a row to a CSV file stored somewhere.  So instead of having to download reports, it will add immediately to a CSV file.  Google Sheet doesn't use CSV files so wouldn't be appropriate.  

    Here is an example of what I want to add to https://www.dropbox.com/s/qgj7zoqvv3jcpsq/enquiries.csv?dl=0 

    Paul

  • Profile Image
    JotForm Support

    Answered by Charlie on July 04, 2016 at 11:25 AM

    Unfortunately, we do not have features or app integrations that would append data on an existing CSV file on a Dropbox folder/account. Aside from the suggestions I have listed in my previous post, the only way to actually append data on an existing CSV file in Dropbox is by using Dropbox API.

    Here's how I will do it:

    1. Create a custom script and upload it on a server.

    2. The custom script will fetch the submission data being sent. This can be done via HTTP POST. Here's a guide that you can refer to: https://www.jotform.com/help/213-Send-POST-Data-From-JotForm-Using-PHP-in-Custom-Thank-You-Page 

    3. Now via Dropbox's API, you can fetch the POST data and append it on a CSV file. You can check Dropbox's developers page and see if that is possible: https://www.dropbox.com/developers 

    4. You can then add the custom script in your form's "Thank You" page or on a WebHook integration.

     

    Or, you could also use JotForm's API to easily fetch existing submission data from your forms.

    Just to add, Google spreadsheets and excel reports can be easily exported or saved as CSV files if you download and edit it on a spreadsheet editor like MS Excel. 

     

    Aside from the mentioned suggestions, we do not have any other that specifically fits what you are looking for. But I hope that gives you an idea on how to proceed.