SharePoint Survey, ask n times based on answer
We need to complete a survey that will allow the following:
- Question 1: How many vehicles do you have?
- Answer: Dropdown (values ββrange from 1 to 5)
Based on the answer to this question, we need the same set of questions asked 5 times. For example, what is the color and make your car ... etc.
Is there a way to achieve this with SharePoint using OOB / InfoPath Forms functionality?
a source to share
To be OOTB, I see two options: InfoPath (ideally Forms Services if you have MOSS Enterprise) or a poll list. The InfoPath solution will be much nicer, but it will take a little longer (perhaps in a couple of hours versus 30 minutes). In addition, if you do not have MOSS Enterprise, you cannot use InfoPath Forms Services, and everyone must install the InfoPath client on their desktop.
For InfoPath, it's just designing a form with the necessary logic. You don't need any code. I would just ask your initial question and then a section for each subsequent set of questions. In the section display tab, you can have conditional logic to hide the section based on the answer to the first question. If you wish, all of your responses can be added to the fields of the SharePoint form library.
I think the poll list will be a little more kludge (technical term). It has limited branching logic, so it might work a little weird. In the survey, you can move on to another question based on the answer to this question. So, you can order your questions as such (mostly in reverse order):
- How many vehicles do you have? (if 4 answers question # 4, if 3 answers question # 6, if 2 answers # 8, if 1 branch is at # 10)
- Car number 5 question number 1
- Car number 5 question number 2
- Car number 4 question number 1
- Car number 4 question number 2
- Car number 3 question number 1
- Car number 3 question number 2
- Car number 2 question number 1
- Car number 2 question number 2
- Car number 1 question number 1
- Question number 2 of car number 1
Perhaps someone else can find a better solution in the poll list?
a source to share