How do I pre-fill multiple fields with a percentage, based on two options from a dropdown?

Question

I am creating a form to use for 1000+ scenarios. I have calculations to do under two separate scenarios. If I select one dropdown option, I would like a set of 4-5 fields to pre-populate with a certain percentage. If I select another dropdown option, I would like it to pre-populate the same 4-5 fields with a different percentage.

try67 · Answer

As the custom Validation script of the drop-down you can use something like this (adjust the field names and values as needed, of course):

if (event.value=="Option1") {
	this.getField("Perc1").value = 0.1;
	this.getField("Perc2").value = 0.2;
	this.getField("Perc3").value = 0.3;
	this.getField("Perc4").value = 0.4;
} else if (event.value=="Option2") {
	this.getField("Perc1").value = 0.9;
	this.getField("Perc2").value = 0.8;
	this.getField("Perc3").value = 0.7;
	this.getField("Perc4").value = 0.65;
}

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded