Refresh Added Column in Data Table by Script
I have a Column A in Table B, and this column is controlled by property control. Then I added this Column A from Table B to Table C marked as Column A'
When I change property control input, Coumn A in Table B would automatically changes accordingly, but Column A' in Table C would not change. In order to solve this, I added a refresh button to manually refresh Table C everytime I change Property Control input using script: Document.Data.Tables['tableC'].Refresh()
The problem is that since Table C data size is very big, it would take very long time to refresh with the script I am using. Is there a script that I could use to only refresh Column A' in Table C, instead of refreshing all columns in Table C?
It would be even better if there is a way that Column A' in Table C could automatically refresh just like Column A in Table B.
So, if that is the case, can you insert the other columns in table B needed for the calculation into table C, then insert calculated column (A) into table C then?
I believe the column properties are carried when after inserted so your expression should work.
Can you share your dxp file?
I am thinking you may have the property control changing value of column A in Table C in addition to column A in Table B.
Any reason you can't have Column A in Table C controlled by the document property directly?