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
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.