Validation rules help assure entered data meets basic requirements for consistent and clean data.

learn more… | top users | synonyms

0
votes
0answers
9 views

Validation rule to compare the queue name with a Custom object field

I need to create a validation rule to compare the text field value (which is input type) with the Queue list present in my org and if the Text field value is not present the into the Queue List then ...
3
votes
1answer
35 views

When creating an EventRelation of a public calendar validation does not function as expected

I'm using Process Builder and Visual Workflow to sync a custom appointment object and its "Room" selection picklist with the public resource calendars we set up for our conference rooms. Here's how it ...
0
votes
2answers
37 views

Validation Rule for Phone Number that should only contain numbers and +

I'm trying to create a validation rule for Phone Numbers. Say, I have three Phone Number fields that should be checked if the values meet the following requirements: phone numbers should be 10-12 ...
0
votes
2answers
25 views

Help with Validation Rule

I need to write a Validation Rule that states: When a user manually tries to change or update the value of Stage on Opportunity object it should throw an error. On opportunity there exists an Approval ...
1
vote
1answer
15 views

Record read only based on field create/update from external system [closed]

We have SFDC - Employee Integration with external HR System, Question is when we receive back the ‘Employee Identifier’ from HR System, I need to make the employee record read only? pls suggest ...
0
votes
2answers
38 views

Help required in building formula for validation rule

I have 3 objects Contact(standard), Volunteer job(custom) and Volunteer hour(custom). Volunteer hour is a junction between contact and Volunteer job. Contact has a custom picklist field 'status'. my ...
7
votes
0answers
33 views

State & Country picklists - importing leads with states for countries without states enabled

Tell me that I'm wrong but it would appear the State and Country picklist feature makes it impossible to integrate / import Leads with state values from countries where you are indifferent to the data ...
0
votes
0answers
23 views

Include a string in REGEX

I have below error condition formula active in a validation rule. Formula AND(OR(REGEX(Name,".*(?i)(p[. ]?o([. ]?|st[ ]?office))[. ]?box.*")), NOT(ISPICKVAL(Address_Type_abv__c,"Mailing"))) String ...
0
votes
1answer
40 views

error when trying to approve request

hello i created a trigger who auto submit the approval request into the approval process. when i create opportunity with the entry criteria of the trigger and the procces i get to approval requeset if ...
3
votes
1answer
46 views

Exempt Visualforce Page From Validation Rule

I have the following Validation rule Active: Error Condition Formula: ISPICKVAL(First_Ranking__c , "") When I try to submit the visualforce page I'm getting the validation error asking to select. ...
4
votes
3answers
133 views

Validation rule is not working as expecting

Hi i got a requirement like create a validation rule based on probability. The requirement is user cannot modify some custom field called forecast units If probability is under 70% So, i write a ...
3
votes
2answers
49 views

How to make field disabled using validation rules

I have two fields checkbox and a textbox field, if the user clicks on the checkbox checked than I want to enable the textbox field otherwise remain disabled. I'm not sure if this is possible using ...
1
vote
1answer
34 views

Disabling Validation rules?

I'm not sure disabling validation rule is the only way out for this particular scenario but you guys can chime-in ideas how to approach this particular issue. I have the following validation rules on ...
0
votes
0answers
23 views

Workflow is not working as expected

Hey i got a scenario like i have a custom field called Demo date in custom object. So i got a requirement like user had to select date only once.If they try to modify they will an error. So for this ...
0
votes
2answers
50 views

Validate that a URL begins with

I do not find anyway that you can validate a valid url when the user enters in the standard page so I come up with this validation and I need little help to fix it. I'm using BEGINS to see if the url ...
0
votes
1answer
19 views

Validation on Dependent Field in Standard Page

How would I go implement validation on a standard salesforce page? The validation rules are: I have the following: 1) Attachment - Checkbox (default checked) 2) URL - Textbox If the Attachment ...
1
vote
1answer
33 views

Displaying error message besides the field responsible for occurrence of error from Apex code

