Query about Forms/Survey's... SharePoint, InfoPath etc


I have a requirement to assist in delivering a solution to survey 300+ users and transform the data into some meaningful MI. The form is relatively vanilla albeit apart from a few items which I have discovered are pushing the boundaries of OOTB solutions. The tool of choice is currently SharePoint 2010 (using Lists and/or Surveys) as this is readily available internally.

The survey consists of numerous questions with input completed by way of Text Boxes, Option Buttons, Drop-Down Lists etc. Not an issue.

The issues however with SharePoint OOTB are as follows;

SharePoint Lists - Does not allow question branching
SharePoint Surveys - Allows question branching (however this is purely one-to-one not one-to-many) but does not allow calculated fields.

The survey has been built in both of the above and we now need to build the rules element (for one or the other). We have played around with InfoPath however the rules seem rather limited OOTB. All we are looking to do is something along the lines of if Question 4 is answered as 'Yes', continue to Question 5, otherwise save and exit...or if Question 29 is 'Yes', goto Question 30 and then 36. Some expand/collapse grouping would be also be great.

How can we achieve this? Is it possible without going into raw code?

Alternatively scrapping the whole SharePoint idea, are there any web solutions that offer these features?

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jamie McAllister MVPSharePoint ConsultantCommented:
If you want to do anything beyond a very vanilla survey try SurveyMonkey or one of the many other providers you can find via your favorite search engines.

I tend to find SharePoint surveys something of an embarrassment - clients hear they exist in SharePoint and come to ask how they can use them. When they actually lay eyes on them I tend to apologize and suggest one of the alternatives. :/

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
just4kixAuthor Commented:
Unfortunately, it appears without some heavy development, my requirements are not achievable.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.