# Power Table and Buttons

**URL:** <https://forum.inductiveautomation.com/t/power-table-and-buttons/97083>\
**Category:** Ignition\
**Tags:** vision, scripting\
**Created:** [October 10, 2024, 2:08pm UTC](https://forum.inductiveautomation.com/t/power-table-and-buttons/97083 "2024-10-10T14:08:12Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ricardo.ortolani](https://avatars.discourse-cdn.com/v4/letter/r/c68b51/32.png) [@ricardo.ortolani](https://forum.inductiveautomation.com/u/ricardo.ortolani)\
**Post date:** [October 10, 2024, 2:08pm UTC](https://forum.inductiveautomation.com/t/power-table-and-buttons/97083/1 "2024-10-10T14:08:12Z")

</div>

I have a power table that has several columns, 2 of the columns have a button on in. So far this work as indent, but I would like for one of the buttons to hide after a click, that is where I am getting stuck.

I look for the value 1 in order to display the button, but after the click, it set that value to 0, but the button doesn't go away, even after a refresh on the power table dataset

```python
system.db.refresh(event.source.parent.getComponent('iTable'), "data")

```

the button do disappear if I click away into another row, but if I click in the cell where the button was, it show up again and runs the code, which I am trying to avoid.

below are the codes I have so far:

- btn1 (run an update sql query)
- btn2 (open a pop up window)

sample dataset for the power table:

```python
ibID, Date , Vendor, Btn1, Btn2
1 , 10/10/2024, test1 , 1, 1
2 , 10/10/2024, test2 , 0, 1

```

the dataset above will make the power table, display 2 buttons on row 1, and only 1 button on row 2.

but if I click on the cell for row 2, btn1, if will un-hide the button

as far the code on the power table:

under Extensions Functions \> configureCell

```python
	import java
	from javax.swing import JButton, SwingConstants
	from javax.swing.border import MatteBorder,SoftBevelBorder
	from javax.swing.table import TableCellRenderer
	
	if colName == 'Btn2':
		class MyTableCellRenderer_Btn2(TableCellRenderer):
			def __init__ (self):
				super(MyTableCellRenderer_Btn2, self). __init__ ()
				self.button = JButton("Btn2")
				
			def getTableCellRendererComponent(self, table, value, isSelected, hasFocus, row, column):
				return self.button
				
		r_Btn2 = MyTableCellRenderer_Btn2()
		return { "renderer": r_Btn2.button }
	
	if colName == 'Btn1' and value == 1:
		class MyTableCellRenderer_Btn1(TableCellRenderer):
			def __init__ (self):
				super(MyTableCellRenderer_Btn1, self). __init__ ()
				self.button = JButton("Btn1")
			
			def getTableCellRendererComponent(self, table, value, isSelected, hasFocus, row, column):
				return self.button
			
		r_Btn1 = MyTableCellRenderer_Btn1()
		return { "renderer": r_Btn1.button }
	
	if selected:
		return {'background': self.selectionBackground}
	elif rowView % 2 == 0:
		return {'background': '#1A2430'}
	else:
		return {'background': '#30363c'}

```

under Extensions Functions \> configureEditor

```python
	from javax.swing import AbstractCellEditor, JButton 
	from javax.swing.table import TableCellEditor
	import javax.swing.CellEditor
			
	# load data
	ds = self.getData()

	if colName == "Btn2":
		def func_Btn2(event):
			ibID = ds.getValueAt(self.selectedRow, 'ibID')
			window = system.nav.openWindow('popup_inbound_edited', {'ibID' : ibID})
			system.nav.centerWindow(window)
			
		class MyCellEditor_Btn2(AbstractCellEditor,TableCellEditor):
			def getCellEditorValue(e):
				return None
			def getTableCellEditorComponent(self,table,value,isSelected,row,column): 
				return JButton("Btn2",actionPerformed=func_Btn2)
				return self.selectedRow
		
		return {'editor':MyCellEditor_Btn2()}
	
	if colName == "Btn1":
		def func_Btn1(event):
			valueID = ds.getValueAt(self.selectedRow, 'ibID')
			timestamp = system.date.format(system.date.now(), "yyyy-MM-dd HH:mm:ss")
			
			# update database
			result = system.db.runPrepUpdate("UPDATE [table] SET [value1] = ? WHERE [value3] = ?", [timestamp,valueID], 'prod_ignition')

			# refresh table
			self.parent.getComponent('btn_refresh').doClick()

		class MyCellEditor_Btn1(AbstractCellEditor,TableCellEditor):
			def getCellEditorValue(e):
				return None
			def getTableCellEditorComponent(self,table,value,isSelected,row,column):
				return JButton("Btn1",actionPerformed=func_Btn1)
				return self.selectedRow
		
		return {'editor':MyCellEditor_Btn1()}

```

I am open to suggestion if this is no the right approach.

this is a plus if anyone know ways to customize the button, like background color, foreground color, add icons.

---

<div class="post-metadata">

**Author:** ![justinedwards.jle](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/justinedwards.jle/32/37854_2.png) [@justinedwards.jle](https://forum.inductiveautomation.com/u/justinedwards.jle)\
**Post date:** [October 15, 2024, 9:18pm UTC](https://forum.inductiveautomation.com/t/power-table-and-buttons/97083/2 "2024-10-15T21:18:34Z")

</div>

> [@ricardo.ortolani](#):
>
> ```python
> def getTableCellEditorComponent(self,table,value,isSelected,row,column):
> return JButton("Btn1",actionPerformed=func_Btn1)
> return self.selectedRow
> 
> ```

I haven't tested your code at all, but this isn't correct. The first return statement will end the function, and consequently `self.selectedRow` will never get returned.

> [@ricardo.ortolani](#):
>
> if anyone know ways to customize the button

I imagine it could be done like this:

```python
getTableCellEditorComponent(self,table,value,isSelected,row,column):
		# Create the JButton, and assign the it to a variable
		button = JButton("Btn1",actionPerformed=func_Btn1)
		
		# Manipulate the button's properties
		button.background = system.gui.color('yellow')
		
		# Then, return the button
		return button

```

**Edit:**  
Taking a closer look at this, I don't see the need for `import java`. I recommend deleting that.

Using your code, I was able to color the buttons from the **init** method of the table cell renderer:

```python
button = JButton("Btn2")
button.background = system.gui.color('yellow')
self.button = button

```

Result:  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/a/3a2ca1da7a8066405c08a56e4e34842ef0bb0caf.png)

> [@ricardo.ortolani](#):
>
> I would like for one of the buttons to hide after a click

It would probably be better to use the enabled property. In any case, I imagine that a custom dataset property or a hidden column could be added to the table to store whether or not the button at a given row can be used. The button's action performed script could change the value, and the isCellEditable extension function could read it to ensure the button can't fire again. The `configureCell` extension function could also read it to set the enabled property for each button.  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/5/a57c353a1d548fe93cd129b3439cd5cc4900f4a8.png)

---

<div class="post-metadata">

**Author:** ![ricardo.ortolani](https://avatars.discourse-cdn.com/v4/letter/r/c68b51/32.png) [@ricardo.ortolani](https://forum.inductiveautomation.com/u/ricardo.ortolani)\
**Post date:** [October 17, 2024, 1:14pm UTC](https://forum.inductiveautomation.com/t/power-table-and-buttons/97083/3 "2024-10-17T13:14:56Z")

</div>

Hello @justinedwards.jle,

thanks for the reply, some of that info you mention I implement and it is working great, like the button customization and removing the `import java`.

Below are the changes, case anyone else want see `configureCell` the following:

```python
if colName == 'Btn2':
	class MyTableCellRenderer_DEP(TableCellRenderer):
		def __init__ (self):
			super(MyTableCellRenderer_Btn2, self). __init__ ()
			
			button = JButton("Btn2")
			if value == 1:
				button.background = system.gui.color('yellow')
				button.enabled = 1
			else:
				button.background = system.gui.color('gray')
				button.enabled = 0
			self.button = button
			#self.button = JButton("Btn2")
		
		def getTableCellRendererComponent(self, table, value, isSelected, hasFocus, row, column):
			return self.button
	
	r_DEP = MyTableCellRenderer_Btn2()
	return { "renderer": r_Btn2.button }

```

this does disable the button, but I still running into a issue.

Since the `configureEditor` is active, anytime I click the cell, the end user see a button getting press. I am trying to disable that for an end user experience.

The code in `configureEditor` script still executed every time a mouse click in the cell. I just add a check for the value, but I can only get that value when I click the cell, do you know a way to check for that before hand?

below is the code in the `configureEditor`

```python
if colName == "Btn2":
	def func_Btn2(event):
		ds = self.getData()
		btnStatus = ds.getValueAt(self.selectedRow, 'Btn2')
		
		if btnStatus == 1:
			print "RUN CODE"
		else:
			print "DO NOTHING"
		
	class MyCellEditor_Btn2(AbstractCellEditor,TableCellEditor):
		def getCellEditorValue(e):
			return None
		def getTableCellEditorComponent(self,table,value,isSelected,row,column): 
			return JButton("Btn2",actionPerformed=func_Btn2)
	
	return {'editor':MyCellEditor_Btn2()}

```

---

<div class="post-metadata">

**Author:** ![justinedwards.jle](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/justinedwards.jle/32/37854_2.png) [@justinedwards.jle](https://forum.inductiveautomation.com/u/justinedwards.jle)\
**Post date:** [October 17, 2024, 7:14pm UTC](https://forum.inductiveautomation.com/t/power-table-and-buttons/97083/4 "2024-10-17T19:14:32Z")

</div>

> [@ricardo.ortolani](#):
>
> a way to check for that before hand?

> [@justinedwards.jle](#):
>
> a custom dataset property or a hidden column could be added to the table to store whether or not the button at a given row can be used.

For each button. add a corresponding boolean value to a hidden column in the dataset, or a custom property dataset, then have the isCellEditable extension function check the stored values for each cell returning True or False accordingly. This way, a disabled button will also be uneditable, and the user will not be able to access the button when clicking the cell