Re: Autopopulate repeating table from sharepoint list based on 2 dropdowns and autonumber each row

Patrick Halstead — Wed, 22 Sep 2010 07:20:22 GMT

This is really easy to do.

Add a data connection to the SharePoint list called Courses. Show the values for name and date in two dropdowns. Second dropdown is filtered on first..

Add a rule to the second dropdown that queries a data connection to get the Attendee Names based on the first two values.

If you add the SharePoint list IDs to your data connection, you can populate the forms with this and use it to query Attendee Names based on course.

To autonumber rows in a form is pretty simple - just use the count() xpath function when a row gets added or, if you need a unique identifier you could look at a plugin like qRules that comes with a rule for automatically generating ids.

To add 3 empty rows automatically, go to Tools->Default Values and add them there.

This stuff is what InfoPath is really good at.

Autopopulate repeating table from sharepoint list based on 2 dropdowns and autonumber each row

lverhelst — Mon, 13 Sep 2010 07:31:54 GMT

We have the following problem with an infopath form.

Dataconnection: sharepoint list; Coursname, Course date, Name attendants

Based on 2 dropdowns coursename and coursedate, the repeating table should show the attendants for this course.

extra issues: we should autonumber each row and add 3 empty rows by default.

is there somebody that can help?

General

Re: Autopopulate repeating table from sharepoint list based on 2 dropdowns and autonumber each row

Autopopulate repeating table from sharepoint list based on 2 dropdowns and autonumber each row