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

Avatar

Avatar

raghukaggi

Avatar

raghukaggi

raghukaggi

15-02-2021

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 JavaScripthirarchy1.PNG

 

hirarchy2.PNG

 

Table 1 (Tblmain)(Customer part number)Table 1 (Tblmain)(Customer part number)

 

Table 2(Part Code)Table 2(Part Code)

 

Accepted Solutions (0)

Answers (2)

Answers (2)

Avatar

Avatar

Veena_Vikram

MVP

Avatar

Veena_Vikram

MVP

Veena_Vikram
MVP

16-02-2021

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

Avatar

Avatar

radzmar

MVP

Avatar

radzmar

MVP

radzmar
MVP

16-02-2021

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