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