Good morning, I'm using the Cell Update binding in a Power Table and at the moment I set the Row index statically.
I would like to be able to modify the index in some way, maybe with a column value of that specific row, but I don't understand how to do.
I tried to do as explained in the Cell Update view ( "Rows can be specified explicitly by their index or by referencing another column (e.g. "Name=Compressor") but I don't understand how to do it.
If I try in this way I have this error
Your screenshot shows two of each row/column combination.
My goal is to be able to change the order of the rows dynamically. I mean, normally if I have to make the power table works I set it in this way
But if I want to change the order of the rows I should change the 0 with the 1 in the first 3 rows and the 1 with the 0 in the last rows. If I have maybe 20 rows and 10 columns and I have to insert one in the 7th rows it's a problem.
So I would like to understand how to do this in a faster way. Actually I don't understand how to put into pratice the example here, that should be what potentially I need
The cell update binding cannot handle a variable number of operations. You need to generate your entire dataset with a script. Or, perhaps, with the expression functions in my Integration Toolkit module.
Please provide more information on where the value for each cell comes from.
Thanks for the reply, I simply create custom properties and I use the "Insert property value" button to bind them.
For example in this case the power table is called Power Table_PLC
Sounds like a fixed list of rows with a fixed order. What else are you trying to do?
Yes you're right, but for example if one day I will have to insert another PLC in the row [1], I should change the actually [1] to [2] and the insert the new row; and of course if I wll have other 10 rows after that I should increment by one all that rows.
If you expect the list to change, and don't want to manually fix the binding every time, perhaps you should be using the output of the system.devices.listDevices() function.
Actually I have a script to ping the devices because we use Kepserver.
Anyway thanks for the help!
