Creating and working with surveys

Surveys are a great way to learn more about what your audiences would like you to keep doing and what needs improvement.

With the great new addition to the Dynamics CRM family, Adxstudio Portals, you can easily create surveys to be exposed to your audiences on your portal(s).

In this blog post we will create a survey to be hosted on a Community Portal. Since Adxstudio Portals are directly linked to Dynamics CRM all the heavy lifting takes place in the familiar Dynamics CRM UI

Picture54 Picture61

Creating a survey is accomplished by making customizations in CRM and creating a new entity. Once the entity has been created and its form has been edited to suit your desired layout then a Web Form and steps can be created.

The steps

  1. Create an entity
  2. Create fields
  3. Create forms
  4. Create a web page
  5. Create a web form
  6. Create survey steps
  7. Add the web page to the Portal
    (to create an Adxstudio trial please refer to this blog post)
  8. Try out the survey
  9. Review the results

Create a new entity

Login to CRM, navigate to Settings, click Customizations, click Customize the System (1)

Picture1

Click New (1) and then Entity (2)

Picture2

Fill in the required fields for the new entity:

  • Choose a Display Name, eg "Fan Survey" (Plural Name: Fan Surveys, logical name: new_fansurvey) (1)
  • Set the entity to display in an area of your choice, eg Community (2)
  • Click Save (3)

Picture3

Now we will start building the questions of survey. We will need to create a bunch of fields, and then build three forms. The third form will help us see the answers the responder provides using the first two forms. The fictatious survey is helping the portal owner to understand how the users like a blog on the portal.

Picture61

Create Fields

We will start with a multiple lines text field to hold a question about how the blog helps the visitor

Click Fields (1) and then New (2)

Picture5

Set the Display Name to eg Description (Logical name: new_description), set the Requirement Level to Business Required, set the Data Type to Multiple Lines of Text, and then click Save & Close Picture6

Create two fields to hold answers to to questions about how the responder heard about us and her fictatious level

  • Display Name: How Heard (Logical  name: new_howheard), Data Type: Single Line of Text
  • Display Name:  Gold Star (Logical name: new_goldstar) Data Type: Two Options

Create three more fields, each one representing an answer to the question we have planned (“How may we contact you?”)

  • Display Name:  Email (Logical name: new_mc1_email) Data Type: Two Options
  • Display Name:  Phone (Logical name: new_mc1_phone) Data Type: Two Options
  • Display Name:  Social (Logical name: new_mc1_social) Data Type: Two Options

Create a field to hold a quality rating question

  • Display Name:  Quality Rating (Logical name: new_qualityrating) Data Type: Option Set
  • Choose Use an Existing Option Set (3)
  • Choose Likert Scale Quality (4) for the Option Set

Picture8

Finally add a field that will record visitor/responder (current portal user)

  • Display Name: Contact (Logical name:  new_contactid), Data Type: Lookup (2)
  • Target Record Type: Contact (3)
  • Relationship Name: new_contact_fansurvey (4)

Picture9

Create Forms

With the fields created we will next build three CRM forms that will be rendered to display the survey. Two of them will be the forms for the survey questions, and the third will be for viewing the survey results.

Click Forms, New and then Main Form to create a new main form.

Picture10

Click Save As and save it as "Survey Step 2"

Picture11

Click Save As and save it as "Survey Step 1"

Picture12

With the form "Survey Step 1" still open hide the fields "Name" and "Owner" and make them Read-Only.

  • Click the "Name" field, click Change Properties, uncheck Visible by default, check Field is read-only and then click OK
  • Repeat for the "Owner" field

Picture13

We wont be using the Notes tab either, so we'll remove it

  • Select the Notes tab on the form and then click Remove

Picture14

Now we are ready to add the text fields and true/false question to the form (in a layout of our choice)

  • Drag and Drop the Description field onto the form

Picture15

 

  • Click the Description field and click Properties, set the label to "Please give a description of how this blog helps you", and then click OK (1)
  • Drag and Drop the How Heard field onto the form, click it and click Properties, set the label to "How did you first hear about us?", and then click OK (2)
  • Drag and drop the Gold Star field onto the form,  click it and click Properties, set the label to "Are you a gold star member?" (3)
  • Click Save & Close (4)

Picture16

Next task is to edit the form for Step 2 of the survey

  • In the list of Active Forms click Survey Step 2 (1) to open the form

Picture17a

Repeat the steps from the Survey Step 1 form with regards to the Name, Owner, and Notes fields

  • Click the Name field on the form and click Properties, uncheck Visible by default, check Field is Read-only
  • Click the Owner field on the form, the click Properties, uncheck Visible by default, check Field is Read-only
  • Click the Notes tab on the form, Click Remove 

Picture20

  • Drag and drop the Quality Rating field onto the form, click on it, click Properties, and set the label to “Please Rate the quality”

Picture21

Add the multiple choice question - for the visitor to indicate how we may contact her

  • Click the Insert tab (1), click the Sections button (2) and then click for a Two-Columns (3)

Picture22

  • Double-click the newly created section (1), change the label to: “How may we contact you?” (2), check Show the label of this section on the Form (3) and then click OK

Picture23

Add each response to this question you created earlier to this section:

  • Drag and drop the Email field onto the form, double-click it (or select it and click Properties), click Formatting, select Check Box as the Control Formatting, and then click OK

Picture24

  • Repeat for the Social and Phone fields
  • Click Save & Close to close the form

Picture25

Back in the list of Active forms, click Form Order and choose Main Form Set Picture26

Move the Information form to the top and then click OK (to ensure this form is what we see when we wish to see survey results)

Picture27

 

