Script to remove all rows in a table except the first

[Geckoz100]

Please see the screenshots for the question/radio button I'm scripting.  If "No" is clicked I would like it to delete all rows except the first one.  So if the user first clicks Yes, adds a bunch of rows and then clicks No, I want all the extra rows to be deleted.  I'm using the script below but it only deletes half of the rows at a time.  I have to click No 2-3 times to delete all the rows.  Greatly appreciate any help!

// remove extra rows that may have been added
var rowCount = Page2.UserList.Table1._RowUserName.count;
for (var i=0; i<rowCount; i++) {
  Page2.UserList.Table1._RowUserName.removeInstance(i);
}

[Magus069 · Accepted solution]

Hi there,

you can directly use the setInstances method of the instanceManager like the following :

Hope this will help you!

[Geckoz100]

That worked like a charm!  That's what happens when you learn to script through the school of hard knocks, just fumbling your way through it -- I just had to teach myself javascript, so I never discovered this function before.  Really appreciate the help.