Browser Forms

Re: Cascading Drop-down Value not Auto-populating Additional Fields

Jacob Russ — Thu, 15 Nov 2018 15:54:24 GMT

Hey Hilary,

"See attached. I've made a guess at the correct filter for setting the edoc notes from the default values." Excellent work, thank you so much. Using this formula, I managed to populate all 20 fields - even the 16 Edoc fields off of the check box. :)

"I added your default data source at the bottom of the form - is the Country there text or an ID? I'm guessing it is text...." It is indeed text.

"I put the value of your Country4 field under the dropdown so you can see it - it is going to be an ID." It is indeed an ID, and this trick I think I might end up finding useful moving forward, thank you!

"If you also put the data fields from the Countries list on your form (since that is the list the dropdown uses for its values) you'd be able to visually see if there is a country in that list that matches the country in the default values list." Thanks, I will play with this moving forward. I was indeed able to drag and drop the entire folder of fields from Countries onto the form as a repeating table. Very interesting, I knew (?!?) that I had the same values in both lists, but do think that this can potentially provide some enhanced visibility during form development.

Thank you again for all of the help, you - and InfoPath dev - have really helped me out tremendously on this project. I cannot thank you enough!!!!!!

-Jake

Re: Cascading Drop-down Value not Auto-populating Additional Fields

Hilary Stoupa — Wed, 14 Nov 2018 16:10:15 GMT

See attached. I've made a guess at the correct filter for setting the edoc notes from the default values. I added your default data source at the bottom of the form - is the Country there text or an ID? I'm guessing it is text.... I put the value of your Country4 field under the dropdown so you can see it - it is going to be an ID. If you also put the data fields from the Countries list on your form (since that is the list the dropdown uses for its values) you'd be able to visually see if there is a country in that list that matches the country in the default values list.

Re: Cascading Drop-down Value not Auto-populating Additional Fields

Jacob Russ — Wed, 14 Nov 2018 15:58:14 GMT

Sorry for the confusion - I originally was getting values from Default-Values based on Sales Org for those four fields (Payment Terms, Inco Terms, etc.), but now everything (those 4 fields, as well as the 16 Edoc fields) needs to be from Country instead.

"Are you saying you need to get a value from Default-Values where the country matches the country selected in the form?" Yes

"...or where they also match on sales org?" No

"One thing that may help you with the filters is to just drag the secondary data sources onto the form temporarily so you can see what the actual values in the various columns are.... maybe do the same with some of the main DS stuff that is in dropdowns - put text fields on the form so you can see the actual value rather than the dropdown display value."

I have read other posts where you have spoken of doing this, and it sounds like something that I need to understand how to do and play with, since I haven't done it before. Needless to say, I am running out of time on this project and need to deliver it in one week. :(

Re: Cascading Drop-down Value not Auto-populating Additional Fields

Hilary Stoupa — Wed, 14 Nov 2018 15:34:44 GMT

So - just to make sure I understand what you are trying to do - you need to get values from Default Values based on Country and Sales Org? I'm sorry, I'm just super confused at this point about the data relationships. Are you saying you need to get a value from Default-Values where the country matches the country selected in the form or where they also match on sales org? One thing that may help you with the filters is to just drag the secondary data sources onto the form temporarily so you can see what the actual values in the various columns are.... maybe do the same with some of the main DS stuff that is in dropdowns - put text fields on the form so you can see the actual value rather than the dropdown display value.

Re: Cascading Drop-down Value not Auto-populating Additional Fields

Jacob Russ — Wed, 14 Nov 2018 15:12:37 GMT

Yeah, that's the formula I have been trying to get to work on both the check box as well as the drop-down Country4, to no avail. :) Which simply means no value is populated in Edoc_Delivery_Notes when the check box is ticked, nor when a value has been selected from Country4. The formula resolves fine without any errors otherwise. I am wondering if the complexity I have implemented, using cascading filters for Country and Sales Org (based on Region and Country respectively) utilizing lookup columns in two different SharePoint list data connections is making it hard for me to connect to the Default-Values SharePoint list for these additional 16 (sorry - not 8, not 18 - all 16 Edoc fields).

Also, I am able to get Payment Terms, Inco Terms 1, Inco Terms 2, and Shipping Conditions to all auto-populate from Sales Org, but when applying the new formula, I am unable to get default values from Country for some reason.

xdXDocument:GetDOM("Default-Values")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Payment_Terms[../d:Sales_Org = xdXDocument:GetDOM("Sales_Orgs1")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:ID[../d:SOCountryLook = xdXDocument:get-DOM()/dfs:myFields/dfs:dataFields/my:SharePointListItem_RW/my:Country4]]

Re: Cascading Drop-down Value not Auto-populating Additional Fields

Hilary Stoupa — Tue, 13 Nov 2018 22:14:33 GMT

My error - didn't realize there were multiple fields that include Edoc Delivery Notes - I grabbed the XPath from the one with "Email" in the name. This formula resolves without errors: xdXDocument:GetDOM("Default-Values")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Edoc_x002d_Delivery_Notes[../d:Sales_Org = xdXDocument:GetDOM("Sales_Orgs1")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:ID[../d:SOCountryLook = xdXDocument:get-DOM()/dfs:myFields/dfs:dataFields/my:SharePointListItem_RW/my:Country4]] but I don't know whether that's the issue you are having - when you say you have tried "to no avail" what does that mean? The formula doesn't resolve? The rule doesn't execute? The rule does have a condition to only execute when the target field is equal to true... which based on the checkbox properties, should happen when the checkbox is ticked.

Re: Cascading Drop-down Value not Auto-populating Additional Fields

Jacob Russ — Tue, 13 Nov 2018 21:56:36 GMT

