This worksheet describes how to connect a Snap WebHost survey to a database of respondents. It tells you how to set up the survey so you can:

  • Set up email invitations and reminders
  • Enable the respondents to access the survey directly from the email

OR

  • Make the respondents log into the survey using a login page

Once you have connected the survey to the database and uploaded the published survey to Snap WebHost, this worksheet tells you how to check that it is all working correctly.

Background

Snap allows you to set up database links to an external database of respondents. When you are setting up the link you have the option to:

  • Set up email invitations and reminders. Snap WebHost needs to know the respondent’s email address
  • Identify the respondent to Snap WebHost. This enables Snap WebHost to know when the respondent has completed the survey
  • Seed the survey with data

Snap WebHost only knows who to send reminders to if it has some way of knowing which respondents have completed the survey. This is done by including a paradata field in the survey which identifies the respondent.

When a respondent starts a survey, Snap WebHost records this, using the paradata field. When the survey is submitted Snap WebHost records that respondent has completed the survey and does not send them a reminder.

Respondents can identify themselves to Snap WebHost in two ways:

  • explicitly: they see a login page when they start the survey and they enter their own ID
  • implicitly: the email sent to them contains a link which identifies them to Snap WebHost when they use it

Summary of steps

Step 1: Put the paradata variable to record your respondent into the survey
Step 2: Set up the identification for Snap WebHost using a database link
Step 3: Publish your survey and upload it to Snap WebHost
Step 4: Test that your survey and links are correct

Step 1: Put the paradata variable to record your respondent into the survey

You need to add the paradata variable ID.name to the survey, so Snap WebHost can record the respondent status.

  1. Open your survey and display the Questionnaire window.
  2. Click Questionnaire properties button on the Questionnaire window toolbar to display the Questionnaire Properties dialog box.
  3. Scroll down the options on the left to locate the Paradata section. Once selected, highlight the Respondent field and check the box marked Use in survey. Press [OK] to return to the questionnaire.

    Questionnaire properties

    (If a dialog box should appear reporting that the questionnaire is locked, press [OK] to unlock the questionnaire and continue editing.)

    ID name title

    The ID.name variable will appear below the title.

  4. Select it and right-click to display the context menu.

    Compound grid: Preview no images

  5. Select Hide Variables from the menu.

This ensures that respondents will be identified when they start the survey but they will not have to complete a login.

Step 2: Set up the identification for Snap WebHost using a database link

  1. Open the survey in Snap Professional.
  2. Select File | Database Link to display the Database Linkage dialog box.
  3. Click [New…] to create a new database link. The Database Wizard dialog is displayed.
  4. Select the WebHost Survey / Invites radio button.
  5. Click [Next>]. The Database linkage dialog is displayed.
  6. Click [Select Database File…] and browse to the Excel or MS Access file containing the respondent IDs and dataORclick [Build Data Link…] to build a link to an Oracle or SQL Database with the same information.
  7. The Select the Table to use drop-down automatically displays a table name. If this is not the table you require, select a different table from the list. If you wish to filter the respondents so that this survey is only available to some members of the database, set an appropriate filter in the Where condition box. Click [Next>].
    Select database sub filter
  8. Select the database field that uniquely identifies your respondent as the Login field. (Note that  Identify respondents in the response data is ticked by default).DB-Linkage---Login-Respondent-(step-8)v2
  9. Check Send email invites and reminders and click [Next]. You move to the email invitations step of the database link wizard. This has two functions:
    • tells Snap WebHost which database field contains the respondent email addresses
    • allows you to design an email that will be uploaded to Snap WebHost

    DL wiz: sample email for SO

  10. Check the Use HTML emails if you wish to have styled HTML emails.
  11. Leave the Login from email field as Auto. This will identify your respondents automatically if the ID.name variable is hidden, and provide a login page if it is visible.
  12. Set the email address field to be the appropriate database field in the drop-down list. This will be used to provide the email address for the respondents in Snap WebHost.
  13. Type the subject heading of your email in the first box.
  14. Type the email message in the large box. Use the [Insert…] button to insert the Survey Location. The Survey Location dialog opens.
    Survey location
  15. By default the link text that appears in the message is Click Here, but you can change it to whatever you like. Click [OK]. The link text appears in the email. This will be made into a link to the survey when the message is uploaded to Snap WebHost. You can change or add email messages after the survey has been uploaded to Snap WebHost.
  16. Click [Next]. You will see a summary of what the database link does.
  17. Enter a name for the link and click [Finish].

Step 3: Publish your survey and upload it to Snap WebHost

  1. Select File|Publish or [Ctrl] [Shift] W to open the publish dialog.
  2. Select the Data link section in the left-hand panel. (Note that this is only available for a Snap WebHost edition.)
  3. Select the previously created link to the respondent database in the Database link drop-down list.

    Questionnaire properties dialog showing selecting a database link

  4. Click [Publish]. Snap creates a zip file containing the published survey.
  5. Log in to Snap WebHost and click the Surveys tab. Click on the link Upload link. A new window opens.
  6. Click [Browse] and navigate to the folder containing the published survey.
  7. Select the .zip file containing the published survey and click [Open].
  8. Click [Upload archive] and the survey will be uploaded. The new survey will appear in the list of surveys.
  9. Click the survey link to open the survey.

Step 4: Test that your survey and links are correct

  1. Select the Respondents tab.You should have a Username column containing your respondents’ IDs, and a Completion column containing your respondents’ status. The Address column should contain their email address (in the picture below, this is the same as their ID).
    List of student respondents
  2. Select the Setup tab. If you want to identify the respondent within the survey, select Include respondent details in survey data. If your survey data must be anonymous, clear this option. Check that Enable respondent login has been selected. If not, then check that you have completed all the steps in this worksheet. Click [Save].

    SWH: setup tab showing include respondent details

  3. Select the Messages tab. Your email message should be displayed including the link text. Click Test and send an email to yourself.
  4. When the email arrives, click the link and confirm that you go directly to a preview of the survey without logging in. (Note that the emails will only link to the survey when the survey has been started).
    If you wish to check that the respondent details have been stored in the survey, you will need to complete a response, import it into Snap and check to see if there is a value in the ID.name variable.

Conclusion

This worksheet has described how to set up a database link for Snap WebHost so that respondents can connect to the survey directly from an email. It explained how to create a database link in Snap to set up email invites including the link to the survey. It also described the difference between storing respondent information in the survey and having a completely anonymous survey.

There is a step by step guide showing you how to send email invites to a customer panel in the Getting Started guide.

There is a description of setting up an automatic login to a survey by writing your own command string in an email which you send yourself.

For a complete list of paradata variables available, see: Paradata properties.

If there is a topic you would like a worksheet on, email to snapideas@snapsurveys.com.