I am trying to display a form that creates multiple Contact records from my Visualforce Page. I don't want to use inputField to achieve the same. The requirement is that if I do not enter LastName ...
1
vote
2answers
37 views

Prevent validation of a specific required input field when button is clicked

How can a commandButton ignore validation for one particular required field? I am working on a seemingly simple portal account page with the following markup: <apex:page ...
6
votes
2answers
54 views

Forced execution of validation rules?

Is there a way to force execution of all validation rules? Ultimately, I'd like to test an oppty against VR's, just as if you Edit/Saved, but without modifying its timestamps. That way I can see how ...
2
votes
1answer
86 views

Task email notofications

If we assign a task to someone else, we can get an automated notice when the task is completed. For that i have written one trigger mentioned below that trigger is working fine but email is being ...
2
votes
1answer
85 views

Bypassing validation rules while updating object by apex trigger

I have validation rule on a date field that 'Start Date shouldn't preceed today'. I have an trigger which updates another field of the same object. Now when trigger runs on old records field ...
0
votes
1answer
27 views

Use AddError() inside an Apex Class

Is there any way that we can use addError() inside an apex class? I know it will work properly inside a trigger. But i would like to have a separate class for all validations instead writing them ...
0
votes
2answers
29 views

Help with the Validation Rule on Custom Object

As per the standard functionality in Salesforce, when we hit Enter the record is saved automatically & we are directed to the detail page of the record. But I want to restrict the user from doing ...
0
votes
1answer
31 views

Validation rule not working

I have few scenarios When ever stage picklist - Support selected and saved, it should not save if any of the fields address,state,city are blank There is a check box, if it is enable to true then ...
1
vote
1answer
38 views

Setting a validation rule on a custom object date

