Skip navigation
blakedodson.prg
blakedodson.prg Calculating status...
Currently Being Moderated

Validation Code Confusion

May 3, 2012 2:07 PM

Categories: Windows Tags: #acrobat_10_pro

Why doesn't this validation code work?  if(event.value == 135.31 | event.value == '') event.value = '';

 

It works if I don't use 135.31 and I only use 125, but I don't want it to show this particular dollar amount.  I don't know Java script at all, I copied most of this code from another forum.  Any ideas?  I can send the form I've created if that helps.

 

Blake Dodson

bdodson@prg.com

 

Thanks,

508 Views   8 Replies   Latest reply: Gilad D (try67), May 4, 2012 8:43 AM
 
Replies
  • Gilad D (try67)
    Currently Being Moderated
    1. Gilad D (try67),
    May 3, 2012 2:19 PM   in reply to blakedodson.prg
    Report

    The second part of the if condition is not required. If the value is

    already blank, why reset it?

    Try this instead:

    if (event.value == "135.31") event.value = "";

     
    |
    Mark as:
  • GKaiseril
    Currently Being Moderated
    2. GKaiseril,
    May 3, 2012 3:49 PM   in reply to blakedodson.prg
    Report

    Why are you using the Bitwise OR and not the Logical OR?

     

    The bitwise operators only process 32 bits of the the data string and not the entire floating point  number.

     

    I would also use the valueAsString property to test for the null string character, the value property sometimes treats the null character as a zero not a null string..

     

    if(event.value == 135.31 || event.valueAsString == '') event.value = '';

     
    |
    Mark as:
  • blakedodson.prg
    Currently Being Moderated
    3. blakedodson.prg,
    May 4, 2012 5:28 AM   in reply to Gilad D (try67)
    Report

    thanks, but this still did not work.  Would it have anything to due with the fact that the value has a decimal?

     
    |
    Mark as:
  • blakedodson.prg
    Currently Being Moderated
    4. blakedodson.prg,
    May 4, 2012 5:35 AM   in reply to GKaiseril
    Report

    Thank you.  I don't know what Bitwise OR and Logical OR are.  I copied this formula from another forum for $0.00 vaules so that they would not show.  It worked for the $0.00 values, and it works for $125.00, but when I list a number with anything other than 00 after the decimal it doesn't work.

     

    I copied and pasted your formula and it's still showing the $135.31 value in the feild.

     

    Below is a snapshot of the form.

     

    Order Form SnapShot.jpg

     
    |
    Mark as:
  • Gilad D (try67)
    Currently Being Moderated
    5. Gilad D (try67),
    May 4, 2012 5:46 AM   in reply to blakedodson.prg
    Report

    You can use the JS console to find out what's the exact value of the field.

    Just execute this code:

    this.getField("Field Name").valueAsString

     
    |
    Mark as:
  • blakedodson.prg
    Currently Being Moderated
    6. blakedodson.prg,
    May 4, 2012 6:16 AM   in reply to Gilad D (try67)
    Report

    Thank you!!!! 

     

    That was my issue....I wasn't seeing the complete number since I had the field format set to show only 2 decimal places.  I changed the format to show more places, changed the formula, and it works!

     

    This the formula I've used:    if (event.value == "135.3125") event.value = "";

     

    Thank you both for your efforts!

     
    |
    Mark as:
  • blakedodson.prg
    Currently Being Moderated
    7. blakedodson.prg,
    May 4, 2012 8:42 AM   in reply to Gilad D (try67)
    Report

    One more question.  Can a code be written so that if another field equals a certain number, that the current field is blank?

     

    Example:  if (Field1 == "0") event.value = "";

     
    |
    Mark as:
  • Gilad D (try67)
    Currently Being Moderated
    8. Gilad D (try67),
    May 4, 2012 8:43 AM   in reply to blakedodson.prg
    Report

    if (this.getField("Field1").value == "0") event.value = "";

     
    |
    Mark as:
Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points