Formula !=

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • peterberlin
    Active Community Member
    • Mar 2015
    • 1004

    #1

    Formula !=

    hello
    I want to check a enum field with formula if it is empty.
    fieldname != null
    does not work
    Version 5.1.2
    peter
    Last edited by peterberlin; 04-13-2018, 06:50 AM.
  • yuri
    EspoCRM product developer
    • Mar 2014
    • 9642

    #2
    Hi Peter,

    try

    !fieldname

    Comment

    • peterberlin
      Active Community Member
      • Mar 2015
      • 1004

      #3
      doesn't work either

      Comment

      • tanya
        Senior Member
        • Jun 2014
        • 4308

        #4
        Hi,
        empty value for enum field is a string, so try fieldname != ''

        Comment

        • yuri
          EspoCRM product developer
          • Mar 2014
          • 9642

          #5
          You want to check if field is empty but you check if field is not null.

          Comment

          • peterberlin
            Active Community Member
            • Mar 2015
            • 1004

            #6
            All right.
            I have to check for "empty", not "null". Tanya's advice helped.
            Thank you.

            Comment

            • yuri
              EspoCRM product developer
              • Mar 2014
              • 9642

              #7
              !fieldname should work either.

              Comment

              Working...