Newbie Questions

Re: Filling rows of a repeating table by opening the form

nomz123 — Fri, 07 May 2010 05:52:39 GMT

Oh Shame :(

Thanks for your reply!

Re: Filling rows of a repeating table by opening the form

Hilary Stoupa — Fri, 07 May 2010 00:43:34 GMT

Hi:

Repeating groups in InfoPath aren't terribly easy to work with. For the first issue you mention, that you want to have some rows filled out from information in another list, you will either need to write custom code or use a tool like qRules to copy the data from one data source into your main data source. You are correct that you will not be able to edit a promoted repeating field in SharePoint, either manually or via workflow.

Sorry I don't have better news!

Filling rows of a repeating table by opening the form

nomz123 — Thu, 06 May 2010 11:32:38 GMT

Hey everyone,

In my Infopath form I use a repeating table. On opening this form on sharepoint I would like to have some rows of the repeating table filled out using information from an other list. I use content types.

What i am working on is a Timesheet system where the user can register how many hours a week he worked on different projects.

I would like that by creation of a timesheet some predefined projects will be already inserted, meaning that the repeating table will have for example 5 rows already with 5 favourite or most used projects selected based on a separate PetProject list.When I looked at the workflow in the list where the timesheet is being created I couldn’t find the column projectname in the dropdown so I cant give it a value. When I went to look in the Form settings of TimeSheets I saw that projectname cant be selected/edited, its in plain black whereas the other columns are blue and clickable. I thought its probably because the value of projectname is merged from the different rows in the repeating table. Is there any way I can work around this problem and assign a value to projectname by creation of the timesheet?

Thank much!