Hi I`m trying to implement a validation rule in a custom object with reference to another custom object. Both are date-objects. I tried the following Code. The syntax is correct according to ...
1
vote
1answer
39 views

Custom controller, default object values, and validation. How can I get all three to work in harmony?

I have a Visualforce page that is backed by a custom controller. The custom controller has a public property of type Event (called ThisEvent) that the Visualforce page uses to bind to several input ...
-1
votes
1answer
50 views

Apex:pageMessages Only Displaying First Error on Visualforce Page

I have a visualforce page in which I have set many inputFields as required. When I click save and if no values have been entered for the required fields i do receive an error message Error: You ...
3
votes
2answers
31 views

Why are my validation messages not displaying on my Visualforce page?

I have a Visualforce page with a custom controller. Whenever there is a validation error on saving, the user is shown a white page with the text SObject row does not allow errors: I have followed ...
0
votes
2answers
33 views

Combine two validation rules

I have two validation rules. I'm not able to use this validation at a time. I want to combine these two validation rules into one. One rule Accept lead owner as user. When lead owner is set to queue ...
0
votes
4answers
40 views

Date Validation?

Below is the validation rule which I have written: AND( BRP_Unconditional__c = true, NOT(OR(DATEVALUE(CreatedDate) < DATE(2016, 20, 3), Web_Form_Source__c = "goldrush.oliverhume.com.au", ...
0
votes
1answer
26 views

Logged in user can only edit the record they relate to. Validation Rule

Is there a way to retrieve the current user in a validation rule? The logged in user will be logging in from a community. Need to make the record only editable if the Logged in user matches the ...
1
vote
1answer
42 views

Unable to choose correct picklist value

I have a problem that in my validation rule. I have a picklist field called "Status". It contains value like,"Progress,Completed,Won,Lost". If picklist prior value is "progress", then i want choose ...
3
votes
2answers
206 views

Resource is inserted even thought it has a conflicting schedule with another event

I am using standard Public Calendars and Resources where I have 2 types of resources, Vector Unit and Demo Unit. Now if any of the resources have a conflicting schedule, a standard Salesforce error is ...
1
vote
0answers
24 views

Resource validation firing incorrectly

I have 2 resources, Vector Unit and Demo Unit. I am creating an event with these Resources which is the standard Public Calendars and Resources. I am putting all the resources and its Ids in a Custom ...
1
vote
2answers
31 views

Text field validation rule

In contact object I have a Title field as type text. If anybody enters a number in this field, it should throw an error. How can I achieve this with avalidation rule?
2
votes
1answer
80 views

Validation should not fire for a specific user

I have a requirement where a certain field can be edited without the validations firing for a particular user. Now I tried to write rule like LastModifiedId != '005000000000000AAA' but the validation ...
1
vote
1answer
27 views

Fire validation rule while opportunity stage change

I want to fire validation rule when opportunity stage is moving from Customer Intake to Opps Planning. When opportunity stage change it should check that Account.Mask_Manufacturer_Model__c is not ...
0
votes
1answer
16 views

apply validation on mailing address on contact object but given Error: Syntax error. Extra ','

ISBLANK ( MailingCity), ISBLANK ( MailingCountry ), ISBLANK ( MailingPostalCode ), ISBLANK ( MailingState ), ISBLANK ( MailingStreet ) if any field like city , country , postal code, state, street ...
0
votes
4answers
38 views

Validation Rule Issue

been going around on this. Can anybody spot whats the issue? I'm just trying to get a validation rule to work. Basically, if someone select a certain option in a picklist, I want to make sure that all ...
1
vote
1answer
33 views

Any standard functionality to popup error message on validate fields

I want to validate three fields and any one of them is not satisfied, after click on the button, should fire one dialogue box with error message. Is there any standard functionality to achieve this?
0
votes
1answer
26 views

Field Validation Rule for Location

How to Lock Location Field on a Custom Object Country. The requirements are to be able to create NEW LOCATION field or Populate the Location if it's NULL upon creation the FORM. But wouldn't be able ...
0
votes
1answer
26 views

Show alert on validation rule

Can you show alert message on standard page layout? when user change the lookup value and try to save? here is my scenario, I have a lookup on a standard page layout and when the user change to any ...
6
votes
2answers
151 views

Number Field - Limit Four Characters - Validation Rules

I'm having trouble enforcing a minimum character requirement on a Salesforce number field (using Validation Rules). I can get the limitation to work on a text field using: AND( ...
1
vote
1answer
41 views

How to do validation on visual force page

here i am trying to do validation here but i don't know how to do that on the following vf page- Validations: a. If Product Type is New, please populate the Service Start Date and the Full Revenue ...
1
vote
2answers
74 views

Visualforce input validation best practices

I have multiple Visualforce pages with inputText that needs to be validated that: Correct datatype Correct length Regex (ssn, phone number) What is the best way to do the validation? ...
0
votes
3answers
84 views

Validation on Landing Page

I want to do a very basic validation on the Smart Capture form on the landing page. I used AMPScript to do the same like below - %%[ SET @lname = RequestParameter("LastName") IF Empty(@lname) ...
1
vote
1answer
24 views

Validate Contact name on Quote object

How do you validate if the Contact name field is left empty or not on Quote? I do see that, its a lookup field and using the code as below on trigger always return false. for (Quote objQuote : ...
0
votes
0answers
25 views

Validate rule (VR) Competitor field is not equal to 0 and associated with multiple stages of an opportunity

Using rollup summary field pointing to a related list, need to validate 5 of the 8 stages to be sure that there is a value in the related list. The related list formula field is working correctly, ...
2
votes
1answer
55 views

how to compare three date fields in validation rule

i was trying to compare three date fields in validation rule and i used this formula And( (Start_Date__c < Revision_Date__c) , (Revision_Date__c < Close_Date)) Close date is a standard field ...
0
votes
1answer
93 views

Validation Rule on Phone Field to allow only Numbers or Blank

I wanted to write a validation rule for default Phone field. AND( NOT(ISBLANK( Phone )), NOT(ISNUMBER( Phone )) ) it works fine but allows only 9 digits. What could be the problem? When ...