My requirement is to only allow users with the profile of "Freelance Writer" to change the value of the Status__c picklist if the current value of Status__c is "Assigned", "Sent For Revisions by Editor", or "Sent for Revision by Client". Here is what I have so far:

I need to create a "Client Due Date" field. This formula should be based off (the Submission date field) Submission_Date__c PLUS a number that is selected from the picklist value from the Processing Days (Processing_Days__c) field which includes the values: 8.9,10,11,12,13,14,15

This exception usually happens when a batch is being run or alerts are coming into our Salesforce instance too quickly. When inserting a case, we try to lock down the contact and account associated with the case before inserting the case to prevent the 'UNABLE_TO_LOCK_ROW' exception from happening.

Here is the exact exception:'System.QueryException: Record Currently Unavailable: The record you are attempting to edit, or one of its related records, is currently being modified by another user. Please try again.'Class.Utility.DoCaseInsertion: line 98, column 1

I've done a lot of research on the 'UNABLE_TO_LOCK_ROW' exception and 'Record Currently Unavailable' exception and I can't seem to find a great solution to this issue.

What I've tried to accomplish is a loop to attempt the insert 10 times, but I'm still getting the 'Record Currently Unavailable' exception. Does anyone else have a suggestion for this?

I need to create a validation rule for a object , The validation rule should check if the filled text field value contain the value that is valid for a picklist already present . ie : there are two fields ,one text field t1 and picklist p1 with values (v1,v2,v3) at object level . I want to verify if user entered data on text field t1 as one among the value present in picklist p1. Let me know if this can be done through validation rule itself ? I know it is possible through apex code , but my current requirement is to do it through validation rule. Please do share your knowledge

I am trying to get a Status field to update when two other fields equal. I am not getting any errors with my code, however it does not seem to be working properly. Please take a look and let me know your thoughts!Thank you,

Hi there, is it possoble to update the Account Type after an Email Message is sent ? It tried the process builder, but it did not work. The Email is related to the Account. Thanks for your help guys ! ;)

I'hv a basic question on Updating fileds using APEX Code - rather I want to clear my concepts . The requirement is very simple. For Account Object , Update all Countries to United States of America where country is like US or USA . Now, I'm able to do it by writing below code

First of all, I am just the administrator, not a developer and not a coder. However today I am wearing all the hats. I am hoping someone would be kind enough to help me with the following. I am not sure of even where to start, except that I should do this by a trigger. However I know nothing of how to actually accomplish this. I am hoping that someone could provide the code necessary as I am not savvy enough to write any of it myself. Being a non-profit, we do not have the budget to enlist a professional for this and the task has fallen to me to handle.

Short story - Due to a third party integration, we found that we needed an email address on the account page. However, with the one-to-one model, we are essentially unable to access the true Account record for an individual. What I would like to accomplish is this: a trigger that will copy the email address from our Contact object into our email field on the Account object. This would happen when the field is changed in any way.

I hope that I've provided enough information, but if not I will gladly elaborate where needed. Thanks in advance everyone.

We have the trigger below that if an attachment is deleted from Chatter Feed, certain profiles will recieve the error message. I need assistance in updating the trigger to only fire on a certain object (Documents_Manager__c). Currently the trigger is firing on all objects. The trigger is also currently blocking the System Administrator profile for testing testing purposes but we would like to add serveral profiles to the block list as well. Thank you in advance!

I need to hide/disable the back button that appears on the top left corner when I navigate from one component to another. I do not want to keep track of the history/trail path of the component's navigation.

I've been asked to update an Opportunity lookup field (looks up Custom Object "Threshold") based on 3 Opportunity picklist values (they are also dependant picklists) with a Threshold record id that matches those 3 picklist values.

Conceptual plan:When a1,b1,c1 are selected, update lookup to Threshold with Threshold record that matches a2,b2,c2 to a1,b1,c1

I am thinking on using process builder to set the criteria which covers {a1,b1,c1 are selected} I am stuck finding a way to create a formula that pulls the record based on matching the Opportunity picklist values.

We have a validation rule that uses ischanged on a long text field and on a rich text field. when either one of them is changed, the validation rule should fire. It appears that the ischanged() doesnt work with rich text field in validation rule and the rul fires even when the field isnt changed? Has anyone experienced this issue?

For record type '012a0000000AWNv' , If the picklist value of 'Report: New/Modify (Complete Section I)' is chosen from the field 'SF_Request_Type__c', then I want the user to be forced to make either the 'Modify_Existing_Report__c' checkbox or the 'Create_New_Report__c' checkbox to be true.

With the validation rule that I have written below, it's forcing the user to choose either checkbox REGARDLESS of the value in the picklist field. If you can help, that would be really great...

I have created a process on process builder that checks for certain critiera. IF criteria is met then process assigns task to one of the account managers. Because of the limitations with process builder, I haven't be able to run this process periodacly as I wish. The trigger in process builder is limited to Create or Update records..

I have a requirment to bulid a formula which would tweek the values selected from some picklist values. The issue is the length of my formula is '44000' and i hold sfdc allow only 3900 char in formula. If i split the formula also i may have to create nearly 10 formula field and then concatinate them. Is there any workaround for this please suggest.

We have a validation rule on Opportunity Stage that does not allow most users to change to stage to "Closed Won". There is a dependent picklist field "Sales Status" that has values which are aligned to "Closed Won" values/answers that we need those blocked users to be able to select even though they are not allowed to change Opportunity stage to "Closed Won" ie; allow for the pick list values without changing Stage. Would it be easier to have a pre-"closed won" stage without validation where the dependant fields that resides on Closed Won can be set prior to the fianl setting of closed won by those users that can modify stage?

I have 2 custom picklist fields, Eg : abc__c(New, Open, Inprogress) and xyz__c(High, Medium, Low, Average)If the value of picklist abc__c is 'New' , xyz__c should not be 'Required' and for all rest of values on abc__c , xyz__c should be Required

My requirement is to only allow users with the profile of "Freelance Writer" to change the value of the Status__c picklist if the current value of Status__c is "Assigned", "Sent For Revisions by Editor", or "Sent for Revision by Client". Here is what I have so far:

Hi We are currently having issues in our environment where we've gone and created 2 Process Builders pulling from Task and then updating on the Contact.

Error element myRule_1_A1 (FlowRecordUpdate).The flow tried to update these records: 0032A00002VB8EmQAL. This error occurred: ALL_OR_NONE_OPERATION_ROLLED_BACK: Record rolled back because not all records were valid and the request was using AllOrNone header. For details, see API Exceptions.

More so, we are having issues with the flows when lead conversion happens.

Error: System.DmlException: Update failed. First exception on row 0 with id 00T23000005q7a7EAA; first error: CANNOT_EXECUTE_FLOW_TRIGGER, The record couldn’t be saved because it failed to trigger a flow. A flow trigger failed to execute the flow with version ID 301230000000VKM. Flow error messages: <b>An unhandled fault has occurred in this flow</b><br>An unhandled fault has occurred while processing the flow. Please contact your system administrator for more information. Contact your administrator for help.: [] Class.leadconvert.BulkLeadConvert.updateLeadTasks: line 1279, column 1 Class.leadconvert.BulkLeadConvert.convertLead: line 127, column 1

We've concluded that we get these errors when the Lead has more than 10 or 20 tasks related. Those tasks in particular are the ones that trigger our Process Builder.

We tried to diagnose the issue in Sandbox as well. Based on posts I've read it's possible that we are hitting limitations

Does anyone have any suggestions aside from creating an Apex Trigger to do this?

Need some advice re Locker Service. As locker service will be auto enabled in Summer ’17 release, has anyone activated the LockerService critical update and test in sandbox to verify the correct behaviour of the components? If so, would be great to know what kind of issues faces and any recommended approach, best practice to resolve those? .

I need to create a "Client Due Date" field. This formula should be based off (the Submission date field) Submission_Date__c PLUS a number that is selected from the picklist value from the Processing Days (Processing_Days__c) field which includes the values: 8.9,10,11,12,13,14,15

I want to create a Json string that has a document that shows base64ex.{ "first name" : "Rob, "mypdfdoc" : "AAASDECgtNhr==" }

when I pass the file to JavaScript it encodes it to base64 .when I pass it back to a string type in my controller it shows [file type object]not AAASDEC...Any ideas why it is not showing it as a base64 string, instead displays [file type object] in the debug log?Basically I want to take the base64 string and use put to assign to a mapthank you

I am trying to validate the phone number on the contact according to multiple formats. I want users to be able to enter phone numbers that match one of three formats, one starting with "+" , another starting with "00" and finaly one starting with "(".

I can create all of the these as single validation rules, but when I try to combine two or more, I am struggling wiht the logic even if the syntax of the formula is correct.

Hi, There are 2 objects, Contacts and a custom object. The custom object has a lookup to Contact object.My requirement is that I need to quey all those records from the custom object which do not have a lookup to Contact.

I tried creating the following formula, but I got an error message that said there were too many characters in my formula. I'm trying to use the CONTAINS function, but I'm losing my formula ... any help is appreciated.

Currently I m using next and previous arrow buttons on click of which i call my javascript function. I want to call this function on left and right swipe event. Can somebody suggest a way to capture the left and right swipe on my component?

Hi All, I had gone through some problems working withDescription field so now I got a solution to work with "Long Text Area DataType", if you want to count() the records or other filtering things with Description. I made a custom field "Notes__c"(Text Area) in contact object and using Trigger i copied the contents of Description field to Notes__c.here is the code:trigger CopydescToNotes on Contact (before insert,before update) {for(Contact c : Trigger.new)if(c.Description!=null)c.Notes__c=c.Description;}