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

learn more… | top users | synonyms

1
vote
1answer
13 views

Create Validation for a custom object line item on an opportunity

I have created a custom object called Billing Forecast with a master-detail relationship to the opportunity object. When an opportunity is closed won I need to ensure that the user enters at least ...
0
votes
3answers
36 views

Visualforce does not process/validate fields on page

I have an apex:inputfield of type date (on a custom object) on the page but when I click on it, the calendar does not show up. On another number field, when I type in 100k, it does not change to ...
0
votes
1answer
22 views

validation rule without entering duplicates numbers

i have two fields.one is display order type(number), sectionname type(picklist). now i want validation rule for each section under picklist displaying the numbers in display order field without ...
0
votes
1answer
20 views

field(check box) should be populate based on condition is related to other objects

I have the field in Devfull called Is Direct on the Account object. I need it populated under the following circumstances. For a Pending or Active Partner (using the Partner Status field on the ...
0
votes
2answers
38 views

Validation Rule in Apex Trigger not working as expected

I have created an Apex trigger to replace the many validation rules on one of our custom objects, all work as expected except one (I have left out all other validations to make the below code more ...
3
votes
2answers
99 views

field should start with 304050 in salesforce

I have a custom filed with number datatype and i have a requirement the the field should always start with 304050 and i have to write a condition that it must always contain 16 digits. Is is Posible. ...
1
vote
3answers
67 views

validation rule for external user

I need to create a validation rule which should not be fired for External user(Community User) but it should be fired for Internal user(Salesforce user).
-2
votes
2answers
23 views

Validation Rules

The rule needs to force both these fields to be completed when either one gets populated Field1 of type DATE Field2 of type LookUp i.e. if is completed it must force to be completed OR if is ...
3
votes
0answers
31 views

Formulas in workflows & validation - lazy or eager evaluated?

I tried to run some tests in developer edition and didn't see great difference so I am not sure. Basically I have a case that CPU time is leaking somewhere and I suspect it's validation rules or ...
4
votes
2answers
31 views

Inputcheckbox Required field not throwing a validation

I created an apex:inputCheckbox and I made that checkbox required in the Visualforce page, by using required=true. I filled in all the fields except this checkbox and hit save, the fields are saving ...
1
vote
2answers
47 views

Validation Rule to restrict not to create any new user records with “Salesforce” Licence

For one requirement, I was trying to write a validation rule on USER object. Requirement: I need to restrict users not to create any new users with Salesforce licence. I have tried this ...
-5
votes
2answers
46 views

I need a validation rule for below requirement [closed]

I need a validation rule for = If values in multiselect picklist matches any of the values on the multiselect picklist then it should not allow to save
1
vote
0answers
36 views

Opportunity name validaiton by using the Regex method in Validation rule

I have used the below code for check the field value should be the title case. it is working fine but when I entering capital letter for all text, it is not throwing the error. but it should through. ...
4
votes
3answers
92 views

Validate data as “unit of work”

Fairly new to Salesforce and come from a non-SFDC enterprise development background. Using FinancialForce framework and enterprise patterns in our development. Question as it relates to best ...
-3
votes
1answer
47 views

how to write a validation rule that prevents users from entering any number starting in “07” in the contact phone field

I want to prevent a user writing a number that begins with 07 in the phone field on the contact object
5
votes
4answers
148 views

Validation Rule To Allow Only One Checked Record

I have a custom object Object_X, which has a checkBox field Activate__c. My requirement is that only one Object_X type record can have the Activate__c checked at any given time. So if Object_X already ...
3
votes
3answers
70 views

Show validation rule error next to the multiple field

The below validation rule works fine but I'm curious to know how can I show the required error message next to the field? As you can see below I have multiple fields and I have selected to show the ...
0
votes
2answers
21 views

Validation Rule to the Default Value

I have field that is decimal and by default I have 0.00 so when the page loads it has the default value which is again 0.00, when I try to validate ISBLANK OR ISNULL it passes the validation but how I ...
0
votes
1answer
33 views

Validation Rules: If the status is change

EDIT: I have break down the validation and I found where it is failing: the below validation works fine and it fires when I try to save the blank: AND(ISPICKVAL(Status__c, "Completed"), ...
1
vote
0answers
19 views

Validation Rules and the REST API

I'm testing the REST API using workbench on an object that has many validation rules. Why is is that the REST API only returns a single error, instead of an array? If this were in a normal visualforce ...
1
vote
1answer
65 views

How to disable input text without loosing its value when page is reloaded due to validation failure

I have a apex:inputText field which is disable in following 2 ways 1. <apex:inputText Id="pBSId" value="{!pBSId}" disabled="true"/> <apex:image value="/s.gif" ...
1
vote
2answers
60 views

Declaratively create logic in your org that prevents two Opportunities from being created on a single Account in a single day

Found this question on sfdc99.com as an example of possible Salesforce developer interview questions. Does anyone know how this can be done? Of course, without coding.
5
votes
3answers
131 views

Prompt before saving record

I have a requirement where if a Case is saved without a value in a field, the page needs to prompt the user if they are sure they want to save. This would need to be on a standard page layout. I was ...
0
votes
1answer
29 views

validation rule Either Opportunity Name field or Case Number field must be populated, but not both [closed]

validation rule : Either Opportunity Name field or Case Number field must be populated, but not both. plz help me on this
0
votes
0answers
27 views

Catch for Approval process

I know approval processes can skip validation rules - does anyone know if there's a way to send a mistakenly approved object BACK a step in the process - via workflow, process builder or trigger? ...
0
votes
2answers
39 views

using validation rules child field should be automatically updated by parent field

i want to populate child field value automatically from parent field value by validation rules for ex: in Account object country field should automatically populated in Contacts country field please ...
0
votes
2answers
31 views

Validation rule for end date and open date

I have real time scenario which i am facing now is that there are 2 fields, open date and end date respectively. when a user enter end date one should get an error that must enter open date when you ...
2
votes
2answers
154 views

New To Salesforce - What Are These Two Validation Rules Saying/Meaning?

I am trying to determine what the following validation rules are saying or mean. Can you please help? VALIDATION RULE 1 IF(AND( Amount > 100000,ISPICKVAL(StageName, "Closed ...
1
vote
1answer
28 views

Bulkify trigger that checks if a recordtype exists on an account

I am trying bulkify the trigger below. The ERAPayer field is a text field for entering an acccountnumber. What the trigger is doing is on insert of a new payerconfig record, when ERAPayer field is ...
1
vote
2answers
37 views

Validation Rule criteria

I have two custom objects Event & it's child Event_Attendee. Now I have a Mobile ID field on Event_Attendee based on which I need below validation Rule. OR(AND(Event_Attendee_Count__c > 1 , ...
0
votes
1answer
36 views

Dilemma - How can I overcome a race condition (loop) in validation/workflow rules?

I have a validation rule on oppty stage, that prevents our partners from setting it over 0.70. AND( Probability > 0.70, $Profile.Id = "00e2000000xxxxt" ) There is another WFR that is based on ...
6
votes
1answer
94 views

Validation Rule to count words

What I'm trying to do a validation rule to count number of words in a text field and return an error if field have more than 80 words. Validation Rule Condition Formula NOT(REGEX(TRIM( ...
3
votes
2answers
102 views

Validation Rules For User Object

I Need to create a validation Rules that when New User created then Manager Field should be Required. For that I have created a validation Rules below, but it is not Working. NOT(ISBLANK( ManagerId ...
2
votes
2answers
34 views

Validation rule on lead to prevent conversion

Was hoping someone could help with the following: I would like to prevent a user from Converting a lead that does not have 1. at least 1 alpha character (upper or lower case) - (A-Z) or (a-z) 2. Or ...
0
votes
1answer
19 views

Validation Rule for QuoteLineItem Quantity field

Quantity field is a Number(10, 2) datatype User need to enter only be whole numbers like 1.00,2.00,3.00 not 1.5 or 2.75 If user enters 1.5 or 2.75 I need throw validation error message. Thanks
2
votes
1answer
77 views

Show DML exception in VF page

Summary of what i am doing - I have a standard Object - ServiceContract, its child (detail) standard object ContractLineItem, and a custom object (Transaction_Line_Item__c) which is a detail to ...
2
votes
1answer
51 views

Getting Error in Mail Validation

Hi i am getting this error when I try to validate an email: [documentation] => https://code.docs.exacttarget.com/rest/errors/500 [errorcode] => 0 [message] => Internal Server Error The code was ...
0
votes
1answer
57 views

Validate fields on Lead Conversion

I want to ensure that a user cannot convert a lead without ticking three checkboxes (below). Below is my validation rule but it still allows the user to convert the lead. Any ideas? AND(IsConverted = ...
0
votes
1answer
58 views

Opportunity Validation Rule Will Not Fire

I have a validation rule that doesn't seem to work. I think the issue is the Stagename field. I've tried the Stagename values with and without spaces. When I have a record that should meet the ...
0
votes
1answer
28 views

New button on Related list to be active based on condition

I have a Sturdy(Custom Object) related list under Account object, i do want to make the New button of the Sturdy related list to be displayed only if the Account status is Active?
1
vote
2answers
44 views

Validate Date from another object

I want to create validation rule on Object 1 to check date on another custom object Object 2. The Object 1 has a look-up field to Object 2. I want to compare create date of record of Object 1 and ...
2
votes
0answers
22 views

Custom Validation on Knowledge Articles

I want to add some custom validation on articles. The problem is that articles don't support validation rules(idea) nor do they allow triggers(idea). You can do Process Builder or workflows, but those ...
2
votes
1answer
80 views

Unable to validate the date in VF page

I have two date fields (Start Date & End date) which i want to compare (End date should be greater than Start Date). For comparing i'm using Date.parse() of javascript. When the locale of my SF ...
2
votes
1answer
48 views

How can I create Opportunity Validation Rules without breaking Lead Conversion?

In our Salesforce process, our Opportunities have a custom Picklist field called 'Vertical' to track the industry segment of each Opportunity. I'm trying to make this a required field. I'd like to ...
2
votes
1answer
77 views

XOR operation on two checkboxes in Salesforce

I need to make a selection of Gender. [ ] Female [ ] Male. Either one of them must be selected. I used following formula for validating. AND( Female__c = TRUE , Male__c = TRUE ) Using this, I ...
-1
votes
1answer
39 views

Validation rule on PickList Values

Hi I am having picklist field having three values "L1 Queue","L2 Queue","L3 Queue" intially at the time record cration created with L1 Queue.Next time i want to update my record to "L2 Queue" If ...
2
votes
1answer
62 views

Validation not firing properly

I have a validation rule: When the stage name is changed to "4. Proposal" then the max discount should be > 5 and Special_Pricing_Approved should be = false. My validation rule: ...
2
votes
3answers
135 views

How to validate the opportunity name by using the Regex method in Salesforce Validation [closed]

I wanna check the field value should be the title case. how to write the validation rule for this. It should be allow the special char and symbol. I have used the below code: but it shows syntax ...
2
votes
3answers
53 views

How to check the Field value Case

I wanna check the field value should be the Case sensitive. So, how to achieve this by using validation rule. e.g John Milton Roa - Ltd.
2
votes
1answer
43 views

find fields which are null for all records on object

I am writing some business rules which expect data to be captured properly in many fields while record creation. Most of the fields for most of the records are blank and not captured by user. We need ...