[Question]How can I get the value of one cell by clicking on another cell in a datarow?

[bmcgonag]

Question

I'm fairly new to Flet, but really liking it. I have a datatable, and my table forms well. I'm trying to set a cell where the click event (on_tap) will call a function to define an action (right now, just trying to print the value from the first cell (cell 0) in the row.

If I click on row 2 cell[3], how do I get the value of row 2 cell[0]? Here's what I have so far, got the row. part from google's ai, which seems to be wrong about flet about 99% of the time.

def toggle_ssh(e):
            selected_peer_ssh = row.cells[0].value
            if selected_peer_ssh:
                print(selected_peer_ssh)
            else:
                print("Didn't get the peer name for ssh toggle.")

Any help is greatly appreciated.

Code sample

def toggle_ssh(e):
            selected_peer_ssh = row.cells[0].value
            if selected_peer_ssh:
                print(selected_peer_ssh)
            else:
                print("Didn't get the peer name for ssh toggle.")

Error message

File "/home/myuser/Developer/flet-test/main.py", line 52, in toggle_ssh
    selected_peer_ssh = row.cells[0].value
                        ^^^
NameError: name 'row' is not defined. Did you mean: 'pow'?

------------------------------------------------------

• I have searched for answers to my question both in the issues and in previous discussions.

[bmcgonag]

Just to expand on this, I know I can click the datarow and get any cell value with an index for that cell, but only if I don't have an on_tap for the cell I click in. If you have the on_tap event on the cell it overrides the on_tap event for the row. In my case, each cell has a different action based on the on_tap event, and two of the cells depend on the value in the 0th position of the cell indexes.

[bmcgonag]

I finally got this figured out.

Given the format of a data table as follows:

ft.DataTable(
        columns=[
            ft.DataColumn(ft.Text("Peer Name")),
            ft.DataColumn(ft.Text("IP Address")),
            ft.DataColumn(ft.Text("SSH Enabled")),
            ft.DataColumn(ft.Text("Status")),
            ft.DataColumn(ft.Text("Groups")),
        ],
        rows=get_row_data,
    ),

Where get_row_data returns all the rows in the format:

row_data.append(ft.DataRow(
    cells=[
        ft.DataCell(ft.Text(items["hostname"]), on_tap=cell_tapped),
        ft.DataCell(ft.Text(items["ip"]), on_tap=copy_ip),
        ft.DataCell(ssh, on_tap=toggle_ssh),
        ft.DataCell(conn, on_tap=toggle_peer_on_off),
        ft.DataCell(host_group_count),
    ],
))
return row_data

You can get the value from any cell on a row with the following (assuming you have an on_tap event on the cell you intend the user to click).

def toggle_ssh(e: ft.ControlEvent):
    selected_peer_ssh = e.control.parent.cells[0].content.value
    if selected_peer_ssh:
        print(selected_peer_ssh)
    else:
        print("Didn't get the peer name for ssh toggle.")

Where e.control.parent is the ft.DataRow, and cells[0] refers to the first cell in the row with [0] being your indexing marker. Then just call content.value to get the value in that cell.

Maybe this will help someone else down the road.