AnsweredAssumed Answered

Calculated checkbox is not working properly in 7

Question asked by Gaelle Fernandez on May 2, 2014
Latest reply on May 5, 2014 by paperless
Hello everybody!

I'm using Sugar Enterprise 7.1.5 (build 1173) and I'm trying to create a checkbox field calculated after a dropdown field.

What i have :
A dropdown field, compte_type_c with that custom list :
index[label]
blank[-blank-]
pole[Pôle]
concession[Concession]
[...]
agent[Agent]
mra[MRA]
ga[GA]
gf[GF]

and my check box field, compte_interne_c
This one has to be checked if compte_type_c is different from "Agent","MRA","GA" or "GF".
Like that :
compte_type_c :                               compte_interne_c
blank                                                  0 (not checked)
Pôle                                                   1 (checked)
Concession                                       1 (checked)
Agent                                                 0 (not checked)
MRA                                                  0 (not checked)
GA                                                     0 (not checked)
GF                                                     0 (not checked)


So, in the calculated formula, i've wrote (with indexes instead of labels form the dropdown) :
ifElse(isInList($compte_type_c,createList("agent","mra","ga","gf")),0,1))
But Sugar tells me that the formula has to be boolean. But it is!

Maybe i'm not doing it right, so please could you help me?

Thanks

Outcomes