General

Re: Restricting Rows in a Repeating Table

Sproctor722 — Wed, 15 Oct 2014 16:12:48 GMT

Both list are secondary data sources so I don't have the option to select All Occurences.

Re: Restricting Rows in a Repeating Table

Sproctor722 — Wed, 15 Oct 2014 15:49:10 GMT

The data from both Table A and Table B are from SharePoint lists.

Re: Restricting Rows in a Repeating Table

Bre Huston — Wed, 15 Oct 2014 15:42:25 GMT

Hello Sproctor722,

Thank you for your question. In regards to a resolution you have several options.

1. You could use a filter on the repeating row in Table A that uses the "If All occurance of 'AccountNumber" from table B != AccontNumber TableA then hide.

2. You could perform a filtered query in order to only return rows of data from table B. In this instance you would want to use a web service query. Is your data coming from sharepoint lists, lists created in another view, or from a data base?

Let me know if you need more details.

Thanks,

Bre

Bre Huston | Project Manager

Qdabra® Software / InfoPathDev.com / FormsQuo / 877.544.2389 main / 425.318.7843 direct

Business Process Automation for Everyone – Streamline data gathering to turn process into knowledge.™

Restricting Rows in a Repeating Table

Sproctor722 — Wed, 15 Oct 2014 15:30:50 GMT

I have a repeating table that I want to conditionally display rows based on the results from another repeating table. For Instance in the repeating table to be displayed I have Account Number and Sales Plant. Based on the restricting repeating table the repeating table to be displayed should only show the two records marked in bold lettering. I've set up conditional formatting rule to hide records in Table A where Account Number and Sales Plant are not equal to Account Number and Sales Plant in Table B, but it doesn't appear to be working as expected. I guess the question is...is this even possible or is there another to only display the records that match? Table A and Table B use separate data connections that are queried then I'm comparing the results from Table A to Table B to determine which records to be displayed.

Sample - Repeating table to be displayed (Table A)

Account Number Sales Plant

1234 Georgia

4567 Texas

1111 Louisiana

8888 Illinois

Sample - Repeating table used to restrict records in the above table (Table B)

Account Number Sales Plant

8910 Florida

4567 Texas

1111 Louisiana