# configureEditor refresh

**URL:** <https://forum.inductiveautomation.com/t/configureeditor-refresh/11284>\
**Category:** Ignition\
**Created:** [February 29, 2016, 6:09am UTC](https://forum.inductiveautomation.com/t/configureeditor-refresh/11284 "2016-02-29T06:09:43Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![weertske](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/weertske/32/3353_2.png) [@weertske](https://forum.inductiveautomation.com/u/weertske)\
**Post date:** [February 29, 2016, 6:09am UTC](https://forum.inductiveautomation.com/t/configureeditor-refresh/11284/1 "2016-02-29T06:09:43Z")

</div>

As far as I can tell the Extension Function configureEditor does not refresh. i.e. it only runs the first time the table opens. This means you can’t adjust a drop down list dynamically. Let me give you an example:

[code] import system  
if colName == ‘Operator’:

# creating a list of users that have are already showing up in this column

```
	usedusers = []
	for x in range(self.Count): #Count is a custom property (number of rows)
		usedusers.append(self.data.getValueAt(x,colName))

```

# creating a list of tuples for the dropdown

```
	list = [('Fill me in','Fill me in')] #default value
	users = system.user.getUsers("default")
	for user in users:
		if ("Operator" in user.getRoles()) and (user.get(user.Username) not in usedusers):
			list.append((user.get(user.Username),user.get(user.Username)))
	return {'options': list}[/code]

```

The above code gives you a drop down list to fill in an “Operator” column. It determines available operators and also determines which operators have already been used in the column. Therefore, after using an operator to fill in row 1, that operator should no longer show up in the drop down list. Unfortunately, that operator still shows up and I think the only way to get that operator to no longer show up would be to close the window and re-open it. Not very dynamic! Anyone have an idea how to make the editor dynamically refresh?

---

<div class="post-metadata">

**Author:** ![weertske](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/weertske/32/3353_2.png) [@weertske](https://forum.inductiveautomation.com/u/weertske)\
**Post date:** [April 15, 2016, 9:14pm UTC](https://forum.inductiveautomation.com/t/configureeditor-refresh/11284/2 "2016-04-15T21:14:37Z")

</div>

I figured out how to make the drop down list dynamic! I changed to a regular Table from a Power Table and then followed the concept outlined by Travis in [https://inductiveautomation.com/forum/viewtopic.php?f=70&t=7840&hilit=translatemap](https://inductiveautomation.com/forum/viewtopic.php?f=70&t=7840&hilit=translatemap) ![:thumb_right:](https://us1.discourse-cdn.com/inductiveautomation/original/1X/2026e28c0c425034352c1b75807edf956adc75f4.gif ":thumb\_right:")

---

<div class="post-metadata">

**Author:** ![mazeyrat](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mazeyrat/32/10955_2.png) [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\
**Post date:** [June 13, 2017, 1:23pm UTC](https://forum.inductiveautomation.com/t/configureeditor-refresh/11284/3 "2017-06-13T13:23:38Z")

</div>

You can force the power Table extension function configureEditor to execute with :

```auto
event.source.parent.getComponent('Power table').data = None
system.db.refresh(event.source.parent.getComponent('Power table'),"data")
```

if for example powertable Data property is binded to an SQL query with polling mode Off
