# Edit Power Table to Choose multiple rows by script

**URL:** <https://forum.inductiveautomation.com/t/edit-power-table-to-choose-multiple-rows-by-script/38390>\
**Category:** Ignition\
**Tags:** ignition80\
**Created:** [September 4, 2020, 8:28am UTC](https://forum.inductiveautomation.com/t/edit-power-table-to-choose-multiple-rows-by-script/38390 "2020-09-04T08:28:37Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![yifeiliu08](https://avatars.discourse-cdn.com/v4/letter/y/bbe5ce/32.png) [@yifeiliu08](https://forum.inductiveautomation.com/u/yifeiliu08)\
**Post date:** [September 4, 2020, 8:28am UTC](https://forum.inductiveautomation.com/t/edit-power-table-to-choose-multiple-rows-by-script/38390/1 "2020-09-04T08:28:37Z")

</div>

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/7/4746430cbb69df531ecba115109f57dfd5502e63.png)  
I use SQL to binding a power table, the first column is boolean I use 0 as default

1. I want to have a script if i click that rows(as the blue highlight) , it will invert the value , for example 0–1 , 1–0

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [September 4, 2020, 10:39am UTC](https://forum.inductiveautomation.com/t/edit-power-table-to-choose-multiple-rows-by-script/38390/2 "2020-09-04T10:39:47Z")

</div>

- Make sure your ‘Send’ column is editable, using the table customizer
- The default onEdited script will work, if you uncomment the line.

---

<div class="post-metadata">

**Author:** ![yifeiliu08](https://avatars.discourse-cdn.com/v4/letter/y/bbe5ce/32.png) [@yifeiliu08](https://forum.inductiveautomation.com/u/yifeiliu08)\
**Post date:** [September 4, 2020, 2:23pm UTC](https://forum.inductiveautomation.com/t/edit-power-table-to-choose-multiple-rows-by-script/38390/3 "2020-09-04T14:23:32Z")

</div>

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/5/3526346e7f5eebd8720b5822af290793a23fafa0.png)  
thanks it works

---

<div class="post-metadata">

**Author:** ![Bastian\_Jara](https://avatars.discourse-cdn.com/v4/letter/b/dec6dc/32.png) [@Bastian\_Jara](https://forum.inductiveautomation.com/u/Bastian_Jara)\
**Post date:** [January 19, 2023, 12:38am UTC](https://forum.inductiveautomation.com/t/edit-power-table-to-choose-multiple-rows-by-script/38390/4 "2023-01-19T00:38:58Z")

</div>

thanks a lot!