I just got AcrobatX Pro 10 and am getting my feet wet with the abilities of the fillable forms. I have been able to figure out basic computation and formulas but have hit a road block in being able to have a field automatically put in a number based on the response from another field. Here is what I would like to do:
If field 1 is a drop down box for all state abbreviations then I would like field 2 to recognize which state was selected and auto fill a number based on that state ie. if NJ is selected then field 2 will auto fill: $25,000. If NY is selected then field 2 will auto fill $50,000. Some states will have the same number associated with it so NJ, PA, DE might have $25,000 associated with it and NY, MA, RI might have $50,000 associated with it.
I appreciate anything that anyone can do to point me in the right direction!
Dan
If, Then
2011-10-11 11:04:27
My Product Information:
Acrobat Pro 10.0, Macintosh
Acrobat Pro 10.0, Macintosh
2011-10-13 12:34:24
#2
use those prices figure on the "export value" box against each state entry. Then use a script in calculations for field 2 to "get" the value from the combo box.
Calculation Script: event.value = this.getField("STATE").value;
Set field format to Number > Currency in $.Hope this helps.
Calculation Script: event.value = this.getField("STATE").value;
Set field format to Number > Currency in $.Hope this helps.
2011-10-13 12:41:29
#3
BTW "STATE" is the name we have assumed for the field which is the drop down or combo box for abbreviated state names
2011-10-13 13:30:57
#4
The drop down box is easier to maintain by using a document level function to load the combo box from a document data object or an array using the "setItems" method in a document level script or function. One need only update the items in the array or object and then save the PDF.
It is easier to change the value in an array element than to delete and reenter the Item and Export value on the field UI.
It is easier to change the value in an array element than to delete and reenter the Item and Export value on the field UI.
// Custom calculate script for Field 2
var prices = {" ": 0, "NJ": 25000, "NY": 50000, "WA": 15000, "PA": 25000, "DE": 25000, "WY": 10000, "CA": 45000, "MA": 50000};
event.value = prices[getField("STATE").value];
Replace "STATE" with the actual name of the combo box you're using. Add as many entries to the "prices" object as needed. Note the first item is a single space, which is a common thing to include in a comb box to indicate no selection, but you still need to account for it.