Copy link to clipboard
Copied
I have six dropdown lists
- "Dropdown2"
- "Dropdown3"
- "Dropdown4"
- "Dropdown5"
- "Dropdown6"
- "Dropdown7"
I would like to know how to format a text field below the dropdowns so that the textbox reads "Pass" ONLY if "Yes" is selected in EACH of the six dropdown lists. If "Yes" is not selected in each of the six dropdown lists, the text field should read "Not Met"
Copy link to clipboard
Copied
You can use this code as the custom calculation script of the text field:
var result = "Pass";
for (var i=2; i<=7; i++) {
if (this.getField("Dropdown"+i).valueAsString!="Yes") {
result = "Not Met";
break;
}
}
event.value = result;
Copy link to clipboard
Copied
This did not work
Copy link to clipboard
Copied
You'll need to elaborate a bit if you want further help...