In this article we will give an overview of how to download your data into a spreadsheet, for a specific form.
In order for you to do this, your form will have to have a Device Magic Database Destination. This web store is created by default on creation of a form.
The Device Magic Database is where you can download form submission data.
Access your Form's Device Magic Database
To access your submissions, first go to your Forms list. You can either click the button in the submissions column next to your form or click on the settings icon on the right hand side and click on "submissions".
Note: If there are no submissions this form, this button will read "0".
You'll then be redirected to your form's Device Magic Database.
If you have submissions in your Device Magic Database (Web store), you will see a list like this:
Downloading your data
1) Select the entries you'd like to download to the left of each submission.
2) Then, click the 'Download Selected' button and select the format in which you'd like to download the data. A download will be triggered.
To download all your form's submissions, click "Download All" in the top-right-hand corner.
Please note, for large downloads you will have the option to select 'Send to email (big downloads)' after selecting 'Download All'.
Note: The "Send to Email" feature is only available on paid/custom accounts.
Enter your email address, select your format and select a date range. Click 'Export' and an email will then be sent to the email address you specify with the attached document.
Viewing your Data
Once you have downloaded and opened your Excel / CSV data export file, you should be able to see your submissions in a spreadsheet format. Some meta-data as well as your Field Labels will be set as column headers and your submission data will be in rows beneath this.
Note: When using Repeat Groups in your form, a row will be created for each repeat group entry. This will contain each repeat group item's unique data and duplicate the rest of the submission's data in the row. Please reference the "Submission ID" for associated data.
Removing Unwanted Columns
You may find empty columns in your spreadsheet. This could mean that the field was not completed in the submission, or these empty columns may be from old fields that had data, but have since been removed from your form. If you would like to remove these additional columns, use either of the 2 methods below:
Navigate to your Form's Summary page.
2. Remove your form's Device Magic Database Destination from your form's Destination's list.
Then add the Device Magic Database Destination again.
The Device Magic Support Team can redeliver any submissions which don't contain the unwanted fields that create these columns.
3. Make a copy of your form. Upon submitting a form to the copy (new form), only fields that have data will create columns. Please note, that old submissions will only be visible in the original form and cannot be copied over to the new form.
Other Device Magic Database Capabilities:
If you have any questions or comments feel free to send us a message at firstname.lastname@example.org.