Skip to main content
E
edwardw54853149
Participating Frequently
November 30, 2019
Answered

Need Custom Text In Dropdown to equal zero

  • November 30, 2019
  • 2 replies
  • 1498 views

In short, I want to assign a value of zero to a dropdown field if the user does not choose an item from the list and enters custom text.

 

I have a form with multiple fields.  The form calculates the Wheel Tax based on input from three fields. "Wheel Tax Cities" and "Wheel Tax Counties" are both dropdowns that have items with Export Values and allow user to enter custom text.  A third field is called "License Plate Fee Dropdown."  One of the fields called "Wheel Tax" I have a custom calculation script that sort of works but only calculated sporadically:

 

var t1 = getField("Wheel Tax Cities").value;
var t2 = getField("Wheel Tax Counties").value;
var PlateTransfer = getField("License Plate Fee Dropdown").value;
if (PlateTransfer < 1) event.value = 0;
else if (isNaN(t1)) t1 = 0;
else if (isNaN(t2)) t2 = 0;
else event.value = t1+t2;

 

Wheel Tax = Wheel Tax Cities + Wheel Tax Counties but is zero when there is a PlateTransfer.  

 

Thanks for your time, and one last thing, is there a good reference book to buy to help me learn Acrobat Javascript?  Thanks!!

This topic has been closed for replies.
Correct answer try67

Sorry I didn't think you would reply to quickly. My new script is off just a little and I need just a little more help please.  See above.  I just edited it after I tested my form.


You didn't cover the scenario when both values are not numbers.

You can do that by replacing these lines:

else if (isNaN(t1)) event.value = t2;
else if (isNaN(t2)) event.value = t1;

With this:

else if (isNaN(t1) && isNaN(t2)) event.value = 0;

else if (isNaN(t1) && !isNaN(t2)) event.value = t2;
else if (!isNaN(t1) && isNaN(t2)) event.value = t1;

 

Edit: fixed wrong spelling of isNaN in some instances...

2 replies

try67
Community Expert
try67Community Expert
Community Expert
December 1, 2019

Try this:

 

var t1 = Number(this.getField("Wheel Tax Cities").valueAsString);
var t2 = Number(this.getField("Wheel Tax Counties").valueAsString);
var PlateTransfer = Number(this.getField("License Plate Fee Dropdown").valueAsString);
if (PlateTransfer < 1 || isNaN(t1) || isNaN(t2)) event.value = 0;
else event.value = t1+t2;
    E
    edwardw54853149Author
    Participating Frequently
    December 1, 2019

    Wow, I'm getting closer.  I wasn't being clear with my precise need, sorry. If there is a plate transfer then Wheel Tax =0.  If not, then use the event value of Cities AND Counties.  If there is a custom value entered for Cites then return 0 for Cities but still use the value from Counties.  And visa versa.  If both Cities AND Counties are a custom value then Wheel Tax=0.

     

     

    He're is what almost worked, but when I enter a custom value for BOTH Cites AND Counties I get "NaN":

     

    var t1 = Number(this.getField("Wheel Tax Cities").valueAsString);
    var t2 = Number(this.getField("Wheel Tax Counties").valueAsString);
    var PlateTransfer = Number(this.getField("License Plate Fee Dropdown").valueAsString);
    if (PlateTransfer < 1) event.value = 0;
    else if (isNaN(t1)) event.value = t2;
    else if (isNaN(t2)) event.value = t1;
    else event.value = t1+t2;

     

    I've never used the

     

    Number(xxxxxxx).valueAsString)

     

    I now see how to use it.   "Number(value)" constrictor will (i think) convert a number character string to a floating point number and force JavaScript to perform addition and not concatenation.

    Thanks!! 

    try67
    Community Expert
    try67Community Expert
    Community Expert
    December 1, 2019

    Yes, that's correct. It will try to convert the value (whatever type it might be) to a Number. If it fails, the result will be NaN, which you can detect using the isNaN method.

    Glad to hear you got it working!

    try67
    Community Expert
    try67Community Expert
    Community Expert
    December 1, 2019

    Do you want it to show zero if any of the fields have a custom value? Because that's not what you're doing in the code above.

    E
    edwardw54853149Author
    Participating Frequently
    December 1, 2019

    Only Wheel Tax Cites and Wheel Tax Counties allow for custom value.  If either has a custom value then that one should read as zero.

     

    When I select a city from the selection list in Wheel Tax Cities dropdown or select a city from the selection list in Wheel Tax Counties I need Wheel Tax to sum the two.

     

    When I manually enter a city (custom value) in Wheel Tax Cities dropdown I need it to read as zero.  Same for Counties.

     

    If there is a plate transfer then there is no Wheel Tax and that field should then disregard any fees from either Cities or Counties and the calculation should be zero.

     

    My License Plate Fee Dropdown looks like this:

     

    My Wheel Tax Cities dropdown looks like this:

     

     

     

    Wheel Tax looks like this:

     

     

     

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices