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

learn more… | top users | synonyms

2
votes
2answers
47 views

ISNEW() Validation rule causing triggers to fail

I created the following validation rule on my contact records: IF( ISNEW()&& ( FormAssembly__c =""&& TEXT(LeadSource)="") && TEXT(Contact_Source_List__c) ="",TRUE,FALSE) I ...
1
vote
1answer
28 views

Validation fails, but no exception generated

I have a VF page for input of a custom object. As part of the object, I have validation rules. My problem is that a failing validation fails to generate an exception. It also fails to create the row ...
1
vote
2answers
26 views

Change Opportunity's owner without validating Opportunity's fields?

I want to change Owner of an Opportunity (an owner of an opportunity left company and all his opps need to be transferred to another user). Is there any way it can be done without validating record? ...
0
votes
1answer
32 views

Validation Rule that Exempts a certain Account

I'm trying to write a validation rule that will exempt a certain Account from the validation rule. The conditions are If the Quote_Issued_To is EricSSH Electronics and the Product_NCNR = 'Yes' don't ...
0
votes
2answers
53 views

REQUIRED_FIELD_MISSING, Required fields are missing: [Last Name]: [Last Name] error

Im trying to create a visualforce page and do some validations on it. If my first name and last name are same then it should throw me an error ..or else it should insert the record.When i tried ...
2
votes
1answer
24 views

Can a validation rule error message resolve to a custom label?

Is there anyway to make the error message of a validation rule resolve to a custom label? The following url indicates that it's not possible, but I just wanted more verification: ...
0
votes
1answer
24 views

Opportunity Conditional Automation

I'm really unsure how to go about the following validation rule based on a certain condition. My issue is, If Sole Proprietor is selected from the Win Reason drop-down, i.e. ISPICKVAL(Win Reason, "No ...
0
votes
1answer
17 views

How to freeze a record once stage value got funded

I have a following validation rule for "need to allow to create opportunities and be able to update opportunities as long as the deal stage is not funded. and do not allow them to change the stage to ...
0
votes
1answer
30 views

how to validate two picklist values are same

I have this validation rule that will prevent two pick list field values from being the same. That means if both fields are empty it is also firing, but that shouldn't happen. And(IF( ( ...
2
votes
2answers
40 views

Priorvalue in Validation rule

Iam trying to simplify my validation rule but i get error. My VR restricts users from role from chaning ownerid for subset of users, since all my users first name is "TBD" i want to simpify the rule ...
0
votes
1answer
22 views

Opportunity Validation

I'm trying to perform some validation on my opportunity page and I'm having difficulties. The following is the scenario.. If stage = close won (100%) or closed lost (0%) AND competitor = not known at ...
1
vote
1answer
53 views

Validation rule for phone number

how to write validation rules for phone number in below format +()- Example : +(91)-1234567890 When end user entering value for phone number it should only allow mentioned special ...
3
votes
1answer
38 views

Why i get “An error occurred when processing your submitted information.” after a standard field validaton?

I have 3 inputfields from Account object in a pageblock table: personemail personbirthdate personmobilephone If i type a misformatted email address (for eg. missing @ sign) or birthdate than i ...
0
votes
1answer
17 views

Help with a junction object

I created a rollup summary on opportunity object to count on object 1. If count > 0 then field1= abc else xyz. I tried the following... created roll up count on object 1 created a formula text on ...
1
vote
1answer
22 views

How do we calculate the average value of a field in a lookup relationship?

We have a lookup relationship between a meter (parent) and an index (child). We would like to calculate the average of all indexes, and then validate if the entered value of the index is not greater ...
2
votes
0answers
25 views

Is it possible for a popup window to appear after a validation rule returns false?

We need a validation rule to check if a entered value is not twice as large as the average of the last three years. If the validation rule returns false, there should be a popup window displaying the ...
2
votes
1answer
23 views

Is it possible to auto-deactivate a validation rule when running test

In our system, we have recently added a validation rule, which works fine with the actual usage but most of our existing test code doesn't comply with that rule when creating test data. Since ...
3
votes
2answers
57 views

validation rule and triggers

I have a field on case linked to an order that is present both in the case object and in the object order. When the case field is true, the order field becomes true in a trigger (after insert or ...
0
votes
0answers
14 views

Retrieve all validation rule from Lead and cases

I am using PartnerWSDL for integrating salesforce with my application. I am facing one problem while creating Lead, as user has created some Validation rules in Lead Record. Lets take an example, User ...
1
vote
0answers
40 views

Validation rule fires - not sure why

I have a validation rule on an accounts' field AND (ISBLANK(Bill_To_Account__c),ISPICKVAL( Owner.UserType ,"PowerPartner")) That checks for the 'Bill_To_account__c' to have a value, if the ...
1
vote
1answer
35 views

bypass validation rule upon merging?

How can we bypass validation rule when using the oob merge process. I can't figure out what field identifier to use as my criteria on validation rule that will tell me that user is processing merge ...
1
vote
1answer
34 views

Validation rule confusion adding OR

I have trouble writing validation rules in Salesforce. So I have a checkbox field BypassWF__c which when checked bypasses workflow. I have three fields AssignedToUser__c, SupportUser1__c and ...
0
votes
0answers
13 views

Integration UPSERT failed by validation rule to access the Custom Setting field

Integration UPSERT failed for the validation Formula XXXX Invalid (Could not access the following field: $Setup.customSettingsObjec.customSettingsField. Contact your administrator) The Custom ...
1
vote
4answers
91 views

Trigger to validate selection of Pick-list values

I got an object called 'Category' which has a master detail relationship with 'Scheme' object, 'category' has a pick list field called 'Type' & it has different values Ex:Cost,Time etc. I need ...
0
votes
2answers
132 views

Regex Validation rule for telephone number

I want to create a validation rule on Phone field(Custom) where system will be allowed to use + or 00 and then 7 to 26 digits(Numeric). Also in between if I enter any space or dash that should not be ...
3
votes
1answer
53 views

Smart Capture Form Field validation on ExactTarget using JavaScript

I have a landing page that contains a Smart Capture form that sends data back to a custom Object in Salesforce. The form is functional and works as needed. I would like to add custom JavaScript code ...
2
votes
1answer
62 views

validation rule to stop delete

I know this sounds a bit strange but I want to stop a deletion call so that I can test an error handler on my visualforce page. How can I go about setting up a validation rule that will stop a delete ...
0
votes
0answers
23 views

How do I add a Vlookup for First Name and Last Name in Contacts

How do I add a Vlookup for First Name and Last Name in Contacts. I referred the documents in StackExchange where they suggested me to use the vlookup in the following way: ...
1
vote
1answer
32 views

Strange behaviour of Regex to allow only alphabets in the name field

I have a validatio rule on contact which gives error when the name field contains non-alphabetic character. Formual for the Vaildation rule is as follows : OR( REGEX( FirstName , "[a-zA-Z]+"), ...
0
votes
4answers
58 views

Validation Rule giving me a huge headache

Basically I need a validation rule to say IF field “HasOptedOutOfEmail” is unchecked, and mailing country = Canada, then field Canada_Email_Consent__c needs to be Updated. However the record ...
2
votes
1answer
73 views

Basic Validation rule which has baffled me

Yet again this has simple validation has me baffled Aim – If mailing country = Canada, then Canada_Email_Consent__c needs to be captured, if mailing country not equal to Canada then ...
0
votes
1answer
38 views

Simple VR has me stumped :( Error: Incorrect number of parameters for function 'ISPICKVAL()'. Expected 2, received 1

This is probably one of the basic questions I will ever ask, but at the moment I am stumped and cant work out how to do it I need a validation rule to look at the field “Canada_Email_Consent__c” if ...
2
votes
1answer
36 views

Date cannot be within x working days of today

I need a validation rule that checks the date of a field is not within 4 working days of today's date. Is it possible to do this, what would the formula look like?
4
votes
2answers
133 views

Excluding certain user from validation rule

I need some quick help. I have created the following validation rule (See below) However I don’t want the validation rule to fire if User id = 00550000000lxVg i think it be something like ...
4
votes
1answer
100 views

PageMessages writing duplicate error message

I have a simple visualforce page like so... <apex:page controller="MerchantDetails"> <apex:form > <apex:pageBlock title="Confirm or solicit the fields below"> ...
3
votes
1answer
26 views

Validation rule help again

Since I have gotten great assistance previously, thought I'd request more assistance with yet another validation rule. I get no syntax errors and the validation rules fires but only when all fields ...
3
votes
1answer
29 views

Assistance with a validation rule

I have a request from one of my business units to require 3 fields have a value when another field has a specific value. IE: When case.Status_Type__c (picklist)= "BR Verified On-Site" then the ...
1
vote
1answer
26 views

Basic Salesforce validation Rule formula

I need to create a validation rule to say if Mailingcountry = canada then field Canada_Email_Consent__c needs to be completed Canada_Email_Consent__c = Picklist Mailingcountry = text
0
votes
1answer
37 views

Validation rule help

I had two objects quote1__c and quote_line_item__c with lookup relationship. I am writing this validation rule at quote line item level Quote_owner__c is formula field which get the ...
2
votes
1answer
28 views

How to understand large validation rules?

For example I have a long validation rule.. AND ( $User.BypassME__c = False, OR ( AND ( $User.ProfileId = '111', NOT( OR( ISPICKVAL(UserType ,"Superman"), ProfileId = '222')).... ...
1
vote
1answer
122 views

Help creating basic validation rule on PickList Value

I need some help creating a basic validation rule Aim – If field name “Client_Business_Type” contains “pension” then field name “Pension_Fund_Type” is mandatory Field Label : Type of money Field ...
1
vote
1answer
28 views

Delete existing Validation Rule from Managed Org while new deployment

While creating a managed package we created 2 validation rules on a object. Now while we are releasing a new managed package we need to remove one of the validation rule. Is their any way to remove it ...
7
votes
1answer
76 views

Disable Validation rule in Salesforce1

Is there a way through which I can disable a validation rule in Salesforce1 (User logging in from iPhone) but it should be activated while user logs in from laptop.
2
votes
1answer
162 views

Custom Settings - Validation Rule

We have a custom setting (AllowableCombinations__c) that has the following fields Queue,Type,Name,Area It has 10 records containing the different allowable combinations of Queue/Type/Area and Sub ...
2
votes
3answers
126 views

Trigger : Need Help for showing a nicer error

I have created a trigger for the following behavior in my Salesforce org: When the user changes the Account Owner, it automatically changes the Contract Owner on the related contracts before update. ...
1
vote
2answers
198 views

Check if string contains specific characters- Validation Rule

I have a field text that cannot contain either l m or p whether it is upper or lower case. How can I accomplish this in a validation rule? Please give examples. Perhaps a regular expression example ...
-2
votes
1answer
52 views

Sending value to salesforce through CURL i got following error.Please guide

Reason: Contract_Number__c duplicates value on record with id: 00QF000000ZgKKC Lead Capture Page: Not available. I received this in an email: Salesforce could not create this lead because of ...
0
votes
0answers
44 views

Validation Rule for picklist field

I am having 2 fields in a custom object. Pricing_Option__c : (pickList) : Values: Show Price, Show 1st Discount, Show 2nd Discount, My_Discount__c : (percent) Here in My_Discount__c I want to ...
1
vote
0answers
30 views

strange behaviour of validationrule on opportunityline in test coverage

Some time back, I asked the following question: different behaviour when adding opportunityline through visual flow? This has always remained a mystery... Now today, I stumbled upon this behavior ...
0
votes
1answer
24 views

UI Validation (Page layouts) with Dreamfactory

Background: We migrated a subset of data & configuration from one org to a new org. Migration involved: 1. Data 2. Meta data We are at the phase of validating the data and UI. When I say UI ...