-
Happy to help. Here's what's happening - the place where you select the field (AccountID) is what gets all the repeating nodes. Then, any formulas you want to apply to the text (like the concat, to add the ";" or the substring-after) go in the single quotes. Here's a good explanation of double eval: ...
-
I think you need to move the substring part of the formula: eval(eval(AccountId, 'concat(substring-after(.,"UP\"), ";")'), "..")
-
Well - no, but if you put them all in the same layout table cell, that should have the same effect. See attached sample - save locally, right click and select design, then preview.
-
No - it would be nice, right? Instead, use multiple drop down controls, each bound to the source you want, then use conditional formatting to display the one you want to use....
-
I think the choices are connected to the control, not the field.... but I could be wrong. Is this a SharePoint list form? Or a 'normal' InfoPath form?
-
So happy I could help, and I'm glad you have it working the way you need it to! Congrats!
-
This is a setting in the data connection. Walk through the data connection again, and on the last (or next to the last, I forget which) there is a checkbox indicating if the query should run when the form opens - deselect that. Then in your rules, set the query field & execute the query to get back just the stuff you want. :)
-
Great job! I always seem to figure stuff out right after I type it up asking for help. :)
-
Hi - You'll need InfoPath Designer on your computer, hopefully you have it installed? Right click manifest.xsf and select "Design". This opens your form in design mode in InfoPath. File > Save As to pack all those files back up into an XSN. :)
-
Thanks for adding the solution for others! :)