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 ...
