How do I disable an inline cell, if its previous cell contains specific values
How do I disable an inline cell, if its previous cell contains specific values

I would like to be able to disable (for editing) a cell, if the cell before holds a specific value.
By way of an example, I have a table that has a header row, and two data rows. There are only 3 cell headers titled Id
, Type
and Value
.
The Type
values are dropdown lists. When I select a particular value from the dropdown list, I want to be able to disable the "Value" column.
I want this per row.
Answers
Use the
dependent()
method.This example shows it doing show / hide, but you could just as easily do enable / disable.
Allan
Thanks allan, but I'm doing this inline.
Put an
if
condition around the call toinline()
which checks the data for the row and sees if it should be editable or not:Obviously you might want to add some variance for the specific column / cell clicked on, but that would be the basic idea.
Allan