Copy link to clipboard
I have a checkbox in one column and a text field in another column.
I want to show field value in the 2nd column only if the checkbox is selected in the first column, otherwise I want to keep the field blank.
How to do this?
The value I want to show is $15.00 and it will be added to the sum with other fields calculation in the Total field.
As the custom calculation script of the text field use something like this:
event.value = this.getField("Checkbox1").valueAsString=="Off" ? "" : 15;
Thank you for the quick help.