Survey Excel Confluence Tutorial
Contents |
What are we going to build?
View a short video on this topic.We're going to see how easy it is to create a survey form, add it to a Confluence page and view the results in Confluence or download them to Microsoft Excel.
Create the Survey Form
Read the general frevvo documentation on designing forms for a detailed discussion of frevvo forms and their features.Add a new form to a Confluence page
Create a new page in Confluence for your survey. Add a form to the page by selecting the Form menu item. This menu item is available only when the Confluence plugin is correctly installed and configured and you are logged in to Confluence as a user with the appropriate permissions (you must be able to Edit the Confluence page and, if you configured a Form Designer group in the plugin configuration, you must belong to that group).
The Add Form page will be displayed. You can create a brand new form, create a new form by starting from a template or add an existing form. We'll create a brand new form. Select the Create a new form option, enter a name and click Add.
Design the form
This will launch the Form Designer where you can drag and drop controls, change labels etc. Drag and drop your desired survey questions into the form: you can use Text controls for free text answers, Radio controls for a single selection, Checkboxes for multiple selections etc. There are pre-formatted controls for Dates, Money, Phone numbers and you can also create custom patterns for your needs such as Zip Codes or Social Security Numbers.
You can use Business Rules for skip logic, computing totals and many other functions.
Set a Confirmation message
You can use the Form Action wizard to display a custom message when your survey is submitted. Click on Form Action and select the 'Display message when users submit your form' action. In the wizard that is displayed, enter your custom message. For now, just enter the text "Thank you for taking the survey". See the Display Message Form Action documentation for more detailed information including instructions on using dynamic display messages.
When you click Finish in the Form Designer the form will be added to your Confluence page.
Add a Submissions Confluence page
Form submissions can be viewed directly in Confluence. Create a Confluence page and, select the Add Submissions menu item. This menu item is available only when the Confluence plugin is correctly installed and configured and you are logged in to Confluence as a user with the appropriate permissions.
The Add Submissions page displays. Select the Survey form you we created from the dropdown and click "Add". The submissions view will be added to your Confluence page.
Submissions are displayed in a table view. Double click on any submissions to view all of the data. Please refer to Viewing Form Submissions in the frevvo documentation for a full description of all the features.
Downloading Form Submissions to Excel
Click the Excel 
icon above the table to view the submission results in Excel. The spreadsheet reflects the specific date range indicated by the two date controls; this date range will be listed in your spreadsheet.
