How I can change the field value based on the second field

[Ninjago]

Hi!

I have the problem the change the field value based on the second field. Could anybody help me?

I tried next formula, but I get the Title field to 0

IF [Name] = "Norman" THEN [Title] = "Nurse"
ELSEIF [Name] = "Damien" THEN [Title] = "Doctor"
ELSEIF [Name] = "Kaarin" THEN [Title] = "Assistent"

ELSE [Nimike]
ENDIF

[Ninjago]

There were mistake, but it's not reason. IT was only translation error.

IF [Name] = "Norman" THEN [Title] = "Nurse"
ELSEIF [Name] = "Damien" THEN [Title] = "Doctor"
ELSEIF [Name] = "Kaarin" THEN [Title] = "Assistent"

ELSE [Title]
ENDIF

[vishwa_0308]

Hi @Ninjago,

Select the field you want to update or create one then writes as follows:

IF [Name] = "Norman" THEN "Nurse"
ELSEIF [Name] = "Damien" THEN "Doctor"
ELSEIF [Name] = "Kaarin" THEN "Assistent"

ELSE "[Title]"   // or whatever vale you want to pass.
ENDIF

Thanks,

Vishwa

[Ninjago]

Thanks this works:

IF [Name] = "Norman" THEN "Nurse"
ELSEIF [Name] = "Damien" THEN "Doctor"
ELSEIF [Name] = "Kaarin" THEN "Assistent"

ELSE [Title]
ENDIF