Newbie Questions

Re: Infopath 2013 help with prepopulating a repeating table field.

Hilary Stoupa — Thu, 09 Mar 2017 15:10:31 GMT

I was unclear - you definitely need the rule with the query - what confused me was that in that rule, after the query, you had a second action that reset the field. :)

Re: Infopath 2013 help with prepopulating a repeating table field.

MichaelHindle — Thu, 09 Mar 2017 04:37:34 GMT

Hi again Hilary,

I worked out what the Query using data was for. Basically the conditions won't work with out that query in there. Not sure why but I actually need to leave it there so the form works, unless you havea better Idea :)

Re: Infopath 2013 help with prepopulating a repeating table field.

Hilary Stoupa — Thu, 09 Mar 2017 00:43:53 GMT

Wonderful, glad you have it working! :)

Re: Infopath 2013 help with prepopulating a repeating table field.

MichaelHindle — Wed, 08 Mar 2017 23:20:22 GMT

Thank you so much Hilary. That works. Just a matter of changing the date first prior to clicking insert. As for the Query field I am not even sure but I will remove it now :)

Thank you once again you are a star.

Re: Infopath 2013 help with prepopulating a repeating table field.

Hilary Stoupa — Wed, 08 Mar 2017 15:24:35 GMT

Okay, I see what you are doing - you are using a default value, which is going to update to whatever the latest value in the secondary data source is. So - I removed that, then set this up with similar rules to the rules in my form. I should add, I'm confused by your rules on the query date field - why do you reset the field after the query?

Re: Infopath 2013 help with prepopulating a repeating table field.

Hilary Stoupa — Wed, 08 Mar 2017 15:11:12 GMT

I realized you were using a date picker - I used a dropdown because I didn't want to do anything very complex for a sample & you said you had that part working. :) I'll take a look at your form, but I'm guessing the same approach will work as I used in my sample. I think you may not have noticed the conditions on my rule on the course field?

Re: Infopath 2013 help with prepopulating a repeating table field.

MichaelHindle — Wed, 08 Mar 2017 00:37:16 GMT

Hi Hilary, Thank you for your quick replay.

I don't actually have a drop down date box, I have a Datepicker. So like in your example Select the date and the Course Title will go into the Calculated field next to your drop down. That Course will then flow into the Course in the repeating table. But in my form when I change the date the Course changes in Row 1 as well as row 2.

I will save the form and send to you if you like so you can see what I mean.

I feel I will need to do some Xpath coding just not sure where to start.

Thanks again

Re: Infopath 2013 help with prepopulating a repeating table field.

Hilary Stoupa — Wed, 08 Mar 2017 00:04:17 GMT

Hi - I think the rule to set the course on your repeating table may have to go on the repeating table node. See the attached simple sample - I have a rule on the main course field that will only set the first instance, then the rule on the repeating group sets the additional instances when inserted. Hope I understood correctly - save the sample locally, right click, select design & preview to try it out.

Infopath 2013 help with prepopulating a repeating table field.

MichaelHindle — Tue, 07 Mar 2017 23:50:15 GMT

Long time reader first time poster: Newbie question I hope.

I am creating a InfoPath form, from 2 SharePoint List. I have 2 data connections to two separate lists, and one XML schema connection.

The form has a repeating table section and a non repeating table section. In the Non repeating section I have 2 columns a Date picker (Date) and a calculated field (Course). The date reads off the Secondary SharePoint List and the date you select will fill in the calculated field with a Course Name. I have this working no worries. However in the repeating table section I have another textbox field (Course) attached to the Main Data source, I would like to get the Non repeating Course section default to the repeating table course section and hold on that line. So when selecting insert new row the above row will stay what was chosen, but if the date is changed and a new course is added not to change the top row but to stay in the current row.

I have been able to fill the repeating table from the non repeating table, but when inserting new line it carries over.

I hope this makes sense. I have tried using current()/../ but InfoPath 2013 doesn't like the /../

Any suggestions or help would be very much appreciated.

Thanks