how to retrieve the same data from the columns (Product Part Number) table1 to table2 (PartCode) in Livecycle designer

[raghukaggi]

some fields like Part Code(Table2) remain the same value for all of the subjects whilst it should print the respective values for each item from Product Customer part Number(Table1)(tblmain). I tried to Modify statement but it gave nothing. Any suggestions coding to solve the issue? Formcalc Script or JavaScript

Table 1 (Tblmain)(Customer part number)

Table 2(Part Code)

[VeenaVikraman]

@kautuk_sahni I think this question is not AEM related. Could you help moving this to the right forum ?

[radzmar]

Hi,

you could reference the fields through a script.

Assuming the row "Itemrow" in "table2" is repeating as often as the row "rowMain" of "tblMain", all you need is a bit FormCalc in the calculate event of the  field "partcode" then:

$ = bdymain.tblMain.rowMain[$.parent.parent.index].colProduct

[raghukaggi]

Table 1:

How to read all the rows data from the Table 1 to Table 2

Table 2:

with the below script i can able to read only one row

$.rawValue=frmTableBlock.tblTable.rowTableSection.rowTableItem[$.parent.parent.index].colLine.rawValue

can you please help to read multiple rows from Table 1 to Table 2

Thanks 

Raghu

[Magus069]

Hi there,

I think you are in the right direction. 

The only thing you might want to change is how you access the instance of rowTableItem.

To be able to access a specific instance of that row, you need to use the resolveNode method.

Simply replace the following:

rowTableItem[$.parent.parent.index]

for the following:

resolveNode("rowTableItem[" + $.parent.parent.index + "]")

I hope this will do the job for you.