Easy way to auto generate comments based on dropdowns / checkboxes

[Agent]

Hi

I could code this in a web based language, but I'm just wondering if anyone knows a reasonably easy way to do the following:

I want a form (word / excel / google forms) where I select a mixture of dropdowns and checkboxes for a question, and will auto generate comments based on the selection.

A practical example would be the following:

1) What is the person's gender?
[Dropdown of answers]

2) What colour is the person's eyes?
[Dropdown of answers]

3) Was the person wearing trainers?
[Checkbox for yes]

Text box at the end:
"The female staff member had brilliant blue eyes and was wearing trainers"
or
"The male staff member had emerald green eyes and didn't wear trainers"

Each selection in the dropdown would need a sentence associated with it, which are all concatenated together in the text box.

It really needs to be a MS office product or an online one like Google forms for portability reasons.

Any offers? I could easily code this, but I'm falling foul of making more work for myself maintaining something that isn't my job again!

Cheers

[finlay666]

You could just use a function using a string concat on the values and true/false for the trainers

[TheAnimus]

If you are in a Microsoft environment you can use Sharepoint (funny, thunder clapped just as I typed that)

http://office.microsoft.com/en-gb/ac...010356866.aspx

[rokeyge]

You should be able to easily do that with some Excel Vba. Google shows me you can do dropdown box pretty easily... http://www.contextures.com/Excel-VBA...Box-Lists.html

What you then need to figure out is how to do conditional string building for your rules.

Much easier if you can do some simple Javascript+html and dump them somewhere on the web.