Conditional Formatting calculations

[briant79931025]

Good morning,

I have a form that contains two user input fields: Severity (A-E entry) and Likelihood (1-5 entry). I would like to have a third field autopopulate a response based on the user entries.

For example: User enters C in Severity and 4 in LIkelihood the autopopulated response would be H1.

The autopopulated response comes from a risk matrix I have created.

Is this possible through some sort of script?

[try67 · Accepted solution]

Sure. You can use something like this as the custom calculation script of that field:

var severity = this.getField("Severity").valueAsString;
var likelihood = this.getField("Likelihood").valueAsString;
if (severity=="C" && likelihood=="4") event.value = "H1";
else if (severity=="C" && likelihood=="3") event.value = "B1";
else if (severity=="B" && likelihood=="4") event.value = "H2"; // etc.
else event.value = "";

[briant79931025]

Thank you. However, I have tried this and nothing is being populated in the result field, which is titled ORA.

[briant79931025]

thank You. I found the issue and your solution worked.