Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [validation-rule]

Validation rules verify record data meets the standards you specify before the record can be saved.

0
votes
1answer
24 views

Validation rule triggered even with wrong status

When the status is "Completed" or " Complete" No one should able to edit a record. I written the following validation rule: AND(OR( AND( NOT(ISCHANGED(Status)), OR( ISPICKVAL(Status, 'Complete'), ...
0
votes
0answers
10 views

Date validation on Web case form [closed]

I have date fields on a web form and need a rule that won't allow Date 2 to be earlier than Date 1. I'm a complete code novice; I've found some pages online that I have copied/amended but it doesn't ...
0
votes
1answer
12 views

Prevent new activity being logged against inactive accounts

Our accounts have inactive checkbox. When this is checked users should not be able to create new tasks/events I tried validation rules like: (on both task and events) AND( ISNEW(), $Profile.Name <...
0
votes
1answer
29 views

Validation rule on activity what Id created date [closed]

I have to write a validation on Task that user can not create task if Account(what id) of that task is created before 7 days. Please help me to write the Validation rule on created date of whatId. ...
-2
votes
2answers
29 views

Validation rule for text field - It should accept only numeric value and accepts only 12 or 13 digits [closed]

Note : We can't change the field type to number because it is existing field.
0
votes
2answers
37 views

validation rule for text field to be changed

Validation rule for Text field - It should be not blank OR if any value already in text field then it should be changed. Based on two conditions: Picklist value should be Rejected RecordType....
0
votes
1answer
16 views

Validation rule that limits what products to add to opportunity by oppRecordId not showing error

I have a validation rule on the Opportunity Product object...it's the only one that i could reference the Opportunity object and the Product 2 object. AND(Opportunity.RecordType.Name = "Happy Fun ...
2
votes
2answers
27 views

How to prevent manually changes of Status field for Cases and Opportunities?

The Status field of Case and Opportunity objects cannot be read only for any profile. How could I prevent the manual changes only? I've tried with a validation rule that allows a free choice when ...
0
votes
1answer
21 views

New validation rule not working fully

i have created a new validation rule which should prevent saves to a dunning action record if the type is email and either email body OR email subject is null. Currently i have: AND( ISPICKVAL(...
0
votes
0answers
21 views

issue in Validation rule firing

I have a one validation rule which is checking if phone length is 10 and start not with 03 then thrown an error I have also written a code in before trigger which is updating 0 to +91 I have a issue ...
0
votes
1answer
24 views

How do I use standard object Validation Rules in a Lightning Component?

I'm still learning how to use Lightning Components and would appreciate help. I have several Validation Rules on a child object. There is an action on the parent object which uses a Lightning ...
0
votes
1answer
30 views

Error while adding validation rule on status field on close case page

I am writing a validation rule to add a error message on case close page, if user trying to change the case status to resolved for the already resolved cases then it should through an error stating ...
0
votes
1answer
41 views

Help needed with creating a New formula field

I am having an issue with a validation on a field in my Case object.I have the below requirement.Can somebody help? The Field should allow only a total 11 digits. These 11 digits can be divided into ...
1
vote
0answers
14 views

Can some explain below formula of excluding weekends counting

Can some explain below formula of excluding weekends counting, I want the explanation I'm not able to understand the below formula. The formula is : CASE(MOD( ActivityDate - DATE(1985,6,24),7), ...
1
vote
3answers
37 views

validation rule to prevent user changing ownership

I'm trying to create a validation rule to prevent 'portal' profile users to change ownership of lead record but they should be able to accept leads from 3 particular queues. OR( AND(ISCHANGED( ...
0
votes
2answers
18 views

validation rule issue its not working as expected

Below is the validation rule (TEXT(Full_Care_Confirmed__c)) == 'Yes' && ( ((ISPICKVAL(CPQ_Order_Type__c,'Corporate-Full Care Equipment Domestic')) || ISPICKVAL(CPQ_Order_Type__c,'Corporate-...
0
votes
0answers
25 views

Using Custom Permissions to restrict picklist values to specific users

My goal: Using Validation Rules and Custom Permissions to restrict accessibility of specific values seen in the Account Type picklist to be available only to specific users. I have the custom ...
2
votes
2answers
60 views

Create a validation rule to check that a contact is in the zip code of its account

I think i misunderstood validation rules, so i answered the following challenge creating a validation rule that only applies if the insertion is different for what i write in the rule: AND(ISBLANK( ...
0
votes
0answers
13 views

Querying contact account for customer portal user in validation rule

I want to query user.Contact.Account.Name (which is possible in apex) in validation rule. How to achieve this.
0
votes
2answers
45 views

Opportunity product field permissions

I'm looking to give specific user access to edit single custom field on 'Opportunity Product'. This user should not have the ability to edit any 'Opportunity' field. I created ‘Opportunity Product’ ...
0
votes
1answer
19 views

Validation rule for non testing context

In Apex to separate code execution for test and non-test context we use the following method Test.isRunningTest() Do we have any such thing for validation rules i.e the validation rule should be ...
0
votes
1answer
36 views

Dont want to associated contact to other objects if status is pending

i want a rule where i dont want to associated contact to other objects if contact status is pending.I am not sure how can i achieve this .any suggestion
0
votes
2answers
51 views

Validation Rule to check PRIORVALUE

I am writing one validation rule where status is Pending/In Progress and I am changing any value from record then I need to throw an error 'you cannot edit the record'. AND(OR( ISPICKVAL( Status , '...
1
vote
2answers
58 views

how to make phone field unique

i want to make phone field unique for this i have tried triggers but i want to write validation rule for this i have written something like AND( CONTAINS( VLOOKUP( $ObjectType....
0
votes
0answers
19 views

Validation rule should allow process builder to change the picklist value but should give error when done manually

I am trying to figure out how to restrict users except admin from changing one of the picklist values. e.g Users should be able to change Stage 1 to Stage 2 but not from Stage 2 to Stage 3 as that ...
0
votes
2answers
32 views

Identify existing records which fail a new validation rule

After adding a new validation rule, existing records may be 'invalid'. This causes issues for me because processes and batches will fail to update those records. How can I identify which records are ...
0
votes
2answers
97 views

Validation Rule for multiselect picklist to prevent duplicate values

I have a multiselect picklist with ten values. One of these values cannot be chosen more than once on a record.. For example, multi_sel_picklist__c = "Aa" can only occur once on a record, with no ...
0
votes
2answers
62 views

Validation Rule text field required when multi-picklist value is selected

I'm trying to have a text field required when a value is selected in Multi-picklist field IF( AND(TEXT(Environment_Access__c ) = "DevQA", ISBLANK( Business_Justification__c )), True,...
0
votes
0answers
26 views

Validation rule on Account Contact Relationship object

Can anyone please let me know how to write a validation rule on Account Contact Relationship object to hold only one primary role, contact to an Account
0
votes
2answers
52 views

Eliminate consecutive two dots

How to eliminate consecutive two dots in validation rule and 1st char should not be . [dot] example: sal..esforce - invalid sal.esforce - valid .salesforce - invalid salesforce. - valid ...
0
votes
2answers
39 views

validation on lookup object

I have lookup on account of Sell_Request__c object. I want validation on Sell_Request__c to check if account-status is Inprogress then thrown an error.but i am not able to achieve this as not able to ...
0
votes
0answers
21 views

Ability to show validation rule errors next to Stage on VF page when restricting some stage values using selectoption

Here's my vf page: <apex:column headerValue="Stage" id="stageerrors"> <apex:actionRegion > <apex:selectList value="{!opp.opp.StageName}" multiselect="false" size="1" > <apex:...
-2
votes
1answer
35 views

Validation Rule For Salesforce

I have req as follows :' There are Two Object Account and Job , Account is having a field Public Logo(Url) and Job is having a field known as Client Logo flag(checkbox). Client Logo flag can't be set ...
0
votes
2answers
39 views

Looking to prevent users from changing lead status manually as a process builder is already in place

I am looking to stop users from manually changing the lead status to both "working-attempted" and "working-contacted" as we currently have a process builder in place that automates this based on ...
0
votes
1answer
26 views

Account Validation Rule

Why is this validation rule stopping me from editing a new account that I just created 5 minutes ago? It's designed so that only XYorZ profile can create an account which works, but it wont let those ...
2
votes
3answers
126 views

Validation Rule Assist: Lock down multiple lead fields after they are first populated

I am trying to create a validation rule to lock down our original utm fields on leads after they are first populated. Essentially I would like to prevent everyone (including our marketo sync user) ...
5
votes
0answers
33 views

Why does assigning a role from the role hierarchy page bypass validation rules? [duplicate]

I set up a validation rule that prevents our delegated admin users from creating/updating a user to not have a role. The validation rule works exactly as expected when creating/updating the user ...
0
votes
1answer
29 views

Field to pick-list selection

Hi I need a favor regarding pick-list selection. for example: I have a Location object. In Location object I have (County name) field. I created county 1, county 2, county 3. And I have another ...
1
vote
1answer
324 views

Check if string contains a number or a special character

Regex newbie here, I'm trying to create a validation rule which will restrict users from entering a number or a special characters to a certain field. This is what I have so far: !IsNew() && ...
1
vote
1answer
42 views

VALIDATION RULE not throwing error

I am trying to throw an error, when the first name, city, street is not entred for the record type selected ie: can be prospect or member. But when trying to save the member it does not throw the ...
0
votes
1answer
27 views

Validation rule to prevent all other users from changing lead status when lead is “New”

I am trying to create a validation rule to prevent users that aren't associated with the user Id profiles from changing a "New" Lead Status to any other status When I check the syntax for the below, ...
0
votes
1answer
34 views

How to create a validation rule to deny all users creating new records except one

I have a roll-up summary filed which is calculating the number of child records. If the number of child records is greater than 2 I need to deny all users from creating new records except one. I ...
0
votes
1answer
124 views

Validation rule get all picklist values

How can I get all picklist values in a validation rule? I'm looking for a suitable function but I cannot find any. What I need to achieve is that some string is among the picklist values. Please ...
0
votes
2answers
22 views

RIGHT function to get the last three characters

I'm using the following formula in a validation rule: IF(ISPICKVAL(Level_Name__c ,"Level"), IF(CONTAINS(Name,"ONE")|| CONTAINS(Name,"TWO") ,TRUE, FALSE), FALSE) How can I get the last three ...
1
vote
1answer
31 views

I want to create a validation rule which will throw an error if account created date is less than 6 months and type='Active'

i have used below validation rule ,but the issue is, it will check exact 180 days.there might be chances that there are 31 days in month and then days will be more than 180 days.Please suggest how can ...
0
votes
1answer
83 views

Forcing validation rules to work a lead is converted

I have four custom fields in a lead that are mandatory when creating an opportunity. I have validation set up that if you try to create an opportunity it blocks you from saving if you have not filled ...
0
votes
1answer
22 views

How to compare two value in contains function :validation rule

I have two value : Means of transport API ( Name) Description (Description_c) Now i want whenever a new record created : 1. Value should not be null. 2. Description contain means of transport value....
0
votes
1answer
37 views

Need to restrict the multiselect picklist

I have AccountContactRelation and role is the multiselect picklist field. Based on Type i need to show or allow users to select picklist values. EX: Role values:-P1,P2,P3,P4,P5 If type="Active" User ...
0
votes
1answer
15 views

Error message not displaying in validation rule

I created a validation rule on Date field in which I want today date or future date only and also it should not blank. This is my code: AND( BFL_Date__c >= TODAY(), ISBLANK( BFL_Date__c ) ) I ...
0
votes
1answer
157 views

Validation rule for date is greater than?

Hi I am making a validation rule to check if a billing date end is earlier than the billing date start. My syntax appears to be wrong however. My current validation formula: DATEVALUE(...