How can I get the text for a category

You have been working on looping through your MDD for a while now and your

 is almost complete, you have a few things left on your list to resolve, one of them is "Response.value returns a category number rather than the text, how , how can I get the response text". This article explains how to resolve this and hopefully shows you some very useful concepts that can be re-used.

Read moreHow can I get the text for a category

Avoid Incrementing Quotas When Reviewing Interviews

Reviewing an interview causes the interview to be re-executed.  This can cause quotas to be incremented if the interview and sample management scripts do not take this into account.  The DDL example interviewing and sample management scripts for quota show how to avoid extra quota increments and should be used as a base.

Read moreAvoid Incrementing Quotas When Reviewing Interviews

Show all Excel constants

It is often very useful to have a list of all the constants that are used in Excel 2003. One way to get a list is to search the web, but you can produce such a list yourself. All you have to make sure is that you have the following DLL installed TlbInf32.dll. If you don’t have it, search the web and you will find. Once installed create a new mrs file and add the following code

Read moreShow all Excel constants

Finding the value of EXCEL constants

When you write scripts that utilise Microsoft Excel objects you will definitely come across the need to understand some of the numeric values that are stored as Excel Constants. There are several ways you can find out these values and this article provides you with two ways to do that. Before we get started we need to have some excel code.

Read moreFinding the value of EXCEL constants

Corporate look and feel

In this section we will show you how quickly you can adopt a Corporate look and feel. Lets take the example where we have just got a job and the client has asked that we develop a online survey with their corporate look and feel. The company that we are working with is called Your Health and is a company that investigates customers day to day habits. The website looks like this.

Read moreCorporate look and feel

Map Questions

Sometimes you will need your respondents to click on images to select areas such as what state do you live in. In this example we are going to take an image of Australia and turn it into a click-able image that we can use in our survey. We will also show you how you can store the information selected in your survey. The image we are going to use is the following.

Read moreMap Questions

Email from survey

To send a email from your survey is easy to implement as long as your network allows. In this example we will use IIS and SMTP but you should be able to use other email servers.  Once the software is setup you can start. The first thing we need in our survey is a text box to collect the email address, so create a mdd with the following code in it.

Read moreEmail from survey

Help Window

Sometimes in your surveys you will want to offer your users some additional help, now you could just put it on the page but you might not have enough space for it so it is a good idea to add some sort of help icon that the user can click on to open up another window and display the help. In this example we show you have to achieve this functionality.

Read moreHelp Window

Creating Random Unique ID’s

In this example we show you how to mange creating Unique ID’s for your sample and show you how you can use them. This example assumes that you already have a text delimited file that you can use for your sample. For the purpose of this example we will be using a sample file that has the following structure.

Read moreCreating Random Unique ID’s

%d bloggers like this: