List values in the field depending on the checked options

Forum|Forum|5 years ago
November 19, 2020
6 replies
759 views

I have options A, B, C, D, E and others. Depending on what I check, I want to list the corresponding values in the Risk field - if there is more than one, separated by commas. See attachment. Can you help me, please?

risk.pdf

This topic is closed to new replies. Start a new post to keep the conversation going.

Correct answer try67

You can use this code as the custom calculation script of the "risks" field:

(Edit: code fixed)

var risks = [];
for (var i=1; i<=5; i++) {
	var v = this.getField("risk" + i).valueAsString;
	if (v!="Off") risks.push(v);
}
if (this.getField("risk6").valueAsString!="Off") risks.push(this.getField("other").valueAsString);
event.value = risks.join(", ");

try67

Correct answer

Community Expert

You can use this code as the custom calculation script of the "risks" field:

(Edit: code fixed)

var risks = [];
for (var i=1; i<=5; i++) {
	var v = this.getField("risk" + i).valueAsString;
	if (v!="Off") risks.push(v);
}
if (this.getField("risk6").valueAsString!="Off") risks.push(this.getField("other").valueAsString);
event.value = risks.join(", ");