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
    • Sean
    • 4 yrs ago
    • Reported - view

    Use "and" instead of the comma...

     

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

     

    Similar to your if-condition.

    • Yuri
    • 4 yrs ago
    • Reported - view

    thanks!

Content aside

  • 4 yrs agoLast active
  • 2Replies
  • 1155Views