InfoPath 2010

Re: Repeating Table HELP!

Hilary Stoupa — Thu, 05 Jan 2017 23:38:00 GMT

As best as I can determine, this happens when we add formatting to a calculated value - the binding gets added to the view & has to be manually removed. If you need a hand after you finish your calc'd values, just attach the form to another reply & I'll help you fix it up.

Re: Repeating Table HELP!

Akuma — Thu, 05 Jan 2017 22:54:46 GMT

Hilary you rock! I have to add some more calculated values, is there something I should avoid doing so I don't run into the issue again?

Re: Repeating Table HELP!

Hilary Stoupa — Thu, 05 Jan 2017 22:48:04 GMT

Hopefully this fixes that up - InfoPath generally seems to do this when formatting is set on the calc'd value & the only real work around I've found is to manually clean up the view.

Re: Repeating Table HELP!

Akuma — Thu, 05 Jan 2017 22:17:38 GMT

Hi Hilary,

please find it attached

Re: Repeating Table HELP!

Hilary Stoupa — Thu, 05 Jan 2017 22:07:00 GMT

http://www.infopathdev.com/blogs/hilary/archive/2012/01/19/ipfs-design-checker-errors-amp-print-preview.aspx

This is an error in IPFS - basically, sometimes InfoPath will add binding info to the view for a calculated value that causes an issue when publishing. You can manually remove this info from the view files. Attach your template under the Options tab in a reply if you need a hand.

Re: Repeating Table HELP!

Akuma — Thu, 05 Jan 2017 22:00:03 GMT

Hi Hilary,

I got the calculated value formulas working along with the preceding-sibling.

An issue I have now is that it is giving me an error when trying to publish " Binding a non repeating control to a repeating field or group is not supported in InfoPath 2010 Web Browser Forms"

do you know how to resolve?

Re: Repeating Table HELP!

Akuma — Thu, 05 Jan 2017 19:26:48 GMT

Hi Hillary,

I am having trouble with the xpath creating a calulated value formula. do you know how I can basically recreate the below:

count(Vertical_x002f_Charter[Title = current()/Title])

I am attempting to count the list of project names(Vertical_x002f_Charter) in a 3rd data connection where the project name = current project name in secondary data connection (Title)

xpaths:

Project Name in secondary data connection (this is the list I am using as repeating table)

/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Title

Project Name in 3rd data connection

/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Vertical_x002f_Charter

UPDATE * I figured it out. May be back with more questions ;)

Re: Repeating Table HELP!

Hilary Stoupa — Thu, 05 Jan 2017 17:27:55 GMT

My sample has both tables bound to the main data source simply to make it easy for someone to preview, etc. The same techniques work regardless of the data source. I'm attaching another sample that uses a secondary (XML) data source - it originally was to demonstrate a different technique, but I made a minor modification to hopefully show this as well.

Re: Repeating Table HELP!

Akuma — Thu, 05 Jan 2017 17:14:03 GMT

Hilary Stoupa:
Oh, I see - so you do need to do something like what is in the sample I attached. You have a data connection to the Projects list? Drag the data fields onto the form, so you have a repeating table, then add a formatting rule to hide any rows if the preceding sibling has a matching name. Then you can use calculated values with formulas similar to the one in the sample I attached to sum data, etc. Attach your template to a reply if you need a hand & I can help you out later today or tomorrow.

Hi Hilary,

oh that is awesome news. i will give it a try and if I get stuck i'll come back and attach. It shouldn't matter that the user is not entering the information in right? Because in mine I would just like to pull the info automatically

Re: Repeating Table HELP!

Hilary Stoupa — Thu, 05 Jan 2017 17:09:58 GMT

Oh, I see - so you do need to do something like what is in the sample I attached. You have a data connection to the Projects list? Drag the data fields onto the form, so you have a repeating table, then add a formatting rule to hide any rows if the preceding sibling has a matching name. Then you can use calculated values with formulas similar to the one in the sample I attached to sum data, etc. Attach your template to a reply if you need a hand & I can help you out later today or tomorrow.

Re: Repeating Table HELP!

Akuma — Thu, 05 Jan 2017 16:59:20 GMT

Hilary Stoupa:
Yes, I meant the calculation would be in InfoPath - just use a calculated value? So - you put the table from the secondary data source on the form, and in one column use a calculated value to show the result?

yes I could do this for that column. Would I have to recreate the calculated value multiple times for each project or is there a way to say "give me the count for each project displayed in this list"

Re: Repeating Table HELP!

Akuma — Thu, 05 Jan 2017 16:56:29 GMT

Hilary Stoupa:
Not to be slow - but the Planned Total Number is from the list, and is per project? So is the number of completed? Wouldn't you just put a calculated value in the column for Number Of Uncompleted that is the Total Number minus the Number Completed?

to clarify none of the columns with the exception of Project Name are in the actual list. There is a multitude of list items for each project and I need to count certain things to get the Totals.

Planned Total = Count all tests where project name is = "a" etc (the associated project)

Actual Total = Count all tests where project name is = "a" and test status column not equal to "N/A"

Number of Completed = count all tests where project name is = "a" and completed column equal to "true"

Re: Repeating Table HELP!

Hilary Stoupa — Thu, 05 Jan 2017 16:47:24 GMT

Yes, I meant the calculation would be in InfoPath - just use a calculated value? So - you put the table from the secondary data source on the form, and in one column use a calculated value to show the result?

Re: Repeating Table HELP!

Akuma — Thu, 05 Jan 2017 16:42:19 GMT

Hi Hilary,

Yes i could do that for that column however that column doesn't actually live in the list yet. I was hoping to be able to do that calculation in infopath verses doing it in SP

Re: Repeating Table HELP!

Hilary Stoupa — Thu, 05 Jan 2017 16:37:54 GMT

Not to be slow - but the Planned Total Number is from the list, and is per project? So is the number of completed? Wouldn't you just put a calculated value in the column for Number Of Uncompleted that is the Total Number minus the Number Completed?