Overview
With the Productivity Suite integrations, you are able to use Power Automate (MS Flow), Hosted Webhooks, HPE Content Manager, and more. These can be used to integrate with a number of systems. Most of these require time, configuration, and technical knowledge. If you need to quickly and easily access your form submission data, you can use the extract to get the submissions straight from the Cloud storage.
Instructions
- Navigate to the Forms tab
- Select the desired form
- Click the Submission History tab
- Select a date range and click Search
- This will display all the submissions for that time period, click Extract
- This will send an email to your logged-in email address, where you can download the form data in a JSON (JavaScript Object Notation) format.
What to Do With the Data
JSON is a commonly used standard text-based format. It can also be easily converted into a CSV, to be imported into your Google Sheets, Excel spreadsheet, databases, or analytics tools.
Example
Here is a quick example using a third-party tool to quickly convert your JSON export into a CSV. There are many similar JSON to CSV tool being used in this example is Numidian Convert.
Comments
Let us know what was helpful or not helpful about the article.3 comments
Will there be an upgrade to allow you to download the file as a .CSV file? It seems like going through an online 3rd party tool to convert the file destroys any document security.
I completely agree about security.
This really needs to allow users to export to different formats. Some users exporting this will be non-technical and JSON makes no sense to most people. This is supposed to be a step up from the forms functionality in CivicPlus but adding extra steps to user's work to make up for a lack of features is a bad sign. Please add different export options.
Please sign in to leave a comment.