Vizlib Home
Welcome
Login

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.

Thanks!

Login to post a comment