Tagged Questions

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

learn more… | top users | synonyms

1
vote
1answer
25 views

Java Code to check validity (expiration) of access token using rest api

I am using username/password flow . I am getting access token . But when will that access token expires, so that I can request for new access token. i don't want to get access token with each request ...
3
votes
3answers
60 views

The input text <apex:inputtext> in a repeat (for loop) doesn't work with the validation required field

I have a custom object Team member contains four text fields First Name , Surname, location and job title and First Name and Surname is a required fields (When i create them i make them required). ...
2
votes
2answers
40 views

Three tier Validation Rule / Validation chain?

I am stumped so I hope I can present my question in a manner that allows me to get some support. I am creating a Lead validation rule that in essence is 3 tiers i.e. if tier 1 is selected require ...
4
votes
1answer
45 views

Regex to validate Credit Card numbers

I have created a validation rule on a Log Text field, to check for Credit Card number for all major companies "(VISA, Master Card, Discover and Amex for now). Here is the validation rule: NOT( ...
3
votes
2answers
120 views

How to make a field editable only if a checkbox is checked

I have a text field that is set to un-editable for all profiles. However if another field (checkbox) is checked, then this text field should become editable and required. I have created a validation ...
2
votes
1answer
39 views

Validation Rule on Lookup Field

I'm trying to validate a Lookup field so that the CONTACT I add to the field has the same CONTACT.ACCOUNT.CUSTOMID as the ACCOUNT governing the record I'm adding the CONTACT to. To be more specific, ...
0
votes
2answers
25 views

Can I write a validation rule to make a field enabled or disabled based on picklist value?

Note: in standard page layout is it possible to write a validation rule to make a field enabled or disabled based on picklist value? i have a picklist - values cycle - monthly ...
2
votes
0answers
37 views

Why does ApexPages.getMessages() return multiple Message objects for field validation errors?

I'm using a standard controller with a command button that saves a record. When one of the fields is invalid, the ApexPages.getMessages() function returns multiple messages like this: 19:36:58:445 ...
1
vote
0answers
32 views

There were custom validation error(s) encountered [Mailing Longitude]"

There were custom validation error(s) encountered while saving the affected record(s). The first validation error encountered was "Required fields are missing: [Mailing Longitude]". this just started ...
1
vote
1answer
45 views

Date Validation in Apex programming

I need to check that the user has given a valid date in a text box. For example if user enters 2014-02-29 it should throw an error saying it is not a valid date. I can use Date datatype but my ...
1
vote
1answer
60 views

Required field validation rule for [Billing|Shipping]StateCode with State & Country picklists enabled?

When using State & Country picklist functionality, is it possible to write a Validation Rule that targets the Billing State or Shipping State fields to make them required but only when the Country ...
1
vote
1answer
41 views

Lead cannot be converted if owner is Queue

I have validation rule where lead cannot be converted if owner is Queue, i tried different sets of validation rules but none of them works, any help is appreciated 1) AND( IsConverted = TRUE, ...
1
vote
3answers
128 views

You have reached the maximum number of 10 object references on Case

While creating a validation rule the have got this error(You have reached the maximum number of 10 object references on Case), can i have a trigger used instead.
1
vote
1answer
70 views

Validation for inputFields inside Pageblock table is not working

I am trying to do a simple validation, if qty received ENTERED is different than qty ordered, a JQuery dialog box should open. For some reason this validation is working only for the first ...
1
vote
3answers
84 views

Formula field for the Difference between 2 time values in picklists

I am very new to Salesforce and have to write a formula field based validation. I have been trying but so far haven't been able to write a correct formula. My requirement is as follows: I have 2 ...
3
votes
2answers
71 views

testing if something is null in visualforce, NOT(ISNULL())) vs. != null

Is there a difference between the two statements? {!NOT(ISNULL(variable))} and {!variable != null} What is the appropriate way to check if something is null? EDIT: What if it's a SF checkbox? ...
1
vote
4answers
77 views

Basic Validation Rule not working

I want to create a validation rule where only users with the role “UK: Institutional Team” are able to create cases record type called “Benchmark Change”. My Validation rule is; AND( ISNEW(), ...
0
votes
1answer
34 views

Validation Rule: Voiding Order

Kindly help me construct my validation rule here AND( ISCHANGED(Status__c), OR( NOT(ISPICKVAL(PRIORVALUE(Status__c),"Draft")), ISPICKVAL(Status__c,"Void") )) Description of ...
1
vote
1answer
47 views

Opportunity Validation to exclude certain Profile types

Unfortunately, I'm not able to use simple Validation Rules to do my conditional statement validation. Instead I have to use a trigger to do so. That being said, currently, I'm trying to only run this ...
0
votes
4answers
203 views

how to show the validation error below the input field in VF page

I have used the following code for the email validation and the validation is working fine but I would like to show the error like the the image. how to do that? My Code: <apex:pageBlock ...
1
vote
1answer
30 views

Validation rule assistance

I'm looking for input on how to adjust an existing, working validation rule so that it doesn't fire when the running user is a specific Profile. Here is the existing rule: AND( ...
3
votes
2answers
119 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
46 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
34 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
36 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
142 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
69 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
28 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
3answers
44 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
45 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
84 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
29 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
256 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
103 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 ...
1
vote
1answer
34 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
50 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
42 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
79 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
21 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
86 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
63 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
85 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
18 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
285 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
927 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
104 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
241 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
27 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
51 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]+"), ...