hi
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
