InfoPath Dev

The following code (on click of a button) works perfectly for me to delete a row from a repeating table : var thisNode = eventObj.Source.selectSingleNode("."); thisNode.parentNode.removeChild(thisNode) I need something exactly like this but which will ADD an row to a repeating table. Clicking the" Insert Item" or button is not an option. Basically I want to add a row to a repeating table as soon as some other field (not a part of the repeating table) is populated. If it can be done without code, even better!!! Can you help me please? Infopath 2003 and JScript.

You can add a row to a repeating table with the following single line of code:

 XDocument.View.ExecuteAction("xCollection::insert", "group2_1")

just replace group2_1 with the XMLToEdit value found on the Advanced tab of the repeating table's properties.

BULLS EYE!!! Thanks for this line Jimmy... it has been a huuuge help!!!

Hi Frederik, I would have gone with your solution but Jimmy's one liner saves a lot of work :) - lazy that I am! But thanks a lot anyways! Really appreciate it.

Jimmy:

You can add a row to a repeating table with the following single line of code:

 XDocument.View.ExecuteAction("xCollection::insert", "group2_1")

just replace group2_1 with the XMLToEdit value found on the Advanced tab of the repeating table's properties.

When I try this I get the following unhelpful error:

The following error occured:

InfoPath has encountered an error. The operation failed.
The form's code contains an error.

The following call in the form's code failed: View.ExecuteAction
Unspecified error

The line that causes the fault is:  XDocument.View.ExecuteAction "xCollection::insert", "UID_4"
(There are no parenthesis because this form was developed using VBS)

I have absolutely no idea what this could mean. The only things I can think that might affect it are that I have only just switched to the view when I try to call it... and UID_4 is a repeating section within another repeating section.

Jimmy, Your posts are great resources for the codeless newbie!

Question, does this work in browser forms and can this be a single line of code added to a button outside of the repeating table?

I have a complicated senario i'm working through, where I want to use multiple dropdowns and populate one repeating table. (sum of dropdowns if you will).  With one button click I would like to take the dropdown field and copy it to the next available line in the repeating table. Similar to the "insert item" command in the table but via a button. Everyone complains about the size of the insert and its not intuitive as a button would be to set the data to the repeating table. The proplem with the current button is it writes to the table but it repeats the entire column.

Is there a better way to consolidate dropdown selections into one "repository" so I only promote this consolidated table when the form is publised and my work flow only needs to look at one single. multiple lines of text content type.

Can you follow me?

Hi Jimmy

I am trying to get this code to work without using a button. I have a repeating table used to keep track of a review process. The table contains 3 fields, a date (date of the review), a result field (drop down) and a rich text box used to include action items/ changes needed for approval.

The result field (drop down) has 3 possible selections: Unconditional approval, Conditional approval and No approval. If the review ends with no approval I would like to insert a new row in the table to allow planning of a new review. I have previously used alot of sections and then just hidden them unless they were needed because the previous reviews ended with the result: No approval. However this looked a bit messy.

I can get the code to work as a "Changed event". However it gets stuck in an infinite loop and inserts 15 lines or so. Could you by chance tell me how this could work?

 Best regards

Dennis