0

use if logical syntax

Hello, I have on y calculated field this logical formula: if Usuario = "ESM" then 1 else 0 end . But it does not work, even if the field Usuario contains the text "ESM" it always give me 0. I guess I'm have write wrong the script but cannot figure out why. Any help pls.

4 replies

null
    • Support
    • 5 yrs ago
    • Reported - view

    Hi, 

    What formla are you using to calculate the field Usario?

    Best, Jörg

    • ESM
    • 5 yrs ago
    • Reported - view

    Hi,

    This is the formula

    Calculo 1 formula

    This is the table where it goes.

    Table Screenshot

    Obviuosly my formula is wrong, because I only receive 0 instead of 1. If u can give my a hint I would appreciate. I whish Ninox would have a more deep manual for formulas syntaxis.

    • Leonid_Semik
    • 5 yrs ago
    • Reported - view

    if text('Creado por')="ESM" then 1 else 0 end

     

    Leo

    • ESM
    • 5 yrs ago
    • Reported - view

    Ahh must add record type. Tks

Content aside

  • 5 yrs agoLast active
  • 4Replies
  • 2270Views