requirement on fields if condition

Wed, 25 Nov 2020 16:16:04 GMT

i have tried with different ways but i couldn't get exact output.this condition i need to write backed script.here need to derive contact name field.

IF(

BTS Contact = Manager

)

THEN

(WHEN PTR= MDC, Contact Name = “Juli ”

WHEN PTR= MTR, Contact Name = “Terri”

WHEN PTR= Pharma, Contact Name = “Kelly ”

WHEN PTR= Corporate, Contact Name = “Na’Tasha “ )

ELSE IF(

BTS Contact = Solution Manager

)

THEN

(Contact Name = solution_manager_name) // solution_manager_name is field name

ELSE IF(

BTS Contact = Project Manager

)

THEN

(Contact Name = project_manager) // project_manager field name

note : i need to get the data from these fields(solution_manager_name is field name,project_manager field name )

Thanks

Siddik

Re: requirement on fields if condition

sunny_talwar — Wed, 04 May 2016 19:37:29 GMT

Try not to create duplicate threads please