Skip to Content
avatar image
Former Member

Delete content when the text is 0.00

Hi forum

I want to delete the content of a field in a table when the text equal to 0.00

Example:

In text = 0.00

I want = ' ' (nothing).

Is this possible ? Maybe a patron ...

Thnks

Josue

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Aug 19, 2008 at 04:17 AM

    Try placing the following code in the "EXIT" event of your text-field. Remember to set the scripting language to Javascript

    
    if (this.rawValue == "0.00"){
    this.rawValue = "";
    }

    hope this helps,

    harman

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thnks Arman...

      I make it with FormCalc

      This code is for rows of a table

      
        if ( FIELD[*] == "0.00" ) then
               FIELD[*] = ""
        endif
      
       

  • avatar image
    Former Member
    Aug 19, 2008 at 04:58 AM

    buddy i have a alternative of this , i also encounter the same problem after much of trying i took the field as character ..

    this sort my problem as if the field is declared as character then nothing wil come if the field is empty.

    Ankesh

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 19, 2008 at 09:30 AM
    if (this.rawValue == "0.00"){
    this.presence = "hidden";
    }
    Add comment
    10|10000 characters needed characters exceeded