Adobe LiveCycle (Archived)

bobbych · 5/16/17

I have made a Dynamic form in LC ES2 which includes buttons to add and remove table rows and other buttons to add and remove subforms.

I have no JavaScript knowledge and have used you tube and trial and error to create the form but i would like a new feature but cant figure it out.

I have a table in the form which stars with 1 blank row. in the first cell i have pre poulated it with number 1 for row 1. when a particular button is pressed to add a new row i want the new row to be numbered 2 and so on.

Any help would be appreciated

here is the code for a stripped down sample.

<ui>

</border>

</textEdit>

</ui>

<value>

<text>Text Field</text>

</value>

</caption>

</script>

</event>

<value>

</value>

</field>

<ui>

</border>

</textEdit>

</ui>

<value>

<text>Text Field</text>

</value>

</caption>

</script>

</event>

<value>

</value>

</field>

<ui>

</textEdit>

</ui>

<value>

</exData>

</value>

</draw>

<ui>

</ui>

<value>

<text>RAF Safety Centre Form 9 Iss 5 Dated 20 Mar 2017</text>

</value>

</draw>

<?templateDesigner expand 0?></pageArea>

<?templateDesigner expand 0?></pageSet>

</border>

</traversal>

<ui>

</textEdit>

</ui>

<value>

<text>Personnel Information</text>

</value>

</draw>

<edge/>

</border>

<edge/>

</border>

<ui>

</ui>

<value>

<text>Number</text>

</value>

</draw>

<edge/>

</border>

</draw>

<edge/>

</border>

<ui>

</ui>

<value>

</value>

</draw>

<edge/>

</border>

<ui>

</ui>

<value>

<text>Hours Last 30 Days</text>

</value>

</draw>

<edge/>

</border>

<ui>

</ui>

<value>

<text>Hours Last 3 Months</text>

</value>

</draw>

<edge/>

</border>

<ui>

</ui>

<value>

<text>Hours on Type</text>

</value>

</draw>

<edge/>

</border>

<ui>

</ui>

<value>

<text>Total Hours</text>

</value>

</draw>

</border>

<?templateDesigner expand 1?></subform>

<?templateDesigner rowpattern first:1, next:1, firstcolor:f0f0f0, nextcolor:ffffff, apply:0?>

<?templateDesigner expand 1?></subform>

<ui>

</ui>

<value>

<text>Add/Remove Staff</text>

</value>

</draw>

<ui>

</ui>

<value>

</value>

</caption>

<fill>

</fill>

</border>

//+ Type: Action

//+ Result1: AddInstance("$Node2")

//+ Node2: form1[0].Header[0].PersonnelInfo[0].Staff[0].ACDetails[0]

//+ Node1: form1[0].Header[0].PersonnelInfo[0].Staff[0].AircrewTitle[0].AddAC[0]

//+ Condition1: Button("$Node1","click")

//+ ActionName: AddAC.click

this.resolveNode('Staff._ACDetails').addInstance(1);

if (xfa.host.version < 8) {

xfa.form.recalculate(1);

}

//-

</script>

</event>

</field>

<ui>

</ui>

<value>

</value>

</caption>

<fill>

</fill>

</border>

//+ Type: Action

//+ Result1: RemoveInstance("$Node2","lastindex","")

//+ Node2: form1[0].Header[0].PersonnelInfo[0].Staff[0].ACDetails[0]

//+ Node1: form1[0].Header[0].PersonnelInfo[0].Staff[0].AircrewTitle[0].RemAC[0]

//+ Condition1: Button("$Node1","click")

//+ ActionName: RemAC.click

this.resolveNode('Staff._ACDetails').removeInstance(this.resolveNode('Staff._ACDetails').count - 1);

if (xfa.host.version < 8) {

xfa.form.recalculate(1);

}

//-

</script>

</event>

</field>

<?templateDesigner expand 1?></subform>

<ui>

<edge/>

