Question
Pegasystems Inc.
JP
Last activity: 30 May 2017 22:03 EDT
How to copy value in repeating grid to other property
Hi,
What is the best approach to copy a value of the 1st row in repeating grid to a single propery. Below is the screen image. We have a repeating grid where user can freely add and delete rows and our requirement is to copy one of values at the top row (WorkGroupName) to other property (Notes). There are a couple of ways to do this.. Declare Expression set to Notes did not work well. Now I am trying to use "ADVANCED CONFIGURATIONS" in Grid which has a couple of options to run custom activities on row add, delete, and update. I have been playing around these but one of these work completely. I want the Note property to be in synch with any operations (add, delete, change). What is the best approach?
Hi,
What is the best approach to copy a value of the 1st row in repeating grid to a single propery. Below is the screen image. We have a repeating grid where user can freely add and delete rows and our requirement is to copy one of values at the top row (WorkGroupName) to other property (Notes). There are a couple of ways to do this.. Declare Expression set to Notes did not work well. Now I am trying to use "ADVANCED CONFIGURATIONS" in Grid which has a couple of options to run custom activities on row add, delete, and update. I have been playing around these but one of these work completely. I want the Note property to be in synch with any operations (add, delete, change). What is the best approach?
Thanks,
Accepted Solution
Pegasystems Inc.
JP
Hi,
I was able to do this by using Declare Expression - Initially since the Note propery was in our app in Data class and Declare Expression was not working as "Whenever input change" but when I created a Declare Expression in Work Class instead of Data Class I was able to use "Whenever input change" and hence I am now able to copy pagelist(1) property automatically. Using grid activity is too programattic and we should not go for that approach.
Thanks,
TMHCC
GB
Hi Tsuck,
please find the attached screenshot for reference.
On the Grid Properties we have actions tab, select on change,refresh section,run data transform.
In the data transform copy the pagelist(1).property value to the property which ever required as per your requirement.
Hope this help you. If any queries feel free to ask.
Regards,
Bhanu Prakash.
Pegasystems Inc.
JP
No, action is not enough. I want in any grid update synch to happen - for example, delete a row. If I delete the 1st row, I want the 2nd row to be copied and action (change) can't do this. That is why I am asking, and trying declare expression or advanced configurations. Any thoughts?
Thanks,
Accepted Solution
Pegasystems Inc.
JP
Hi,
I was able to do this by using Declare Expression - Initially since the Note propery was in our app in Data class and Declare Expression was not working as "Whenever input change" but when I created a Declare Expression in Work Class instead of Data Class I was able to use "Whenever input change" and hence I am now able to copy pagelist(1) property automatically. Using grid activity is too programattic and we should not go for that approach.
Thanks,