- paullongAsked on July 04, 2016 at 05:13 AM
How can I get my form to append to a CSV file in Dropbox or some other file storage?
- CharlieAnswered 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:
Option #3: If you want the submission data to be on an online spreadsheet, then perhaps this integration might be useful:
I hope that helps.
- paullongAnswered on July 04, 2016 at 10:00 AM
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
- CharlieAnswered 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.