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.

1
vote
1answer
28 views

Validation rule on lead conversion. preventing specific users ownership of records

I'm trying to prevent a specific user from owning Opportunity/account/contact records upon reassignment on lead conversion. Here is what i got so far and I cant seem to get it to work... Any kind of ...
-3
votes
1answer
27 views

Syntax Error - Missing ')'

I am user69787. I can't seem to register that account. Thank you @PartOfTheOhana. I am now getting syntax error. Missing ')' OR( AND( ISCHANGED(OwnerId), OR( $...
1
vote
0answers
16 views

Lightning modal - Scroll to top of page when there is a validation rule error

I am making a component that has a similar functionality like the standard lightning component. I am using modal mode and normal mode based on a value provider. I want when there is a validation error,...
0
votes
1answer
20 views

Verify input origin of a sObject field

I have a field that is filled by file import, so I need to check if this field was fill by hand or imported. Is there any way to implement a validation rule with a condition that verifies whether or ...
0
votes
1answer
21 views

validation rule for sum of percentage field should not be more than 100%

HI I am looking validation rule and am not sure whether can be done with validation rule. I have a task where I will mention an account executive and assign quota and revenue % for that account ...
1
vote
0answers
22 views

ISCHANGED always return TRUE on RichTextArea

I have a validation rule that should prevent changing of Rich Text Area field after creation. In order achieve this I created a validation rule that use ISCHANGED(RickTextArea__c) formula, but it ...
0
votes
1answer
19 views

Validation Rule- Field update for 2 profiles

I'm trying to have a validation rule to allow 2 profiles to update a date field. it throws an error each time saying the user cannot update the field. AND( NOT( ISBLANK( PRIORVALUE(...
2
votes
1answer
40 views

Regex - Syntax error

This is my regex (for international phone number), i have the message "Syntax Error" with this part of regex highlighted : s*[)]?[-\s.]?[(]?[0-9]{1,3}[)]?([-\s.]?[0-9]{3})([-\s.]?[0-9]{3,4})') ...
0
votes
0answers
10 views

Help in Permission Set in Validation Rule

I have this below scenario - I have a Custom Object - CustomObject__c , which has a picklist Status__c. Status__c field has values as New Approved Rejected Hold I have two permission set - ...
0
votes
2answers
24 views

Validation rule to prevent entering same data on

We have child object "Auto" on Account object.There is a text field Auto Number on Auto object. We need to prevent reps from entering same number for this field for different records for same account....
4
votes
1answer
44 views

REGEX Validation Rule for Phone Number [closed]

I am trying to create a validation rule for phone number and using the following regex Validation : NOT(REGEX( Phone, "^(?=.*?[1-9])[0-9()/\\-\\+\\s\\.\\ ]+$")) The above regex is working fine if ...
1
vote
1answer
33 views

Validation Rule on Conga Composer Button

I have a button as per below, that will generate a document for the client when clicked. However, I want to ensure this only fires when a field Job_Number__c has been filled out. And if the field is ...
1
vote
1answer
13 views

Assign leads per slot time

can validation do this ? Max 10 leads on Slot time per branch.. For example only 10 leads must be in 10:00am(Slot Time) per Iron Man(Machine).. Or apex/triggers will the job
0
votes
1answer
27 views

How to bypass out of box and custom validation rules when Close Opportunity Request is automated

Earlier we used to close the Opportunity manually but before closing it there are some validation rules and apex validation rules gets triggered. Now with the help of apex, I have automated ...
2
votes
1answer
90 views

Validation rule Scheduled Apex

I have a scheduled apex job which updates a field which is controlled by a validation rule as follows: AND( Not(ISNEW()), $Profile.Name != "System Administrator", ISCHANGED(...
0
votes
1answer
38 views

Incorporate Record type name on validation rule formula

I am trying to create a formula that restricts multiple checkboxes from being ticked. User should only be able to tick one checkbox per record. I've managed to create the formula that handles this ...
0
votes
1answer
16 views

Created Validation rule to ensure product has been added before a certain stage, but can't add products

Created Validation rule (below) to ensure product(s) has been added before a certain stage, but can't add products to an already created opportunity that is beyond that stage. When I go to add a ...
-2
votes
1answer
24 views

Validation Rule not working properly as per the Requirement

Need a small help, i am trying to create a validation rule on a lead object - the requirement is whenever the lead status is converted to "Closed - Not Converted" it should throw an error on ...
0
votes
1answer
30 views

Can we delete Validation Rule through apex code?

I have got a User Story to delete all the Inactive Validation rules in Salesforce. Instead of doing it manually I am finding another way(through Apex Code) to do it.
0
votes
1answer
36 views

Validation rule triggered even with wrong status

When the status is "Completed" or "Complete" no one should be able to edit a record. I wrote the following validation rule: AND(OR( AND( NOT(ISCHANGED(Status)), OR( ISPICKVAL(Status, 'Complete'), ...
0
votes
1answer
17 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 <...
-2
votes
2answers
30 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
40 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
17 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
35 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
23 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
59 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
36 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
44 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
15 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
85 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
24 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
48 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
184 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
55 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
23 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
37 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
58 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
83 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
40 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
195 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
122 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
38 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
54 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
41 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
37 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 ...