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

learn more… | top users | synonyms

2
votes
1answer
19 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
48 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
10 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
31 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
24 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
24 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
10 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
51 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
53 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
37 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
35 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
17 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
27 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
56 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
66 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
31 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
25 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
112 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
77 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
23 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
25 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
22 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
23 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')).... ...
0
votes
1answer
68 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
21 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
71 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
101 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
96 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
120 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
42 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
38 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
28 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
20 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 ...
0
votes
1answer
383 views

Jquery Validation in Visualforce Page

I need to validate the Account.Unit__c field using some jquery dialog box.But I am having difficulty in getting visual force component Id in jquery. Update I followed Keith C recommendation and ...
2
votes
0answers
79 views

<script> tag generated by salesforce after </html> tag

I am building a website using templates and apex pages. In my apex page I have the option applybodytag and applyhtmltag set to false and I use the <head> and <body> tags in my template ...
0
votes
2answers
66 views

Validate Visual Work-Flow to ensure at least one field is selected

I have a Visual Work-Flow that has a 10 checkbox fields on page. I wish to insert validation so that the user cannot get through to the next page without selecting at least one checkbox to True. Can ...
0
votes
0answers
145 views

org.apache.axis2.AxisFault: Transport error: 411 Error: Length Required (CloudConnect Salesforce sample ETL SOQL validation error)

SOQLvalidation threw validation error in CloudConnect (Clover ETL) Salesforce sample ETL. org.apache.axis2.AxisFault: Transport error: 411 Error: Length Required Data retrieve target Salesforce ...
1
vote
1answer
101 views

How to prevent duplicate user assignment to various record of same custom object

I am having one custom object name as club with custom lookup field with contact object. Let us assume we have 3 records in my club object(club1,club2 and club3). When I assigned one member to club1 ...
1
vote
1answer
65 views

How to avoid Parent Validation Rule Triggered by Child Record CRUD - RSF

I've got a validation rule on few fields on Account. I already escaped few roll-up summary fields by using not(ischanged(field__c)), but team just noticed that attaching record will trigger the ...
0
votes
1answer
22 views

Recurrence tick box in formulas for Activities

I'm trying to write a validation rule for Activities the will use the output result on the "Recurrence" tick box, "Create Recurring Series of Tasks", to give an error on the Status field. Some thing ...
1
vote
1answer
30 views

Validation Rule not displaying under the field definition

When I check the validation rules related to an opportunity, I see that a field is referenced in the validation rule, when I go to the actual field the validation rule section displays nothing. Is ...
3
votes
3answers
241 views

Make visualforce fields required without setting them from the object page

I have an <apex:form> which has search action and upsert action, the thing is that I want the fields inside this form to be required just when I click on insert button. I tried to make these ...
2
votes
3answers
107 views

Validation rule for data dependency

I'm new to coding in Salesforce and I'm trying to code the following logic: If a certain picklist value is chosen, another certain field cannot be left blank. I wrote the following but I'm not sure ...
1
vote
4answers
314 views

Validation rule on 2 picklist fields

I'm trying to create a validation rule formula in Salesforce, that uses two picklist fields. If the first has any value selected, the Second picklist can NOT have any value selected. So basically if ...
1
vote
2answers
71 views

How Salesforce Performance varies when Multiple Validation Rules Triggers for Bulk Records

We are Implementing Data Validation Process for our Organization for which we are thinking to implement following techniques: Apply validation rules for every object in order to maintain Data ...
1
vote
2answers
32 views

Why doesn't the SOAP update call return more than one validation error?

I am sending an update request (SOAP) using the Partner API. The update request is setting two fields to values that should trigger three different validation errors. When I set these values in the ...
0
votes
3answers
129 views

Validation using two Picklist Fields in 2 objects

I'm trying to create a validation rule formula in Salesforce, that uses two picklist fields which have the same values : p1, p2, p3. One of the picklists is on the account object and the other one on ...
0
votes
1answer
72 views

Cross object dependant picklist validation [duplicate]

Hi i am having a two picklist in salesforce one is on account object and one is on contact object. If i am having a1,a2,a3 as picklist values in both. if i select a value in contact is a1 and in ...
1
vote
1answer
42 views

Why would an UPSERT to QuoteLineItem fire validation rule configured for Opp Products?

I am upserting a group of items into QuoteLineItem, but for some reason, an Opportunity Product Validation Rule is failing (Opp not Quote). The custom field being validated exists in both objects ...