I am creating a Customer Survey Form, very similar to the sample that is available in WFB. In fact, I've used this sample as a template to begin creating my own form, so that helps a lot. Thanks.

My question may be somewhat indirectly related to WFB, but my form will in fact become the data collector for later analysis. Ultimately, I plan on simply downloading the CSV file for processing after my survey is completed. So here goes:

Let's say a survey question has a choice 4 or 5 radio buttons, ranging from "Very satisfied, Satisfied,...etc". In order to later analyze the results, is there a way of including a number, or weighting factor, with each radio button, so that Excel can then count the number of "1" responses, "2", etc. For each question, I want to either find the number, or percent, of responses in each category. For example, the result of question number one would determine that 60% of the responses were "Very Satisfied", 10% "Satisfied", etc.

I just need a couple of WFB design guidelines which would provide CSV data that I could post-process easily.

Thanks

I think you can alter the value="" in the html after export. Are you using your own host or S-Drive?

-- Add the values in the drop-down.
-- Add a text box for each value in the drop-down.
-- For each text box, use the "Show Element" setting so that it only appears when it's corresponding value in the drop-down is selected.
-- After you export, edit the form html and put a default value in the text boxes.

In your CSV file, you should have five extra columns, one for each dropdown value. You can do your computations using those. For example, use a COUNTA Excel function on any column to count the total number of responses. (It's essentially a quick way to get a row count.) Then COUNTA each of the 5 extra columns for total responses of that value. Divide to get your percentages.

Brian,

Thanks for the step by step! That gives me plenty to go on for the next day or so. Will report back!

Brian,

A couple of questions, if you don't mind...

1. -- Add the values in the drop-down. >> You mean numbers, like 1, 2, 3, 4, 5 ??

2. -- Add a text box for each value in the drop-down. >> A separate text box along side?

3. Would this work for Radio buttons, instead of drop-down choices?

I'm good with the Excel part, so thanks for your direction there, as well!

Basically. The value can be anything. It could be: Hated It, Didn't Like It, It Was Ok, Liked It A Lot, Loved It
Whatever the choices that the user will make goes in the drop-down.

Yes. Make the width of the dropdown 75% and the width of the text boxes 25%. Keep in mind that only one text box will be visible to the person completing the survey, because none of them actually appear until the user has made a choice from the drop-down. If they change their choice on the drop-down, the visible text box changes.

Yes. The key to making this work is having the text box display conditions set so that the correct text box shows for whichever value the user selects.

Hi Brian,

I think I have it sorted out now. Thanks for your assistance. Greatly appreciated!

Norm