IIF statement

I have a field I'm populating based on a value from the query as follow

[IIF(<UniDACQuery."fa_branch"> = 1 ,'714-541-1300.','nothing')]
which works fine but

this doesn't

[IIF(<UniDACQuery."fa_branch"> in (1,2,5,7) ,'714-541-1300.','nothing')]

What am I doing wrong? Thank you

Table editor V 5.2.1.3

I think it is language limitation

[IIF(<UniDACQuery."fa_branch"> in (1,2,5,7) ,'714-541-1300.','nothing')]

Try using or

[IIF(<UniDACQuery."fa_branch"> = 1 or <UniDACQuery."fa_branch"> = 2 ,'714-541-1300.','nothing')]

John,
Support Team

I tried that already and it didn't work

Put it in brackets

Peter

I did exactly what john said

[IIF(<UniDACQuery."fa_branch"> = 1 or <UniDACQuery."fa_branch"> = 2 ,'714-541-1300.','nothing')]

but it didn't work but if I use multiple IIF like this

[IIF(<UniDACQuery."fa_branch"> = 1 ,'714-541-1300.',iif( <UniDACQuery."fa_branch"> = 2,'714-541-1300.', 'nothing'))]

But this would create a huge code, imagine if I have 10 values.

Not really

[IIF(((<UniDACQuery."fa_branch"> = 1) or (<UniDACQuery."fa_branch"> = 2)) ,'714-541-1300.','nothing')]