Data Connections

Re: How to add a rule to connect two fields from one sharpoint data source?

RaYvA — Thu, 18 Sep 2014 17:43:58 GMT

That's pretty easy to do, here's an example, you make the default equal to the corresponding field of the data source filtered by the first field (../../../my:group1/my:group2/my:field2[current()/../my:field6 = ../my:field1])

Re: How to add a rule to connect two fields from one sharpoint data source?

Bruce — Wed, 30 Jul 2014 19:53:34 GMT

Thank you very much. Let me edit my original question to see if anyone knows the solution.

Re: How to add a rule to connect two fields from one sharpoint data source?

kleinhansjy — Wed, 30 Jul 2014 19:16:44 GMT

Bruce:
Hi, Kleinhansjy, could you help me again?

Actually I have 5 fields. I need to one rule to connect those five dropdowln list fileds from the sharepoint data source.

For example, the sharepoint list:

ID   Name   Company     Position         Salary

1     Tom       CA              Manager       100,000

2     Bruce     CB              Analyst          75,000

3     Kyle       CC            Programmer     80,000

Let's say the dropdown boxes linked to each column are A, B, C, D, E. When "1" is selected in box A, "Tom", "CA", "Manager", "100,000" will be populated in B, C, D, and E. When "2" is selected in A, "Bruce", "CB", "Analyst", "Position", "Salary" will be populated in B, C, D, E.

How to make this happen? Thanks.

Unfortunately no, I have been trying to do the same thing with no success and asked a question on this forum about that several hours ago. Feel free to follow that here:

http://www.infopathdev.com/forums/p/28657/98499.aspx#98499

To see if anyone responds.

Edit: Actually I will post here if I get a solution to the problem

Re: How to add a rule to connect two fields from one sharpoint data source?

Bruce — Wed, 30 Jul 2014 18:57:00 GMT

Hi, Kleinhansjy, could you help me again?

Actually I have 5 fields. I need to one rule to connect those five dropdowln list fileds from the sharepoint data source.

For example, the sharepoint list:

ID Name Company Position Salary

1 Tom CA Manager 100,000

2 Bruce CB Analyst 75,000

3 Kyle CC Programmer 80,000

Let's say the dropdown boxes linked to each column are A, B, C, D, E. When "1" is selected in box A, "Tom", "CA", "Manager", "100,000" will be populated in B, C, D, and E. When "2" is selected in A, "Bruce", "CB", "Analyst", "Position", "Salary" will be populated in B, C, D, E.

How to make this happen? Thanks.

Re: How to add a rule to connect two fields from one sharpoint data source?

Bruce — Wed, 30 Jul 2014 17:24:16 GMT

Thank you very much. It works, What a magic!

Re: How to add a rule to connect two fields from one sharpoint data source?

kleinhansjy — Wed, 30 Jul 2014 16:35:31 GMT

Make box A have the value set to be the Name and the Display set to be the ID. This can be done under the dropdown's properties. Then add a rule to field A that says when field is not empty do the action -> fill field -> select Box B and write literally '.' without the quotes so just one (dot). The dot is a reference to the value of box A because A is the box the rule is on and '.' is the default reference. The result will be a drop down of ID's in field A which will then populate box B correctly

How to add a rule to connect five fields from one sharpoint data source?

Bruce — Wed, 30 Jul 2014 15:51:09 GMT

I have five dropdown list box on infopath table, and list box entries are all from one data sharepoint library (list). For example, the sharepoint list is:

ID Name Company Position Salary

1 Tom CA Manager 100,000

2 Bruce CB Analyst 75,000

3 Kyle CC Programmer 80,000

Let's say the five dropdown boxes linked to each column are A, B, C, D, E. When "1" is selected in box A, "Tom", "CA", "Manager", "100,000" will be populated in B, C, D, and E. When "2" is selected in A, "Bruce", "CB", "Analyst", "Position", "Salary" will be populated in B, C, D, E.

How to make this happen? Thanks in advance.

When "1" is selected in box A, "Bruce" will be autofilled in box B. "2" is selected, and "Tom" will be autofilled in box B. Thanks in advance.