</border>

</numericEdit>

</ui>

</field>

<ui>

</border>

</textEdit>

</ui>

<value>

</value>

</field>

<ui>

<fill/>

</border>

</choiceList>

</ui>

<text>Aircraft - Ground Handler</text>

<text>Aircraft - Maintenance/Engineer</text>

<text>Aircraft - Maintenance/Supervisor</text>

</items>

</field>

<?templateDesigner expand 1?>

<ui>

</border>

</numericEdit>

</ui>

</field>

<ui>

</border>

</numericEdit>

</ui>

</field>

<ui>

<edge/>

</border>

</numericEdit>

</ui>

</field>

</subform>

<?templateDesigner expand 1?></subform>

</traversal>

<?templateDesigner expand 1?></subform>

<?templateDesigner expand 1?>

</subform>

MinusZero · 5/30/17

Hi bobbych,

Whoa, code overload. Didn't really help much seeing all the code, but the problem you have is easily solved.

In my example i have a table (Table1) with a repeating row (Row1). There is also a Button to add rows (Button1) and remove rows (Button2). The first cell of the table row has a Numeric Field.

In the NumericField Initialize code place:

//when initialised give this cell the value of the row instance

//whenever a new row is created, the new row will be given the current value of the instance manager.

this.rawValue = Table1.Row1.instanceManager.count;

Click the add button to add an automatically numbered row.

There is a 'but' though and quite a big one.

If you remove rows, the numbers will not renumber automatically. In this example, because the repeated row instance count has reduced, if i added a new row now, the new row would also have the number 4.

You will need to add code to handle renumbering. Doing this means you can no longer use the initialisation numbering. There is a number of ways to do it, but without using 'if' logic, you need to estimate the amount of rows that might be added and add enough code for it.

Button1: click (Add Row)

this.resolveNode('Table1._Row1').addInstance(1);
if (xfa.host.version < 8) {
xfa.form.recalculate(1);
}

//this code gets the total instances, subtracts the total instances and then adds a number based on the row.

//if you haven't used instance coding before, the [0] is the instance or the first row of your table. This [0] is placed after the repeated item, in this case, Row1.

//for each row you will need to increment the instance number and the added value.

//an advantage of this code is that it wont throw an error if the row doesn't exist so you can make as many as you like.

this.resolveNode("Table1.Row1[0].NumericField1").rawValue = Table1.Row1.instanceManager.count - Table1.Row1.instanceManager.count + 1;
this.resolveNode("Table1.Row1[1].NumericField1").rawValue = Table1.Row1.instanceManager.count - Table1.Row1.instanceManager.count + 2;
this.resolveNode("Table1.Row1[2].NumericField1").rawValue = Table1.Row1.instanceManager.count - Table1.Row1.instanceManager.count + 3;

Button2: click (Remove Row)

this.resolveNode('Table1._Row1').removeInstance(this.parent.index);

if (xfa.host.version < 8) {

xfa.form.recalculate(1);

}

I have found in the past that when removing rows, that ends the code. As a result, I cant renumber automatically.

The easiest way to renumber after removing a row is to add another button (Button 3) with this code:

Button3: click (Renumber Rows)

this.resolveNode("Table1.Row1[0].NumericField1").rawValue = Table1.Row1.instanceManager.count - Table1.Row1.instanceManager.count + 1;
this.resolveNode("Table1.Row1[1].NumericField1").rawValue = Table1.Row1.instanceManager.count - Table1.Row1.instanceManager.count + 2;

this.resolveNode("Table1.Row1[2].NumericField1").rawValue = Table1.Row1.instanceManager.count - Table1.Row1.instanceManager.count + 3;

You will then have a button to add rows & renumber, a button to remove rows and a button to renumber rows after removal.

If you need more help, let me know. Please mark as correct if it helps.

View solution in original post

MinusZero · 5/30/17

Hi bobbych,

