IF Then statement in VC in statusfield

[Former Member]

Hi there,

question:

a status field gives an outpuit of 1, 2, 3, or 4

if it gives an output of 1 then I want to show the text 'any tekst'

if it gives an output of 2 then I want to give the tekst 'any other tekst'

I tried the IF(1,'text', 'anytext') for the status field man and wife and that works BUT I have 4 different status possibilities (1,2,3 or 4)

can anybody help me

STEVEN

[Former Member · Accepted solution]

hhhhmmm

I have one field called status

it can be filled with a 1 2 3 or 4

when field has a 1 i want to show teh text MARRIED

when ...2 ... DIVORCED

when ..3...etc.

what will be the visibility statement. as far as I know you it only affects one field show or not show...or a formula...but what will be the formula if you have 4 different inputs

steven

[Former Member · Accepted solution]

Hi,

you need to concatenate (long english word!!!) the IF statements as follows:

IF (@Field == 1, "Text1", (IF (@Field == 2, "Text2", (IF (@Field == 3, "Text3", (IF (@Field == 4, "Text4", "No text")))))))

OK? Ok!

[Former Member]

Hi,

why don't you play with visibility condition ? showing or hiding the 4 fields depending on the value of your output

Fabien.

[Former Member]

Hi Fabien,

can you show me a formula or example that will give this result

do you mean and IF in an IF statement?

gr steven

[Former Member]

Hi,

I mean using visibility condition on each field, with one IF statement different for each fields you have