Repeating Data, Multi Choice Lists/Repeating Sections and Transmitting to SharePoint

Hi Experts,

I'm currently building a form, the intent is to collect capability requirements from various business units. Now there are approx. 35 potential capabilities, any given business unit may have a requirement for 5-10 capabilities. Capabilities also have dependent required fields (For example, how many hours will you need this capability for).  This form will submit to SharePoint where an analysis tool will look at the submitted data.

What I'm asking is rather than having a business unit submit 5-10 separate forms is there any Great Solution to have multi choice lists / repeating sections submit to SharePoint in a way does not require the data to be "cleaned" by an analysis engine.  Moreover, each capability should its own separate justification and approval / denial section for approvers. As I'm writing this, I guess what this boils down to is can you take a repeating group and have that create a separate "line item" in a SharePoint List without doing some pretty complex coding and developer-side manipulation of SharePoint views?
LVL 1
-PolakAsked:
Who is Participating?
 
Clay FoxDirector of Business IntegrationCommented:
The challenge is to build a real application, with relational data, is tough in SharePoint since it is all flat lists.  There are some ways to relate lists and create some relationships.

Have you thought about using SQL so your data structure can be correct and you can have all of the relationships you want? You could use BCS but ideally web services to interact.  Qdabra.com has a product for this as well.

You can still have SharePoint / InfoPath client side, so the users do not really know, but you gain the benefits on storing, leveraging, and especially reporting on the information.

Just seen a lot of people struggle trying to build a sophisticated solution without the right materials. So you really want to understand the limitations and how that will impact the solution be for you spend too much time on it.
0
 
-PolakAuthor Commented:
I can't edit my last paragraph because this question has been posted to more than 3 EE sections. Please read this edited version:

What I'm asking is rather than having a business unit submit 5-10 separate forms is there any Great Solution to have multi choice lists / repeating sections submit to SharePoint in a way does not require the data to be "cleaned" by an analysis engine.  As I'm writing this, I guess what this boils down to is can you take a repeating group and have that create a separate field/column in a SharePoint List without doing some pretty complex coding and developer-side manipulation of SharePoint views?
0
 
-PolakAuthor Commented:
Your right, I should probably stop trying to massage SharePoint to do this without the proper tools.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.