Now we will edit the main information form to display the survey results once they start coming in

Open the Information Form

Picture28

Optional – hide Name and Owner fields, remove Notes field, edit section layout (1)

Add the text area and true/false question to the form, in a layout that you desire (2):

  • Drag and Drop the Description field onto the form, click it and click Properties, set the label to "Please describe how this blog helps you", and then click OK
  • Drag and Drop the How Heard field onto the form, click it and click Properties, set the label to "How did you first hear about us?", and then click OK
  • Drag and drop the Gold Star field onto the form, click it and click Properties, set the label to “Are you a gold star member?”, and then click OK
  • Drag and drop the Quality Rating field onto the form, click it and click Properties, set the label to “Please Rate the quality”

Add the multiple choice question:

  • Click the Insert tab in the ribbon, click for a Two-Column section, double-click on the newly created section, set the Label of this section to be: “How may we contact you?”, check Show the label of this section on the Form, click OK (3)

Add each response to this question you created earlier to this section (4):

  • Drag and drop the Email field onto the form, double-click it or select it and click Properties, click Formatting, select Check Box as the Control Formatting, click OK
  • Repeat for the Social and Phone fields

Picture100

Finally, we will add the Contact Lookup field to the form, to display the name of the responder

  • Drag the Contact field (1) onto the form (2) perhaps with a spacer above it
  • Save & Close to close the form and Publish All Customizations

Picture101

Create a Web Page

Now that the entity, fields and the CRM forms have been created, we can create the web form data for our survey and associate the survey with a web page so that it shows up on our portal.

  • Navigate to Portals and then Web Pages to display the list of Active Webpages

Picture32

Click New (1) to create a new Web Page

Picture33

Give the web page the following values:

  • Name: Fan Survey
  • Website: Community Portal (or another portal depending on your portals)
  • Parent Page: Home
  • Partial Url : fan-survey
  • Page Template: Full Page
  • Publishing State: Published

and then click Save to save the Web Page

Picture34

Create a Web Form to add to the Web Page

Click Portals and then Web Forms to display the “Active Web Forms” list (note - using this approach we must remember to connect the new web form to the web page once created using the Web Form lookup field)

Picture35

Click New to create a new web form.

Picture36

  • Specify a Name for the Web Form: Fan Survey
  • Set Authentication Required to Yes
  • Set Multiple Records Per User Permitted to No
  • Click Save (do not close the form)

Picture37

 

Create survey steps

Next up we will create the two steps comprising the survey

  • Click the Start Step lookup (1) and then click New (2) to display the "New Web Form Step" page

Picture38

Give the step the following values:

  • Name: Survey Step 1
  • Type: Load Form (should be set already)
  • Entity Logical Name: new_fansurvey (select in drop-down)
  • Mode: Insert (should be set already)
  • Form Name: Survey Step 1 (CRM form definition, select in drop-down)

Picture39

Scroll down if needed

  • Check Associate Current Portal User
  • Target Entity Portal User Lookup Attribute: Contact (new_contactid)
  • Click Save

 

Picture40

Click then Next Step lookup button, click New Picture41

Give the step the follow values:

  • Name: Survey Step 2
  • Type: Load Form
  • Web Form: Fan Survey
  • Entity Logical Name: new_fansurvey
  • Clear the Next Step field if its showing any values (5) - ensures that this final step displays a Submit button (if this field holds a value a Next button will be displayed on the step)
  • Mode: Edit
  • Form Name: Survey Step 2
  • Source Type: Result From Previous Step

 

Picture42

Scroll down to the Form Options section if needed

  • Success Message: Thank you for your submission (this message will be displayed to the responder after submitting the survey)
  • Save (don’t close the form – we are going to add a related entity)

 

Picture43

Click the Survey Step 2 arrow in the navigation bar and then Metadata Picture62

Click Add New Web Form Metadata Picture45

  • Specify the Attribute Logical Name to be the logical name of the Likert scale question you created: new_qualityrating
  • Select Option Set as Horizontal Radio Button List from the style dropdown in the Control Style section
  • Click Save & Close

Picture46

Finally we will make sure the Web Page and the Web Form we created are linked.

  • Open the web page Fan Survey if not still open, click the Web Form drop down (1) and select the web form you created

Picture47

Save all windows open at this point and Publish All Customizations

Add the web page to the Portal

Navigate to your portal and sign in as administrator (1)

Picture48

Hover over the primary navigation bar to see the Edit option (1) for the primary navigation Web Link Set

  • Click the Edit button (1)

Picture49

Add a new web link by clicking the “+” icon (1)

Picture50

Fill in the following fields

  • Name: Survey
  • Page: Fan Survey (select in the drop-down)

and then click Save and Save again to close the Primary Navigation editor

Picture51

The Primary Navigation bar now displays the new link (1) to the Survey

Picture52

Try out the survey

Log out of the portal if still logged in as administrator

Log in as a user (1) and click the Survey link (2) to open the survey (an anonymous user will be directed to the sign-in page)

Picture53

Fill out the survey step 1 and click Next (1)

Picture54

Fill out the survey step 2 and click Submit (1)

Picture55

The success message we provided is displayed to the responder (1)

Picture56

Review the results

When visitors (users) start answering surveys the results are availiable to you in Dynamics CRM via the form you defined above.

  • Navigate to the area in which you placed the new entity - in this example the Community area (1) - and click the entity name - in this example Fan Surveys (2) to open the list of records (results)

Picture59

Click one of the results

Picture60

And see the answers the responder provided

Picture61

Surveys are indeed a great way to learn more about what your audiences would like you to keep doing and what needs improvement.