1. Lets consider Field A under Account object, and it displays (Value as "123" by default and users can modify to any value) while creating a new Account record.
2. Once user clicks on save button, an workflow will run in backend to update Field-A. Find the logic below.
IF
(Field-A = "123", then it will modify as "ABC")
ELSE
(Field-A = whatever value user provided while creating a record.
3. I want to display value as "XYZ" instead of "ABC" for certain users alone.
Consider User = Carthick, so if I am creating any account record with default value for Field -A as "123" then value should be updated with "XYZ" and for other users it should be "ABC" only.
Please suggest me with code/logic. Not sure on how to use multiple if conditions in formula field under workflow rule. I guess it can be achieved via writing a trigger, but pls suggest me by using workflow.
3 réponses
Hi Carthick,
You can try using If inside another if.
IF(Field-A = "123" AND user!=Carthick, "ABC", IF(Field-A = "123" AND user=Carthick), "XYZ", "ABC"))
Regards,
Tamilselvan.
