Code

Re: Update fields from drop down not working

Hilary Stoupa — Wed, 27 Mar 2013 01:08:37 GMT

Wonderful, glad to hear it!

Re: Update fields from drop down not working

Zubertron — Tue, 26 Mar 2013 23:35:03 GMT

Works perfectly now :) Thanks a bunch for your help!!

Re: Update fields from drop down not working

Zubertron — Tue, 26 Mar 2013 23:26:17 GMT

Ah, yes... oops. My bad. I was getting it mixed up where the filter should go and I didn't look at your example properly!

Re: Update fields from drop down not working

Hilary Stoupa — Tue, 26 Mar 2013 23:02:28 GMT

What are you trying to do there? Are you setting a rule to set Course Name? I just meant to use it as a filter for the selected row for the drop downs - should already be in place in the sample I attached to my reply? You are getting true or false because that is what the XPath you have pasted above evaluates to - either they are equal or they are not... :)

Re: Update fields from drop down not working

Zubertron — Tue, 26 Mar 2013 22:53:50 GMT

Thanks again Hilary!

I think I'm struggling a little getting used to the syntax. I know roughly how it should look but just not quite there.

The Course duration is working well, thank you. I tried the CourseGroup filter but came across some syntax type errors - not a valid path to CourseGroup so I ended up using this: xdXDocument:GetDOM("Courses")/COURSES/COURSECODE/COURSEGROUPNAME = current()/../my:CourseGroup

The /../my:CourseGroup seemed to do the trick but now the select a course returns a "false" and "true" value into the drop down...

Re: Update fields from drop down not working

Hilary Stoupa — Tue, 26 Mar 2013 22:06:06 GMT

So - your Course dropdown uses CourseName for the value. Your rule for setting course duration is depending on @Name instead.

You want:

xdXDocument:GetDOM("Courses")/COURSES/COURSECODE/DURATION[../COURSENAME = current()]

For the filter on Course Group, the expression looks like:

../COURSEGROUPNAME = current()/my:CourseGroup

Re: Update fields from drop down not working

Zubertron — Tue, 26 Mar 2013 21:54:53 GMT

Attached is the template with the xml data files. As you can see, there is a repeating table with individual courses and values that populate into other areas. What I want is to simply select a course group to show only courses within that group and for the duration to be updated in the CourseDuration field. Thanks for your help!!

Re: Update fields from drop down not working

Hilary Stoupa — Tue, 26 Mar 2013 14:08:07 GMT

It all depends on where you are using the formula. If you'd attach a template under the options tab, I'd be happy to help you with it.

Re: Update fields from drop down not working

Zubertron — Tue, 26 Mar 2013 00:49:47 GMT

Thanks Hilary :)

I just tried using the same formula on a repeating section but it's not working. Is there another approach to a repeating section for this? Thanks again.

Re: Update fields from drop down not working

Hilary Stoupa — Tue, 26 Mar 2013 00:35:58 GMT

So ../@NAME is a relative XPath. We are at CONTACTPERSON - so ../ takes us back to COMPANY, and @NAME gets us the company name attribute - @NAME is an attribute on COMPANY. Here's a blog post of mine with some links to learning XPath resources. I think what you are calling self containing tags are attributes. In the sample above, Player is an element, ID, FirstName, etc - those are attributes.

Re: Update fields from drop down not working

Zubertron — Tue, 26 Mar 2013 00:12:52 GMT

Thank you Hilary! That worked :)

Yes, a zip file... Brain is too focused on Infopath right now.

So, the ../@NAME is referencing the path to the parent node? I just want to get this clear in my head so I can to the other similar forms. Does it matter how the XML is formatted in terms of attributes or elements? I have seen a lot of examples using, what I call self containing tags like: < Player ID="10" FirstName="Chipper" LastName="Jones" No="10" Position="3B" / >

Thanks for your time and assistance :)

Re: Update fields from drop down not working

Hilary Stoupa — Mon, 25 Mar 2013 23:55:57 GMT

Yup - you can always put files in a zip and attach that as well.

So - put a rule on Company - no condition - to set a field's value. The field you are going to set is the main data source field for the contact person.

The XPath to get the right contact name should be:

xdXDocument:GetDOM("Contacts")/CONTACTS/COMPANY/CONTACTPERSON[../@NAME =current()]

You could also do this with the UI in IP - select the CONTACTPERSON field in the secondary data source, and then add a Filter (using the Filter button). The first dropdown for the filter would be the @NAME attribute on COMPANY. The middle would be is equal to and the last one, you'd select a field or group, go to the main data source, and select the main data source field bound to the drop down.

Re: Update fields from drop down not working

Zubertron — Mon, 25 Mar 2013 23:09:08 GMT

Can't seem to attach more than one file at a time!

Re: Update fields from drop down not working

Zubertron — Mon, 25 Mar 2013 23:03:43 GMT

Hi Hilary, I have attached my contact XML tables and a screen shot of part of my form. As you can see, there is a drop down to select a company. When the company is selected, the contact person and their details needs to be loaded into the relevant fields. I hope this makes sense?

Re: Update fields from drop down not working

Hilary Stoupa — Mon, 25 Mar 2013 14:29:22 GMT

So - in your drop down, what is the field that is being used for the value? Is it ContactPerson? Your current XPath says "I'd like the CONTACTPERSON field from Contacts where CONTACTPERSON is equal to the field bound to the dropdown list". Is this being used in a rule or a default value?

It would be helpful to know:

Where the XPath is being used
What the value field is in your dropdown control

Or even just a description of the data you need. You can even just attach your template under the options tab if you want to make it super easy for me to give you a hand. :)