# Power table OnCellEdit update tag with user input

**URL:** <https://forum.inductiveautomation.com/t/power-table-oncelledit-update-tag-with-user-input/48376>\
**Category:** Ignition\
**Created:** [June 30, 2021, 5:28pm UTC](https://forum.inductiveautomation.com/t/power-table-oncelledit-update-tag-with-user-input/48376 "2021-06-30T17:28:39Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![dzohner](https://avatars.discourse-cdn.com/v4/letter/d/0ea827/32.png) [@dzohner](https://forum.inductiveautomation.com/u/dzohner)\
**Post date:** [June 30, 2021, 5:28pm UTC](https://forum.inductiveautomation.com/t/power-table-oncelledit-update-tag-with-user-input/48376/1 "2021-06-30T17:28:39Z")

</div>

I’m trying to use a Power table that allows for user input for set points.

Currently I have the tag in the Cell Update Cell Bindings which displays the current tag value in the cell.

I would like the operator to be able to click on the cell type in the new value and have it update the tag value similar to the bi-directional feature found on other components.

I have search this forum read through each post. I am admittedly weak with scripting. I have tried various scripts I have found on here but have gotten nothing to work.

Does anyone have a code snippet I could use to work from in implementing this?

Thanks.

---

<div class="post-metadata">

**Author:** ![Gaurav.Shitole](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/gaurav.shitole/32/72050_2.png) [@Gaurav.Shitole](https://forum.inductiveautomation.com/u/Gaurav.Shitole)\
**Post date:** [July 1, 2021, 5:03am UTC](https://forum.inductiveautomation.com/t/power-table-oncelledit-update-tag-with-user-input/48376/2 "2021-07-01T05:03:16Z")

</div>

Write this script on **onCellEdited** extension:

`self.data = system.dataset.setValue(self.data, rowIndex, colIndex, newValue.value)`

---

<div class="post-metadata">

**Author:** ![dzohner](https://avatars.discourse-cdn.com/v4/letter/d/0ea827/32.png) [@dzohner](https://forum.inductiveautomation.com/u/dzohner)\
**Post date:** [July 1, 2021, 6:11pm UTC](https://forum.inductiveautomation.com/t/power-table-oncelledit-update-tag-with-user-input/48376/3 "2021-07-01T18:11:52Z")

</div>

Thanks

---

<div class="post-metadata">

**Author:** ![dzohner](https://avatars.discourse-cdn.com/v4/letter/d/0ea827/32.png) [@dzohner](https://forum.inductiveautomation.com/u/dzohner)\
**Post date:** [July 1, 2021, 6:14pm UTC](https://forum.inductiveautomation.com/t/power-table-oncelledit-update-tag-with-user-input/48376/4 "2021-07-01T18:14:52Z")

</div>

This solution worked for me, I went with the hidden column approach. To anyone that comes across this later I used a hidden column as a string and wrote in the tag path and followed this code snippet

> [@Update opc tags from a vision table?](http://forum.inductiveautomation.com/t/update-opc-tags-from-a-vision-table/45599/5):
>
> The below assumes you are editing COLUMN 0 and the Tagpath is in COLUMN 1 Adjust as needed. if colIndex==0: tPath = self.data.getValueAt(rowIndex,1) system.tag.write(tPath,newValue) self.data = system.dataset.setValue(self.data, rowIndex, colIndex, newValue) print tPath

I was writing the tag path wrong here is a page from induction for reference to anyone who searches this topic in the future.

[https://docs.inductiveautomation.com/display/DOC80/Tag+Paths](https://docs.inductiveautomation.com/display/DOC80/Tag+Paths)

Thank everyone