InfoPath Dev

Yes and there is no N/A in it at all. As far as the repeating group, the above cascade dropdown filter down the items in the repeating table below. So I need a way to have the selection of the first group and if it is not empty or if they change category to not clear or hide something that is already filled out, but continue to filter down the ...

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 ...

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 ...

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 ...

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 ...

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 = ...

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 ...

 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. ...

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 = ...

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 = ...