Whoa, code overload. Didn't really help much seeing all the code, but the problem you have is easily solved.

In my example i have a table (Table1) with a repeating row (Row1). There is also a Button to add rows (Button1) and remove rows (Button2). The first cell of the table row has a Numeric Field.

In the NumericField Initialize code place:

//when initialised give this cell the value of the row instance

//whenever a new row is created, the new row will be given the current value of the instance manager.

this.rawValue = Table1.Row1.instanceManager.count;

Click the add button to add an automatically numbered row.

There is a 'but' though and quite a big one.

If you remove rows, the numbers will not renumber automatically. In this example, because the repeated row instance count has reduced, if i added a new row now, the new row would also have the number 4.

You will need to add code to handle renumbering. Doing this means you can no longer use the initialisation numbering. There is a number of ways to do it, but without using 'if' logic, you need to estimate the amount of rows that might be added and add enough code for it.

Button1: click (Add Row)

this.resolveNode('Table1._Row1').addInstance(1);
if (xfa.host.version < 8) {
xfa.form.recalculate(1);
}

//this code gets the total instances, subtracts the total instances and then adds a number based on the row.

//if you haven't used instance coding before, the [0] is the instance or the first row of your table. This [0] is placed after the repeated item, in this case, Row1.

//for each row you will need to increment the instance number and the added value.

//an advantage of this code is that it wont throw an error if the row doesn't exist so you can make as many as you like.

this.resolveNode("Table1.Row1[0].NumericField1").rawValue = Table1.Row1.instanceManager.count - Table1.Row1.instanceManager.count + 1;
this.resolveNode("Table1.Row1[1].NumericField1").rawValue = Table1.Row1.instanceManager.count - Table1.Row1.instanceManager.count + 2;
this.resolveNode("Table1.Row1[2].NumericField1").rawValue = Table1.Row1.instanceManager.count - Table1.Row1.instanceManager.count + 3;

Button2: click (Remove Row)

this.resolveNode('Table1._Row1').removeInstance(this.parent.index);

if (xfa.host.version < 8) {

xfa.form.recalculate(1);

}

I have found in the past that when removing rows, that ends the code. As a result, I cant renumber automatically.

The easiest way to renumber after removing a row is to add another button (Button 3) with this code:

Button3: click (Renumber Rows)

this.resolveNode("Table1.Row1[0].NumericField1").rawValue = Table1.Row1.instanceManager.count - Table1.Row1.instanceManager.count + 1;
this.resolveNode("Table1.Row1[1].NumericField1").rawValue = Table1.Row1.instanceManager.count - Table1.Row1.instanceManager.count + 2;

this.resolveNode("Table1.Row1[2].NumericField1").rawValue = Table1.Row1.instanceManager.count - Table1.Row1.instanceManager.count + 3;

You will then have a button to add rows & renumber, a button to remove rows and a button to renumber rows after removal.

If you need more help, let me know. Please mark as correct if it helps.

delalou · 4/15/22

Can you use alphanumeric (A, B, C, etc) to number the rows instead of numbers? If so, how does it work?

Magus069 · 4/19/22

Hi delalou,

if you wish to achieve this using letters, you can use this script in the calculate event of the field you wish to display them.

if ((Row1.index+1)/ 26 <= 1){
        //Display a single letter if row index if below Z
	String.fromCharCode(65+Row1.index);
} else{
        //Display double digit letters up to ZZ (702 rows max)
	intFirstLetter = Math.floor(Row1.index/26)-1;
	intSecondLetter = Row1.index%26;
	String.fromCharCode(65+intFirstLetter, 65 + intSecondLetter);
}

I hope this will help, don't hesitate to ask any questions.

bobbych · 6/13/17

Thanks MinusZero. that helped a lot. I used your info and some other infor and managed to solve my problem.

Adobe LiveCycle (Archived)

Auto number new repeating rows

Learn

Documentation

Community

Support

Resources

Adobe account

Adobe