Schedule a CSV Export of Form Submissions

 

 

About

Schedule an export of Form Submissions, and have it delivered by email on regular intervals in a CSV spreadsheet format.  This report will contain all data included in each submission that is included. 

This is useful for:

  • backing up the data from form submissions
  • searching across the data to easily find a specific submission
  • building your own reports in Excel, or importing ProntoForms data into other reporting tools
  • or sharing data with external stakeholders

 

List Existing Schedules

To view your existing schedules:

  1. In the Data & Analytics tab, select Submissions (by Form).2018-04-25-SingleFormExport01.png

  2. Choose your desired form. 
  3. Mouse over the form name, and press List Schedules
    2018-04-25-SingleFormExport02.png

[ top ]

 

Create a  Schedule

  1. Go to the Submissions (by Form) page for your desired form. 
  2. Select the calendar icon above the list of Form Submissions.
    2018-04-25-SingleFormExport03.png
  3. Set up the schedule according to the options below.

[ top ]

 

admin.pngnouser.pngnomobile.png

Schedule Options

sheduling_options_tab.png

 

Schedule Name

Provide a name for the schedule.  In the event of a team using multiple schedules, the name should make it easily distinguishable from other schedules.

Time Zone

When export schedule is enabled, the time zone will be defaulted to team time zone on this page. 

Schedule Recurrence Pattern

This setting controls both when your data will be delivered and what date/time period of data will be delivered.

Note:  Date/time settings on saved filters will not be respected in the schedule; the schedule recurrence pattern acts as the date/time filter for which data records to include. 

schedule_recurrance_pattern_monthly.png

 

 For example:  

  • Set an hourly export at the 30 minute mark every hour.
    • If I receive an export at 2:30, it will include submissions completed between 1:30 and 2:30.
  • Set a daily export at 2:30 AM
    • The export will include submissions completed between 2:30 AM yesterday and 2:30 AM today
  • Set a weekly export on Fridays at 3:00 PM
    • The export will include submissions completed between 3:00 PM last Friday and 3:00 PM this Friday
  • Set a monthly export on the 1st of the month at 10:00 AM
    • The export will include submissions completed between 10:00 AM on the 1st of last month, and 10:00 AM on the first of the current month

[ top ] 

Data Options

Filter Options

File Options & Data to Include

[ top ]

 

Email Options

DRemailoptions.png

Email Addresses of Export Recipients

Supply the email addresses of the individuals to send the exported data to.  If multiple addresses need to be included, separate them with a semi-colon or a comma between each address.

Do not send empty Email Reports

With this option selected, in the event that no form submissions meet the filter rules, no email will be sent.  

[ top ]

 

File Format

Read more about the data export format in our manual CSV export article. 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments