Copy link to clipboard
Copied
Hello,
I need help writing a conditional format that references the result from a dropdown selection.
If "Pooled" is selected, I need the "PoolVol" cell to display the value of "Ejac1vol" + "Ejac2vol"
If "Ejac #1 Only" is selected, I need the "PoolVol" cell to display the value from the "Ejac1vol" cell
If "Ejac #2 Only" is selected, I need the "PoolVol" cell to display the value from the "Ejac2vol" cell
Thank you for your help!!
Copy link to clipboard
Copied
Use this as 'Validation' script of dropdown field and also in dropdown field under 'options' tab check 'Commit selected value immediately':
var pv = this.getField("PoolVol");
var e1 = Number(this.getField("Ejac1vol").value);
var e2 = Number(this.getField("Ejac2vol").value);
if(event.value == "Pooled")
pv.value = e1+e2;
else if(event.value == "Ejac #1 Only")
pv.value = e1;
else if(event.value == "Ejac #2 Only")
pv.value = e2;
else
pv.value = "";
Copy link to clipboard
Copied