Skip to main content
Why is this throwing an error?

 

CASE (Name ,

 

"A",

 

012280000004o29,

 

"B",

 

012280000004o2E,

 

012280000004o29 )

 

It's supposed to update the Record Type of a record. (It doesn't make much sense coz it's a replica of the one my colleague was trying to do but he had the same error so I was just testing it as well to see if I could figure out why. Well I couldn't.)

 

The formula expression is invalid: Syntax error. Missing ')'
2 respuestas
  1. 2 nov 2016, 23:30
    Hi Lawson,

     

    Please try the below, you will need to put the recordtype ids in double quotes

    CASE(Name ,

    "A","012280000004o29",

    "B","012280000004o2E",

    "012280000004o29"

    )

     

    If the above is not working, convert the 15 digit id to 18 digit using the following tool and use them in the formula
0/9000