# PowerTable ConfigureEditor doesnt seem to be firing

**URL:** <https://forum.inductiveautomation.com/t/powertable-configureeditor-doesnt-seem-to-be-firing/17546>\
**Category:** Ignition\
**Created:** [March 29, 2018, 2:30pm UTC](https://forum.inductiveautomation.com/t/powertable-configureeditor-doesnt-seem-to-be-firing/17546 "2018-03-29T14:30:25Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![klehman](https://avatars.discourse-cdn.com/v4/letter/k/e68b1a/32.png) [@klehman](https://forum.inductiveautomation.com/u/klehman)\
**Post date:** [March 29, 2018, 2:30pm UTC](https://forum.inductiveautomation.com/t/powertable-configureeditor-doesnt-seem-to-be-firing/17546/1 "2018-03-29T14:30:25Z")

</div>

I have a powertable with a string column called "Shift", and I have put the following code in the configureEditor function:

> shifts = [(0, 'AM Shift'), (1, 'PM Shift')]  
> print "1"  
> if ColName == 'Shift':  
> return {'options': shifts}

My goal is to provide a dropdown on the column for the user to select. I have tried many versions of this same idea that I have found on the forum, but no luck. If I click to edit the column, it presents the standard edit function for the table. I tried a print command to see if it is firing, but I it doesn't output anything to the console.

I also have isCellEditable returing True

Has anyone else had issues using the ConfigureEditor function to display a dropdown?

---

<div class="post-metadata">

**Author:** ![ethomason](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ethomason/32/43338_2.png) [@ethomason](https://forum.inductiveautomation.com/u/ethomason)\
**Post date:** [March 29, 2018, 2:42pm UTC](https://forum.inductiveautomation.com/t/powertable-configureeditor-doesnt-seem-to-be-firing/17546/2 "2018-03-29T14:42:53Z")

</div>

Change “ColName” to “colName”

---

<div class="post-metadata">

**Author:** ![klehman](https://avatars.discourse-cdn.com/v4/letter/k/e68b1a/32.png) [@klehman](https://forum.inductiveautomation.com/u/klehman)\
**Post date:** [March 29, 2018, 3:39pm UTC](https://forum.inductiveautomation.com/t/powertable-configureeditor-doesnt-seem-to-be-firing/17546/3 "2018-03-29T15:39:33Z")

</div>

Good catch, I tried that, with the same result. To start from scratch, I dropped a new Power Table on the window, had it populate with "Test Data". I then put the following in configureEditor and set isCellEditable to return True

> if colName == 'String Column':  
> return {'options': [(0, 'A Shift'), (1, 'B Shift'), (2, 'C Shift')]}

Still, it just allows me to type in whatever I want in the the text box, without a dropdown.

---

<div class="post-metadata">

**Author:** ![JGJohnson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jgjohnson/32/29582_2.png) [@JGJohnson](https://forum.inductiveautomation.com/u/JGJohnson)\
**Post date:** [March 29, 2018, 3:54pm UTC](https://forum.inductiveautomation.com/t/powertable-configureeditor-doesnt-seem-to-be-firing/17546/4 "2018-03-29T15:54:28Z")

</div>

In your first post you were checking for a column named ‘Shift’.

Did the name of the column change?

---

<div class="post-metadata">

**Author:** ![klehman](https://avatars.discourse-cdn.com/v4/letter/k/e68b1a/32.png) [@klehman](https://forum.inductiveautomation.com/u/klehman)\
**Post date:** [March 29, 2018, 4:09pm UTC](https://forum.inductiveautomation.com/t/powertable-configureeditor-doesnt-seem-to-be-firing/17546/5 "2018-03-29T16:09:12Z")

</div>

Good question. To start with a clean slate, I started over with a new powertable and used the “TestData” property to populate it with test data. The testdata includes a column called String Column.

---

<div class="post-metadata">

**Author:** ![JGJohnson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jgjohnson/32/29582_2.png) [@JGJohnson](https://forum.inductiveautomation.com/u/JGJohnson)\
**Post date:** [March 29, 2018, 4:31pm UTC](https://forum.inductiveautomation.com/t/powertable-configureeditor-doesnt-seem-to-be-firing/17546/6 "2018-03-29T16:31:20Z")

</div>

You can put a print statement in there before returning the options.

That will narrow it down and tell you if the event is not being triggered or if there are problems with your return value.

---

<div class="post-metadata">

**Author:** ![klehman](https://avatars.discourse-cdn.com/v4/letter/k/e68b1a/32.png) [@klehman](https://forum.inductiveautomation.com/u/klehman)\
**Post date:** [March 29, 2018, 4:44pm UTC](https://forum.inductiveautomation.com/t/powertable-configureeditor-doesnt-seem-to-be-firing/17546/7 "2018-03-29T16:44:57Z")

</div>

I just restarted the designer and it started working! It wasn’t firing before, I tried the print solution earlier and it never fired. Now its firing just as it should, and I have a drop down now!

Thanks for your responses!

---

<div class="post-metadata">

**Author:** ![ybfautom](https://avatars.discourse-cdn.com/v4/letter/y/eada6e/32.png) [@ybfautom](https://forum.inductiveautomation.com/u/ybfautom)\
**Post date:** [October 26, 2019, 10:27pm UTC](https://forum.inductiveautomation.com/t/powertable-configureeditor-doesnt-seem-to-be-firing/17546/8 "2019-10-26T22:27:45Z")

</div>

I have powertable with no bindings. I put data on the dataset editor. Then code in the configureEditor:

shifts = [(0, ‘AM Shift’), (1, ‘PM Shift’)]  
print “1”  
if colIndex == 1:  
return {‘options’: shifts}

The drop down function works fine.

Next step: I use Postgres to create and populate a table with two varchar columns. Bind powertable data property to select sql table data.

Now it seems configureEditor is not firing at all.

I reset property bindings to no-bindigs but configureEditor still not working.

I will appreciate any help to understand what’s changing with the sql binding, or how to get a powertable sourced from a database working with a cell drop-down editor.

---

<div class="post-metadata">

**Author:** ![roshni](https://avatars.discourse-cdn.com/v4/letter/r/ce7236/32.png) [@roshni](https://forum.inductiveautomation.com/u/roshni)\
**Post date:** [November 10, 2019, 2:23pm UTC](https://forum.inductiveautomation.com/t/powertable-configureeditor-doesnt-seem-to-be-firing/17546/9 "2019-11-10T14:23:18Z")

</div>

HI,  
I had the same problem. I needed to dynamically make a cell editable/ non-ediatble. Also, the dropdown was to be displayed in the cell only when it is editable.

The issue was that the configureEditor function was not being called after the isCellEditable function. The way I solved it was to check the “editable” checkbox for the required column in the “Column Attributes Data” property of the Power Table. This makes all the rows of the column editable. Further, the isCellEditable function filters the cells that need to be non-editable. After this, the configureEditor function is called to populate the dropdown.

---

<div class="post-metadata">

**Author:** ![paulm1](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paulm1/32/5900_2.png) [@paulm1](https://forum.inductiveautomation.com/u/paulm1)\
**Post date:** [January 22, 2020, 2:04am UTC](https://forum.inductiveautomation.com/t/powertable-configureeditor-doesnt-seem-to-be-firing/17546/10 "2020-01-22T02:04:37Z")

</div>

> [@How to query Database Table to populate Power Table Drop Down List within cell](http://forum.inductiveautomation.com/t/how-to-query-database-table-to-populate-power-table-drop-down-list-within-cell/27614):
>
> I have used the extension function configureEditor to script defined drop down boxes within Power Tables before. Now I would appreciate some help using a database table query to populate the drop down cell. I have read most of the related forum articles but I am still struggling. I am a rookie so I could really use some very specific scripting help. My database table I want to query titled shift. The column i would like the query drop down to be in is labeled name. Believe me when I say yo…

See if this Topic helps. If you scroll down to the solution you can see two examples of drop down cells within Power Tables. One is defined and the other pulls its data from mysql table.
