Vizlib Home Try Vizlib

Writeback Table - make field editable or calculated based on another field

Is it possible to have a filed be both editable or calculated?  

For example, I have an entry type dropdown column that can have Option 1 or Option 2.  If Option 1 is selected, I would like my Amount column to be editable so a user can enter an amount.  If Option 2 is selected, I would like the Amount field to auto calculate based on the values in 2 other columns OR no longer be editable.  I can do the calculation in the backend.

I have tried putting an equation in the Editable IF field but am not having any success.  I have tried many variations of If(Column(3) = 'Option 1', 1, 0)

Any help would be appreciated.


Login to post a comment