Skip to main content
briant79931025
Participant
December 26, 2018
Answered

Conditional Formatting calculations

  • December 26, 2018
  • 2 replies
  • 565 views

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?

This topic has been closed for replies.
Correct answer try67

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 = "";

2 replies

briant79931025
Participant
December 26, 2018

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

try67
Community Expert
try67Community ExpertCorrect answer
Community Expert
December 26, 2018

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
Participant
December 26, 2018

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