Formula !=

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

    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
    Member
    • Mar 2014
    • 8440

    #2
    Hi Peter,

    try

    !fieldname
    If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

    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
          Member
          • Mar 2014
          • 8440

          #5
          You want to check if field is empty but you check if field is not null.
          If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

          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
              Member
              • Mar 2014
              • 8440

              #7
              !fieldname should work either.
              If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

              Comment

              Working...