Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Can someone point me to how to go about creating a sharepoint list form with a repeating and non repeating section?

For example, a form that basically submits a team's information to a sharepoint list. we have a list with 6 fields and we want to be able to add indefinite number of Members for the form. So that when we save if you added 6 members, it would creat 6 rows of records. However we don't want to have to type in Team info everytime. (The advanced options allows me to manage multiple list items with the form but it makes the whole form repeatable). not just sections. I've also looked into creating a sharepoint form library with a repeating table but since it looks like infopath forms don't directly saves into a sharepoint list in this option, I was hoping someone has a better idea or if they have done this solution before. Most of the community online seems to reference a solution that's from 2007. I was hoping for a more updated solution now that we are using sharepoint 2013. Unfortunately, they would all be contained in one list so that the business users can query and sort them.

Fields:

  • Team Name
  • Team Color
  • Team Number
  • Member Name
  • Member age
  • Member weight
share|improve this question
add comment

1 Answer 1

The easiest way would be to split the data into two lists and display them on two forms. One list to hold teams and another list to hold the members. The members list will need a Team field that is a lookup to the Team list.

You have a form for creating Teams where they enter all the team info like Name, Color and Number. Then you have another form for entering members where all they need to fill in is the Team lookup field.

Although it is possible to display the Members form as a repeating section on the Team form I don't think InfoPath supports creating/editing rows in repeating sections OOTB.

share|improve this answer
    
unfortunately, we need all the info in one list so that business can query it. –  stevenjmyu May 9 '13 at 14:39
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.