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

Avatar

Avatar
Ignite 1
Level 1
raghukaggi
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
Top badges earned
Ignite 1
View profile

Avatar
Ignite 1
Level 1
raghukaggi
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
Top badges earned
Ignite 1
View profile
raghukaggi
Level 1

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)

 

Replies

Avatar

Avatar
Establish
MVP
Veena_Vikram
MVP

Likes

487 likes

Total Posts

1,049 posts

Correct reply

121 solutions
Top badges earned
Establish
Coach
Contributor 2
Seeker
Ignite 5
View profile

Avatar
Establish
MVP
Veena_Vikram
MVP

Likes

487 likes

Total Posts

1,049 posts

Correct reply

121 solutions
Top badges earned
Establish
Coach
Contributor 2
Seeker
Ignite 5
View profile
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
Coach
MVP
radzmar
MVP

Likes

397 likes

Total Posts

2,687 posts

Correct reply

492 solutions
Top badges earned
Coach
Ignite 3
Ignite 1
Validate 1
Give Back 50
View profile

Avatar
Coach
MVP
radzmar
MVP

Likes

397 likes

Total Posts

2,687 posts

Correct reply

492 solutions
Top badges earned
Coach
Ignite 3
Ignite 1
Validate 1
Give Back 50
View profile
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