function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
lakshya agrawallakshya agrawal 

Anyone can help me with this issue- Create a validation rule to update ‘Export to OpenAir Approved’(Checkbox Field) to yes for any opportunity when Mirror Track ID(Text Field) is blank.

SwethaSwetha (Salesforce Developers) 
This is the same as https://developer.salesforce.com/forums/ForumsMain?id=9062I000000BniB. Let's continue to discuss this on earlier thread.

Validation rules cannot be used to update fields.  Thank you
Eswar Venkat 2Eswar Venkat 2
AND(ISBLANK(Mirror_Track_ID__c), NOT(Export_to_OpenAir_Approved__c))
 
Arun Kumar 1141Arun Kumar 1141
Hi Lakshya,

If you want to update ‘Export to OpenAir Approved’(Checkbox Field) to yes for any opportunity when Mirror Track ID(Text Field) is blank, You can go with the following :
1. Workflow Rule
2. Record-Triggered Flow
3. Trigger

You can only restrict user to check the 'Export to OpenAir Approved' checkbox when 'Mirror Track ID' is not blank through validation rule by throwing some error by using formula  
AND(ISBLANK(Mirror_Track_ID__c), NOT(Export_to_OpenAir_Approved__c))

Hope this will help.
Thanks!