Newbie Questions

Re: Displaying a State(as in the United States) Based on the beginning of an Account number

kingspeget — Fri, 28 Aug 2009 12:26:52 GMT

It worked, thank you so much for your help Hilary, and you as well Jimmy. Thanks to you to my form is up and running perfectly, and I am now the only person in my office out of the 500 employees that knows how to use InfoPath. You two have helped me add another skill to my resume (I'm still a beginner, but I'm on the right track) and become an indispensable employee.

Re: Displaying a State(as in the United States) Based on the beginning of an Account number

Hilary Stoupa — Thu, 27 Aug 2009 17:19:15 GMT

Try concat:

concat(substring(account, 1, 3), substring(account, 13, 6))

Re: Displaying a State(as in the United States) Based on the beginning of an Account number

kingspeget — Thu, 27 Aug 2009 16:58:43 GMT

well, in all my infinite glory, i found what the problem was. When i began trying to figure out the solution on my own before i started posting here, i had a rule setup in the account field, once i removed that rule, the code you taught me worked absolutely perfect! I want to thank you agian for all your help and putting up with a newbie like me.With that being said, i have one final question:some of the SysPrins have part of the sysprin at the begining of the number, and part at the end. i want to use substring to strip both parts and ad them together, not as in addition, but at in one after the other, into a new number, i just have no idea what operator i would useCode:substring(account, 1, 3) ? substring(account, 13, 6)

Re: Displaying a State(as in the United States) Based on the beginning of an Account number

kingspeget — Tue, 25 Aug 2009 19:31:00 GMT

It is set to query when the form is opened, i reloaded it to doublecheck

and i should have noted that i changed the name of the XML doc to "System" from "Systems by sys prin" to make it easier for me to test my code

correct me if im wrong, but if it displays the State when i enter in the account number manualy, but not when the users enter it in the my:account field, wouldnt that mean that the XML doc is loaded fine because it displayed the State in the first place, and the problem was with the path to the my:account field?

Re: Displaying a State(as in the United States) Based on the beginning of an Account number

Jimmy — Wed, 19 Aug 2009 22:50:31 GMT

No, I don't think that would be right. That would be make some sense if Row had a sibling called Systems, but I don't see a node called Systems anywhere in your data source. At the point where your red text starts, the XPath is positioned at a Row node assuming the filter found something. And the desired State node is right under the Row node. Are you still getting that error you mentioned? That seems strange because you said that this one worked, albeit without the full functionality you want of course:

xdXDocument:GetDOM("Systems by SysPrin")/Root/Row[SysPrin = substring("8XXXXXXXXXXXXX", 1, 8)]/State

Is it perhaps that your XML data source is not set to "query when the form is opened"?

Re: Displaying a State(as in the United States) Based on the beginning of an Account number

kingspeget — Wed, 19 Aug 2009 20:07:34 GMT

If im looking for the sibling of a note, wouldnt the syntax look more like this:

xdXDocument:GetDOM("Systems By SysPrin")/Root/Row[SysPrin = substring(xdXDocument:get-DOM()/my:CoachingOp/my:SetArea/my:account, 1, 8)]/following-sibling::Systems//Root/Row/State

Re: Displaying a State(as in the United States) Based on the beginning of an Account number

kingspeget — Tue, 18 Aug 2009 19:45:01 GMT

The Error im getting now is:Function 'GetDOM' did not return a value, or it returned a value that cannot be converted to an XSL data type.

I get this error if I delete everything exept GetDOM("Systems By SysPrin") from the function box as well.

This leads me to believe there is something wrong with my XML source document. It may be in how I made it. What I did was create a 3 column table in Excel with SysPrin, State,and KMA as the titles for each Colum, then converted it to XML

Re: Displaying a State(as in the United States) Based on the beginning of an Account number

Jimmy — Sat, 15 Aug 2009 01:55:43 GMT

Thank you. Yes, it looks like my:CoachingOp/my:SetArea/my:account is probably the right path. Did you try putting it all together with get-DOM() and everything?

xdXDocument:GetDOM("Systems By SysPrin")/Row[SysPrin = substring(xdXDocument-get-DOM()/my:CoachingOp/my:SetArea/my:account, 1, 8)]/State

my: might not be the correct namespace if you're basing the form off of a pre-made schema. If the above doesn't work, you can right-click account in the taskpane and pick Copy XPath to find the XPath that InfoPath is expecting.

Re: Displaying a State(as in the United States) Based on the beginning of an Account number

kingspeget — Fri, 14 Aug 2009 17:19:14 GMT

But that would have made sense? why would i have done that?

Sorry, skipped the morning coffie earlier

Re: Displaying a State(as in the United States) Based on the beginning of an Account number

Jimmy — Fri, 14 Aug 2009 16:01:36 GMT

That's not your main data source. Could you change the dropdown there to show me the data source that includes my:account?

Re: Displaying a State(as in the United States) Based on the beginning of an Account number

kingspeget — Fri, 14 Aug 2009 14:07:33 GMT

im pretty sure you are right about that

Re: Displaying a State(as in the United States) Based on the beginning of an Account number

Jimmy — Thu, 13 Aug 2009 23:58:35 GMT

It seems you have edited your post, but in a previous version of your post I saw that you had the path in quotation marks (i.e. "/my:CoachingOp/my:SetArea/my:account"). It should not be in quotation marks.

I'm 95% sure it's a problem with your path to the my:account field. Could you post a screenshot of your main data source layout (from the taskpane)?

Re: Displaying a State(as in the United States) Based on the beginning of an Account number

kingspeget — Thu, 13 Aug 2009 19:15:09 GMT

xdXDocument:GetDOM("Systems by SysPrin")/Root/Row[SysPrin = substring("8XXXXXXXXXXXXX", 1, 8)]/State

This line of code works. however, i cannot get it to take the data from the account field.

Path i used to point the the account text box:

/my:CoachingOp/my:SetArea/my:account

Is there a certian type of data it has to be (double, string, interger)?

Re: Displaying a State(as in the United States) Based on the beginning of an Account number

Jimmy — Thu, 13 Aug 2009 16:03:06 GMT

My mistake. That should be a colon before get-DOM(), not a hyphen:

xdXDocument:get-DOM()

But I'm dubious about the rest of that path. You need the to use the full path to the my:account node, e.g. my:myFields/yaddah yaddah/my:account, paying close attention to capitalization.

Re: Displaying a State(as in the United States) Based on the beginning of an Account number

kingspeget — Thu, 13 Aug 2009 15:53:26 GMT

I want to start off by thanking you for your assistance Jimmy. However, the code is generating an error.

Your Code Suggestion

xdXDocument:GetDOM("Secondary data source name")/Row[SysPrin = substring(xdXDocument-get-DOM()/path to account name in main data source, 1, 5)]/State

Code Suggestion w/ data inserted

xdXDocument:GetDOM("Systems by SysPrin")/Row[SysPrin = substring(xdXDocument-get-DOM()/my:account, 1, 5)]/State

Error Generated'xdXDocument-get-DOM' is not a valid XSLT or XPath function.xdXDocument:GetDOM("Systems by SysPrin")/Row[SysPrin = substring(-->xdXDocument-get-DOM()<--/my:account, 1, 5)]/State