0

right syntax of a trigger with double condition

I want to make a trigger that is execute on ly in case of 2 condition of the same record are verificate….but I don’t find the way with the syntax….
I tried with comma, +, nothing….but in everyone of these the formula ignore the first condition ['TODO.2' = 31] and consider only the second [CHIUSURA = null])

below an extract of the formula..
————————————————

let jj := cnt('3. Commissioni'.'Elenco Workflow (tutti)'['TODO.2' = 31],[CHIUSURA = null]);
…….
let result := dialog("COMPLETA WORKFLOW", "Confermi?", ["Si", "Annulla"]);
if result = "Si" and i = 31 and jj > 0 then
…..(something)

2 replies

null
    • Jorg
    • 4 yrs ago
    • Reported - view

    Hi Yuri, 

    Please try the following: 

     

    let jj := cnt('3. Commissioni'.'Elenco Workflow (tutti)'['TODO.2' = 31 and CHIUSURA = null]);

     

    Best, Jörg

    • Yuri
    • 4 yrs ago
    • Reported - view

    ok. it runs 

     

    thanks

Content aside

  • 4 yrs agoLast active
  • 2Replies
  • 1143Views