+ Start a Discussion
Leanne NorthcottLeanne Northcott 

Validation Rule - if one field is blank then check another field

Hi everyone
I am trying to write a validation rule to remind the user to check one field if another one is blank

IF Application Source (which is a text field) is blank then either prompt the user to tick the Internally Applied checkbox or even better, automate the process

Hope this makes sense and thank you in advance

Regards, Leanne
mukesh guptamukesh gupta
Hi Leanne,

if you want to stop user then you can use validation rule, or you can use workflow/process builder for automated updation.

if you need more clarification, please let me know.

Please Mark as a BEST answer. 

Regards
Mukesh
 
ANUTEJANUTEJ (Salesforce Developers) 
Hi Leanne,

>> https://www.salesforceben.com/simple-salesforce-explained-how-to-get-started-with-validation-rules/#:~:text=ISBLANK(field)%20returns%20%E2%80%9CTrue,a%20specific%20field%20is%20blank.&text=This%20button%20lets%20you%20check,you%20what%20the%20problem%20is.

As mentioned in the above link you can use the steps mentioned to use the below rule to check if the application source is empty,

ISBLANK(Application Source)

If you are trying to automate the process as mentioned in the below link,

>> https://trailblazers.salesforce.com/answers?id=9063A000000Dc7VQAS

you can try the mentioned solution.

You could also check flows that run on before inserting the record.

Let me know if it helps you and close your query by marking it as solved so that it can help others in the future.  

Thanks.
veer soniveer soni
hi Leanne,
you can get referance from following img.
User-added image
Formula is : IF(ISBLANK(Site), true, false)
you can replace your "text field name" with "Site" And set the error on your checkbox field(that you want to alert) In Error Location.

let me know if it helps you and if it resolve your issue then marking it as best answer.
Thank you
Suraj Tripathi 47Suraj Tripathi 47

Hi Leanne Northcott,

Try this validation rule on that object where you want this functionality:

ISBLANK(BillingCity ) || ISBLANK(BillingCountry)

 

Please mark it as best Answer,if it helps!
Thanks

CharuDuttCharuDutt
Hii Leanne Northcott
Try This Validation Rule
IF( ISBLANK( Application_Source__c ) ,true,false)

ERROR MESSAGE : Fill Application_Source__c Field
Or You Can Try Process Builder

User-added image
1: If Application Sorce Is Null  Internally Applied checkbox is Checked
User-added imageUser-added image
2: If Application Sorce Is Not Null  Internally Applied checkbox is UnChecked
User-added image User-added image
Please mark it as best Answer,if it helps!
ThanksYou!