Follow @dporton

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 more

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 more

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 more

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 more

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 more

Table of Contents for Excel Tables

Ever wish that the tables export to Excel would create a table of contents?  Ever wish for sheet names based other than T1, T2, etc.?  This post discusses a Dimensions script that creates a Table of Contents sheet, optionally creates links back to the TOC sheet on each table/chart sheet and optionally renames the sheets based on a row in the sheet.

Read more

Participants Tips

Have you ever imported a file into Participants and gotten “Attempting to insert data that does not have a corresponding column.” or “String or binary data would be truncated.”?  This post will explain how to avoid these errors by checking and fixing your Participants file manually before importing.  We will first describe the manual method using Excel and then provide a Dimensions script that can also be used to fix these issues.

Read more

Simple Templates

After you have created your survey the next thing that you really need to do is to create a look and feel. While mrInterview allows you to do lots of customization via the script you will always need to create templates to add more content. This set of steps shows you how to start creating a template from scratch and some of the pitfalls that you need to look out for.

Read more

%d bloggers like this: