Skip to main content
S
OneStream Employee
SergeyOneStream Employee
OneStream Employee
March 7, 2022

Conditional editability on SQL table editor ?

  • March 7, 2022
  • 1 reply
  • 0 views

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

C
ckattookaran
Newcomer
March 7, 2022

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.

Terms & ConditionsAccessibility statement