Script to remove all rows in a table except the first

Avatar

Avatar

Geckoz100

Avatar

Geckoz100

Geckoz100

26-04-2016

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);

}

LCD1.png

lCD2.png

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

Magus069

MVP

Total Posts

1.0K

Likes

132

Correct Answer

150

Avatar

Magus069

MVP

Total Posts

1.0K

Likes

132

Correct Answer

150
Magus069
MVP

26-04-2016

Hi there,

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

Hope this will help you!

Answers (1)

Answers (1)

Avatar

Avatar

Geckoz100

Avatar

Geckoz100

Geckoz100

27-04-2016

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.