Questions tagged [validation-rule]
Validation rules verify record data meets the standards you specify before the record can be saved.
677
questions
0
votes
2answers
35 views
REGEX Validation rule for multiple lines of dates
I'm trying to find a regex pattern for a validation rule on an opportunity that will allow dd/mm/yyyy one or more lines in a long text field named Dates_offered__c.
For example, I want to allow:
dd/...
-2
votes
0answers
18 views
Validation rule to only allow core domain, ex: facebook.com [on hold]
I need to write a validation rule that only accepts core domains. I want to open up the ability for our end users to create accounts directly in SFDC but I do not want them to enter bad data.
Accept:...
0
votes
1answer
24 views
Setting Contact mandatory in Cases
Our org Cases in SF, contacts are not set as mandatory. I want to set it to mandatory by using a validation rule to associate with Contacts. But the validation rule will not work, as we have designed ...
0
votes
0answers
19 views
Can I add custom error message on visualforce page instead of standard error message thrown by validation rule at the top of visualforce page?
Controller:
Database.SaveResult[] sr = opportunityhandler.createOpportunity(oppObj);
isErrorOcurred = checkErrorsInResult(sr);
System.debug('isErrorOcurred>>>'+...
0
votes
1answer
44 views
validation rule on when case status is closed then not possible to re-open
my requirement is :
When case status is Approved or Rejected , then not possible to re-open the case and show alert like "Approved / Rejected cases not possible to open...."
How can we acheive through ...
0
votes
0answers
16 views
error with validation rule when making list of past roles
i'm working on making a list of past roles which include a start and end date from when the role was held. however i'm having trouble making it so before adding a new role, the previous role must be ...
3
votes
0answers
25 views
Custom Permission in Validation Rule evaluating as Null when assigned
We have a requirement to prevent changes to a contract record once active unless the you are a contract admin, which can span multiple profiles. I'm trying to accomplish this by using a custom ...
0
votes
1answer
34 views
can too many validation rules cause a performance issue with large data - Apex CPU Time?
I have a bulk update process which effects updates records in more than one salesforce objects like - Account, Contact, Contract , Opportunity and Oppt Line Item.
This bulk process does not update ...
0
votes
1answer
22 views
How to display validation rule error message for opportunity multi line layout?
I am have requirement to display error message while adding opportunity products in multi line layout. i have created validation rule with respect to condition on custom fields which are added to ...
1
vote
1answer
30 views
My Validation Rule isn't working properly
I have a custom object that track several products, but none are required to be filled out. However, if there is a product, I want to make sure my users are inputting all the necessary information. So ...
0
votes
2answers
50 views
Validation Rule on Lead Conversion
I have a validation rule on Opportunity that I want to fire only when a new opportunity is created without Lead Convert process.
It should not fire when an opportunity is created using Lead conversion....
0
votes
1answer
29 views
Validation Rule - Picklist being ignored
I am trying to create a validation rule that has multiple sets of criteria, one of them being preventing the LeadSource picklist field from being blank. Below is my formula which for some reason ...
0
votes
2answers
29 views
Validation Rule-If Active checkbox in unchecked, then Reason for cancellation is mandatory Applicable only to record type End Client
This is the Validation for Account Object -Person Account
If Active checkbox in unchecked, then Reason for cancellation is mandatory
Applicable only to record type End Client
And I have written the ...
-3
votes
1answer
28 views
Write a Validation Rule [closed]
In lead object Feilds called Industry,So seleted Industry Feild On Banking Then get error How to do this through Validation Rule
0
votes
1answer
24 views
Validation Rule for Phone with Extension
I'm trying to write a validation rule for phone numbers with extensions. I want to be sure there are exactly 10 integers to the left of the letter "x". It needs to ignore special characters and only ...
0
votes
1answer
26 views
Encrypted Text Field - Validation Rules - multiple Rules
I am using a encrypted Text Field.
List of rules needed:
Must be able to save a record if value is blank
OR
Must be Numbers
Minimum of 10 Digits
Max of 12 - (implemented with length setting)
...
2
votes
2answers
47 views
FIELD_CUSTOM_VALIDATION_EXCEPTION even when all validation rules are deactivated
I have a difficult troubleshooting situation involving a new accounting managed package, a complex flow, a mysterious validation error, and unit tests.
I had built a custom REST API before the ...
1
vote
1answer
22 views
Help with Validation Rule on Contact
I want to Create a validation rule on contact object so that if the user profile = Services User, the Contact Name field is not editable.
Solution :
AND(ISCHANGED(FirstName),
ISCHANGED(LastName)...
0
votes
1answer
19 views
How can I prevent users from updating the status to anything but closed?
I am trying to prevent a customer from updating the status of a case to anything other than closed with a validation rule. What I have works when I update the status, but also for closed. Here is ...
1
vote
1answer
43 views
What is the validation rule for a text field that shouldn't contain data if the correct picklist value has been selected first?
I created this Validation Rule that when a user selects Yes from the, Any_other_liens_filed_against_you__c picklist but tries to save the record without completing the text field, "...
0
votes
1answer
98 views
Use Picklists in Formulas - Admin Advanced Trailhead Module
Can someone help me with this error?
There was an unexpected error in your org which is preventing this assessment check from completing: System.DmlException: Insert failed.
First exception on ...
0
votes
1answer
30 views
City Validation rule
I am trying to put a validation rule in place: If City is Mumbai it should not be allowed to change it to another, whereas if City is not equal to Mumbai it can be changed to anything but not Mumbai. ...
0
votes
1answer
39 views
REGEX in Validation Rule
I have a custom field on an object which should allow values based on the following JavaScript REGEX.
/[^\sa-zA-Z0-9.,:?;%/()'!""-]/g
Can anyone help me how to use this REGEX in validation rule ?
0
votes
1answer
28 views
Validation rule that allow only number along with a specific string
I want a validation rule that should allow only number (0-9) and a specific string ('N/A') which contains a special character also.
NOT(REGEX(Code__c, "[0-9,;N/A]*"))
The above validation rule is ...
0
votes
1answer
49 views
Validation Rule - ISBLANK() not working as expected
On the Lead object, I am trying to validate that my custom "Zip_Code__c" field and the standard "Email" field contain a value in this validation rule, but despite the validation rule being active, it'...
1
vote
0answers
17 views
Validation rule error triggers page to switch from Lightning to Classic
I've created validation rules to dissallow users to change a 'status' field until certain fields are populated. This issue occurs when a user tries to change the 'status' without populating necessary ...
0
votes
0answers
52 views
Restricting picklist values on Opportunity, when field is a formula text
I have a situation not sure how to solve.
Trying to make a pick list field with 4 choices for all users except Administrator and 2 specific users. There will be 15 other choices for Administrator ...
0
votes
0answers
16 views
Custom validation rule of lookup field is being called from Aura component of custom object
I have a custom Object which has look up relation with Account. I have made a custom lightning component on custom object as quick action in which user selects the lookup field for account and save a ...
1
vote
2answers
44 views
How do we handle existing bad data on restricted picklist value
I have a bunch of existing values for picklist and now we want to make the picklist as restricted picklist. Some of the records may contain values which are not in the restricted picklist.
I ...
0
votes
1answer
32 views
Error: Incorrect number of parameters for function 'IF()'. Expected 3, received 4
I keep getting Error:
Incorrect number of parameters for function 'IF()'. Expected 3,
received 4
Can anyone advise on where its pulling the 4?
IF ( $UserRole.Name = "x",
IF( AND (Quantity >...
0
votes
1answer
24 views
Lock Record with Exception of enumerated fields
I have a case where we want Closed Opportunities to be read only for a certain profile, with the exception of two fields, Opportunity Owner and a custom field we have (then I also assume I would need ...
2
votes
3answers
179 views
Validation rule to allow number, decimal and percentage
I am trying to write a validation rule which will allow only numbers, decimal and % symbol.
Below are the samples i am trying but it is not working. If I put 17.5% it is not working
Any number upto ...
0
votes
1answer
33 views
Validation Rule (Multipicklist field)
Field 1 is Multi picklist field and Field 2 is a text field.
Trying to create a validation rule if Field 1 is not blank and Field 2 is blank, an error message should appear. Similarly when Field 2 is ...
1
vote
1answer
63 views
Validation Rule Error when converting a lead
I have two picklist fields with dependencies in place. One is Lead Status and One is Status Subcategory. I have a VR so that forces the user to complete the Status Subcategory if the lead status is ...
0
votes
1answer
45 views
Validation Rule to fire only when updating field Manually
I am trying to create Validation that fire only when someone try to update record manually but it should not get fire if changes due to Process/Apex/Flow
Any suggestion ?
Validation Rule :
AND(...
1
vote
1answer
45 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
28 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
31 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
25 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
66 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
31 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
20 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
61 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
38 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
29 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
67 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
2answers
172 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
17 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
76 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
100 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(...
