This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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"
There were mistake, but it's not reason. IT was only translation error.
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 this works: