Requirement is to prevent saving of a record if a File (in this case, a quote) is not attached. Is this accomplishable declaratively? Answer In the most general reading of the question? It’s not possible at all. You can’t attach a file to a record prior to its being saved, because there’s no record for … Read more
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, False ) Answer First of all, you can always replace IF(condition, true, false) with just condition. Second, you need to use INCLUDES rather than TEXT. AND( INCLUDES(Multi_Picklist__c, “SingleOption”), ISBLANK(Other_Field__c) ) … Read more
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 , ‘Pending’), ISPICKVAL( Status , ‘InProgress’)) The issue here it’s not allow me to set status Pending at all..then i Added … Read more
I have validation rule on Account, there is a picklist channel.If the the picklist channel equals to Direct then no role can edit or create the Account record except the owner ‘sales executive’ role.i tried different sets of validation rules but none of them works, any help is appreciated. AND( OR( ISNEW(), ISCHANGED( OwnerId ) … Read more
I need to put a validation on lightning input field date. It is a date of birth field and it should not accept date beyond system.today(). Basically the validation will be date_Of_birth > Today() , then there should an error message. The error message should display beside the lightning input field. Is it possible? can … Read more
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 product the validation rule triggers and brings me back to the opportunity, essentially locking that opportunity. How do I fix it … Read more
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 functionality but I cannot seem to figure out how to add a specific record type for it. Here’s what I’ve Got … Read more
does anybody know if salesforce eventlogs picks up logs for whenever a user adds and new field or makes changes to a field on application? Would this show in transaction logs? Here’s an example: Bob creates a new input field for his salesforce app, later on he decides to change that field, or even change … Read more
I need a data validation formula to say, if status is “Registered” and ID is 6 characters long, the last character of the ID must be a letter. I have managed to get this far but come to a brick wall; AND( ISPICKVAL( Referral_Status__c , ‘Registered’), LEN( Name ) = 6, Answer I believe you … Read more
I am trying to create a validation rule which checks whether Field A OR Field B or no field is filled in. Basically, we want to disallow that both fields are filled in at the same time. I have created the below validation rule, but it gives me an error when I try to leave … Read more