InfoPath Dev

Can you tell me how you want the form to behave? Should the user enter all their data, then click the button to get data for all rows? Or do you want them to click the button to populate each row? Here's a code sample that may help you iterate through the main nodes and set values: ...

Any time you requery your secondary data connection, it will only contain the data you have queried for. You could copy the queried data to the main data source for each row - then you don't have to query for all the questions each time, and the data returned to your form is preserved (stored in the main data source). I'd probably do that. ...

If you always want to query for the last question ID you could use: xMain.SelectSingleNode("/my:myFields/my:group1/my:group2[last()]/my:QuestionID", nSpace).Value. But otherwise, if your button is not in the repeating table, I'm not sure how we'd guess what question id to run the query for :)

Hi! so your button is in the repeating table? Your XPath in this line will always return the first node: xMain.SelectSingleNode("/my:myFields/my:group1/my:group2/my:QuestionID", nSpace).Value. That's going to get you the first QuestionID, always, as you have found. Good news - your button is context aware and knows what instance of ...

If you use GetXml /dsname=YourDataSourceName in the qRules command field, XML should be returned in the Result field - that would be at least a start to figuring out what's up.... is the XML returned what you expect?

First, your tag game is on point. Second - I wonder if the data returned from the stored procedure changed at all? Perhaps the data connection fields don't align with what is currently being returned from the stored procedure? You can use the qRules command: GetXml /dsname=YourDataSourceName to get back the actual XML in the data connection ...

Ok, sounds like I did understand that. So, as I mentioned, the issue is with this data string - "ST/BL/CV/EL". There is no easy way in InfoPath to match that to the values like "CV", "EL" and so on in your email list. However, if they are unique, we could maybe use contains. I'm worried about a false positive with ...

So - I'm sorry, I'm a little confused. The user selects a Doc No in a dropdown. Based on the slash delimited distribution matrix value, you need to get the emails back from the emails list? This may be pretty tricky - because there isn't anything built into InfoPath to separate those values in the distribution matrix column to figure ...

I probably wouldn't use the same field for both - unless you never need a value from both in there at the same time? Why not add an additional hidden field for the External Approval section?

I would think promoting just the display name would be adequate, right? It looks like you have a "submit" button in the repeating section.... so perhaps you could add another field for the "latest person" and promote that. The new field should be in a non repeating group in the schema, and won't need to be on the form. Then ...