+ Start a Discussion
Shiva RajendranShiva Rajendran 

Can i update another field using formula field or validation rule?

I want to know if this is possible in salesforce.Lets say i have an formula field and validation rule in account object. 
I want to know if based on certain condition i can modify another field inside the formula field or validation rule.
Like if (name=='drug')
 isValidRecord=false;
If user enters name as drug on account object,then on insertion the isValidRecord checkbox should be checked using validation rule or formula field.Is it possible using these?
Thanks and Regards,
Shiva RV
 
Best Answer chosen by Shiva Rajendran
Rahul KumarRahul Kumar (Salesforce Developers) 
Hi Shiva,

You have to use Workflow rule + field update to achieve this
Create a new workflow rule on Account
Give it a name & description
Select the Evaluation Criteria as the 3rd option
Specify the rule criteria as Trader equals (leave the value as blank)
Select the action as field update and choose Trader field as the field to be updated
Choose use formula to set the new value and Enter the formula as Name
here's some help on how to create workflow rule & field update.
 

Please refer the below links for reference. I hope it will be helpful.

Best Regards
Rahul Kumar

All Answers

Rahul KumarRahul Kumar (Salesforce Developers) 
Hi Shiva,

You have to use Workflow rule + field update to achieve this
Create a new workflow rule on Account
Give it a name & description
Select the Evaluation Criteria as the 3rd option
Specify the rule criteria as Trader equals (leave the value as blank)
Select the action as field update and choose Trader field as the field to be updated
Choose use formula to set the new value and Enter the formula as Name
here's some help on how to create workflow rule & field update.
 

Please refer the below links for reference. I hope it will be helpful.

Best Regards
Rahul Kumar
This was selected as the best answer
Shiva RajendranShiva Rajendran
Hi Rahul,
Yes using Workflow it is possible.I just want to know if formula field or validation rule has any significant choice of solution for this scenerio?
Thanks and Regards,
Shiva RV