I grabbed the XPath from Edoc-Delivery_Notes in Default-Values, and it looks like this:

/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Edoc_x002d_Delivery_Notes

So, missing the "_x002d_" that you had appended to the end? (I didn't realize that underscores were acceptable but that hyphens would be replaced here)

Regardless, I have tried applying both of our versions of the rule to the "Use_Default_Edoc_Values" (checkbox), and also to Country4 (drop down list box) to no avail.

Note that I have not so far been successful with triggering rules like this from checkboxes, even though that is really what I want to do here if I can...

Re: Cascading Drop-down Value not Auto-populating Additional Fields

Hilary Stoupa — Tue, 13 Nov 2018 18:31:31 GMT

Your Default Values list doesn't have a field with the XPath you are using. I think /dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Edoc_x002d_Delivery_Notes_x002d_ is the field you want.... copy just the filter (the part with the square braces), use the field selector to pick your field from default values, then just paste the filter expression in. :-)

Re: Cascading Drop-down Value not Auto-populating Additional Fields

Jacob Russ — Tue, 13 Nov 2018 17:36:52 GMT

Your formula contains no errors, but when I change Payment_Terms to Edoc-Delivery_Notes as below, I get the following error:

"xdXDocument:GetDOM("Default-Values")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Edoc-Delivery_Notes" does not point to a valid location path of a field or group.

xdXDocument:GetDOM("Default-Values")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Edoc-Delivery_Notes[../d:Sales_Org = xdXDocument:GetDOM("Sales_Orgs1")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:ID[../d:SOCountryLook = xdXDocument:get-DOM()/dfs:myFields/dfs:dataFields/my:SharePointListItem_RW/my:Country4]]

They are both in the Default-Values SharePoint list, so I am uncertain what I am doing wrong.

Re: Cascading Drop-down Value not Auto-populating Additional Fields

Hilary Stoupa — Tue, 13 Nov 2018 00:34:20 GMT

So, given your earlier post where you have an XPath for getting the sales org based on the country, would this work for the Payment_Terms (for example): xdXDocument:GetDOM("Default-Values")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Payment_Terms[../d:Sales_Org = xdXDocument:GetDOM("Sales_Orgs1")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:ID[../d:SOCountryLook = xdXDocument:get-DOM()/dfs:myFields/dfs:dataFields/my:SharePointListItem_RW/my:Country4]]

Re: Cascading Drop-down Value not Auto-populating Additional Fields

Jacob Russ — Sat, 10 Nov 2018 22:06:21 GMT

Hey Hillary! :)

I have attached my latest XSN...the control where I am looking to trigger the auto-populating Edoc values is called "Use_Default Edoc_Values". The first field of 18 that I want to auto-populate is called "Edoc_Delivery_Notes".

Thank you SO MUCH for taking a look! :) :) :)

Re: Cascading Drop-down Value not Auto-populating Additional Fields

Hilary Stoupa — Fri, 09 Nov 2018 22:27:38 GMT

Mind attaching your latest XSN and pointing me to one of the controls with rules where you are having trouble? I do so much better understanding when I have a form to look at. :)

Re: Cascading Drop-down Value not Auto-populating Additional Fields

Jacob Russ — Fri, 09 Nov 2018 20:48:30 GMT

So...thanks again! I have been able to successfully auto-populate 4 fields from Sales Org. Here is the XPath for one of them (Payment Terms):

xdXDocument:GetDOM("Default-Values")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Payment_Terms[../d:Sales_Org = xdXDocument:GetDOM("Sales_Orgs1")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Title[../d:ID = xdXDocument:get-DOM()/dfs:myFields/dfs:dataFields/my:SharePointListItem_RW/my:SalesOrg7]]

Default-Values: SharePoint List

Payment_Terms: the column in Default-Values which I am populating into the corresponding field in the form

Sales_Org: the column in the data connection Sales_Orgs1

Sales_Orgs1: the data connection mentioned above, which also contains a lookup column SOCountryLook, that points to a SharePoint List called Countries (which contains a column called Country)

SalesOrg7: the field in the form

So...clearly I am not fluent in XPath syntax. I have 8 more fields I want to auto-populate values for, but off of Country values instead of Sales Org values. These are all values that can also be found in the Default-Values SharePoint List.

Here is the XPath for setting the Sales Org from the Country:

xdXDocument:GetDOM("Sales_Orgs1")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:ID[../d:SOCountryLook = xdXDocument:get-DOM()/dfs:myFields/dfs:dataFields/my:SharePointListItem_RW/my:Country4]

Country4: the field in the form

Country: the name of the country column in Default-Values (in case that is needed)

Any ideas? I simply can't seem to make this work...

-Jake

Re: Cascading Drop-down Value not Auto-populating Additional Fields

Hilary Stoupa — Fri, 14 Sep 2018 16:31:17 GMT

You need to filter on both, I think, looking at your data. You could probably set the country query field in your new list data connection and query that when the user changes the country, in order to only return data pertinent to that country. Then in your XPath for your rules to set field values you could add the Sales Org filter.

Re: Cascading Drop-down Value not Auto-populating Additional Fields

Jacob Russ — Fri, 14 Sep 2018 16:24:17 GMT

The reality of the situation is that many of these fields are country driven, since there is a many to one relationship between Country and Sales Org, as you can see by the screenshot displaying so many Puerto Rico Sales Orgs for Latin American countries. To answer your question, after conferring with another team member, I modified Payment_Terms, Inco_Terms1, Inco_terms2, and Shipping_Conditions for the screenshot, in case there is sensitive Sales Territory information here. For the sake of this exercise, the values in all columns can potentially vary by country. I am still hoping that filtering by Sales Org is a viable option? Or do I need to filter on Country now?

-Jake