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

Hi,
What formla are you using to calculate the field Usario?
Best, Jörg

Hi,
This is the formula
This is the table where it goes.
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.

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

Ahh must add record type. Tks
Content aside
 6 yrs agoLast active
 4Replies
 2271Views