Conditional editability on SQL table editor ?

Sergey
Contributor III

Dear community,

Using the SQL table editor, it is possible to define the "allowupdates" as true for each column.

Sergey_0-1646642212395.png

Right now I have a requirement which is to have a cell with a column which should be editable depending on another row: on a specific row, if column 2 is set as "true", then column 3 should be editable.

 

What would be the most apprioriate way to achieve that ?

 

Regards,

1 REPLY 1

You can use an XFBR for that whole string. However, is it column 2 or cell value? In either case, you'll need a refresh operation on the table editor to make this work.

Not sure how you can get this to work based on rows and columns (I'm assuming that this is not a single row).

Humor me with this.

User saves the value as true in B2 (row 2 column b) cell and saves it. A refresh happens, and now column 3 allows for editing, which means every cell can be edited. The value in B1 is false. Still, the user can edit column 3.

Please sign in! Sergey