Conditional edit of cell

[Katunga]

Hello!

I have been working with retool for a while now.
Right now I want to make a cell editable in the role column only if it is selected.

I tried the following code:

{{ rt_expertAttendance_table.selectedRows.some(row => row.id === currentSourceRow.id) }}

in the editable field of the column, but it lets me edit even without selecting the row.
here are the table infos that I have:

role column:

table:

Addtionally, said role is from my database which has the enum datatype and I want to have specific colors accordingly. I used this code under the colors field in the option list, but this unfortunately doesnt work as well:

{{ 
  (() => {
    const roles = Array.isArray(show_roles_attendance_ac.value) 
      ? show_roles_attendance_ac.value 
      : [];

    const baseColors = ["#b7db7a", "#7fbf3f", "#4f8f2f", "#2f5f1f"];

    return roles.reduce((acc, role, i) => {
      acc[role] = baseColors[i % baseColors.length];
      return acc;
    }, {});
  })()
}}

[WidleStudioLLP]

Hi @Katunga ,

I understand the issue you’re facing—I’ve encountered something similar before. I was able to resolve it using the following forum discussion:

Dynamically set editable field (bug?)

I'm trying to set each individual cell of a row to be editable with conditional Setting the field value manually [true, false, false] works fine. however, setting this as an expression, i.e {{ stateSalesOrderLines.value.map(row => !row.is_warranty_item) }} does NOT work. Even if i set a variable to [true, false, false], the UI sees the value as [true, false, false] but the expression evaluates Array(3) [ [ false, false, true ], [ false, false, true ], [ false, fals…

For dynamically setting cell colors, you can refer to this thread for the logic:

Table Cell Conditional Text Color

Goal: Set text color based on source or changed values Steps: I've tried setting the text by comparing item (what I believe should be the current value) to a value. It works fine when the data is loaded, but not when a value is changed by the user Details: Using Table (New) with mapped column of format currency. Simple example of Text property: {{ +item > 0 ? 'red' : 'blue' }} Screenshots: on Screen Load: [Screenshot 2024-07-08 at 11.15.46 AM] After updating values [Screenshot …

You can adapt the approaches from these posts based on your data and use case. If you still face any issues after trying this, feel free to reach out—I’ll be happy to help further.

[Darren]

Let us know if you have any additional questions, @Katunga!