7 Replies Latest reply on Nov 18, 2015 5:12 PM by gkaiseril

    Display % in text field when number entered.

    mmb5588

      I have two data fields in a fillable form that need to return e.g., 33% when 33 is entered. I have created this script for both fields:

       

      The two data fields are in tab order: Close_Ratio and Intro_ApptRatio.

       

      // Custom Format script for text field 

      if (event.value) event.value += "%"; 

       

      The numbers return correctly but when I enter 25 in the first field, I get 25%. Then when I enter 33 in the second field, I get 33% but the first field changes to 25%%. Actually - every time I enter the field another % sign shows up - 25%%%%%.    : (

       

      I can't figure out how the script is tying the two field together. Any help would be more than appreciated!

        • 1. Re: Display % in text field when number entered.
          try67 MVP & Adobe Community Professional

          I just tried it myself and it worked just fine.

          Are you sure you placed the code as the custom Format script, and not anywhere else?

          • 2. Re: Display % in text field when number entered.
            mmb5588 Level 1

            Oh my gosh ... I am a Newbie! I entered it in the calculation script area.

             

            Thank you so much for knowing what was wrong! I appreciate your help so much!!!

            • 3. Re: Display % in text field when number entered.
              mmb5588 Level 1

              So - two other data fields in my form use the percentage fields in their custom calculation.

               

              Now, when I apply the custom format script so that users can just enter 25 and get 25% returned,

               

                                  // Custom Format script for text field 

                                      if (event.value) event.value += "%"; 

               

              my custom calculation script to account for fields with a 0 value doesn't work - it seems to not function as the resident 0 remains in the field.

               

               

                             // Custom calculate script

               

                             // Get the field values, as numbers

                             var numerator = +getField("IPSGoal_Annual").value;

                             var denominator = +getField("Close_Ratio").value;

               

                             // Calculate and set this field value

                             if (denominator !== 0) {

                                 event.value = numerator / denominator / 52;

                             } else {

                                 event.value = "";

                             }

               

              I have set the calculation order but don't know if this really has anything to do with it ... seems more to do with the field formatting.

               

              I really appreciate your help!

              • 4. Re: Display % in text field when number entered.
                try67 MVP & Adobe Community Professional

                Are there any error messages in the JS console (Ctrl+J)?

                • 5. Re: Display % in text field when number entered.
                  mmb5588 Level 1

                  Oh my gosh! I think I did not have any errors until I applied the custom format script - but now! What do I do now???

                   

                   

                  Acrobat EScript Built-in Functions Version 10.0

                  Acrobat SOAP 10.0

                   

                  TypeError: this.getField("sDividend") is null

                  4:Field:Calculate

                  TypeError: this.getField("sDividend") is null

                  4:Field:Calculate

                  TypeError: this.getField("sDividend") is null

                  4:Field:Calculate

                  TypeError: this.getField("sDividend") is null

                  4:Field:Calculate

                  TypeError: this.getField("sDividend") is null

                  4:Field:Calculate

                  TypeError: this.getField("sDividend") is null

                  4:Field:Calculate

                  TypeError: this.getField("sDividend") is null

                  4:Field:Calculate

                  TypeError: this.getField("sDividend") is null

                  4:Field:Calculate

                  TypeError: this.getField("sDividend") is null

                  4:Field:Calculate

                  TypeError: this.getField("sDividend") is null

                  4:Field:Calculate

                  TypeError: this.getField("sDividend") is null

                  4:Field:Calculate

                  TypeError: getField("IPSGoal_Annual") is null

                  4:Field:Calculate

                  TypeError: getField("IPSGoal_Annual") is null

                  4:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("IPSGoal_Annual") is null

                  4:Field:Calculate

                  TypeError: getField("IPSGoal_Annual") is null

                  4:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Close_Ratio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: getField("Intro_ApptRatio_Dropdown") is null

                  5:Field:Calculate

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  TypeError: f is null

                  • 6. Re: Display % in text field when number entered.
                    mmb5588 Level 1

                    I think I found the problem. Two of my data field names began with an #. I think the programming doesn't like this. I will try the custom format script again now ...

                    • 7. Re: Display % in text field when number entered.
                      gkaiseril MVP & Adobe Community Professional

                      I would suggest formatting the fields with percentage values as "Percent" and entering the values as the decimal fraction so 50% is entered as .50. Using this approach one can set a percentage value directly from a calculation script with out the decimal adjustment and use the value of the field in another calculation without the decimal adjustment.

                       

                      You "null' issue may resolve around bad form field names, either spelling or capitalization. The Acrobat JavaScript documentation for the doc.getField() method for getting a field object states that the getField method returns a null value if the field object does not exist. One can test for this as part of the script or write a function to get the field object and test for the "null" value.