• Akhil Anil
  • PRO
  • 2745 Points
  • Member since 2015

  • Chatter
    Feed
  • 86
    Best Answers
  • 0
    Likes Received
  • 2
    Likes Given
  • 1
    Questions
  • 334
    Replies
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. 

Opportunity picklist fields:
a1. Market
b1. Vertical
c1. Segment

Threshold fields:
a2. Market (Custom Field)
b2. Record Type
c2. Segment (Standard Name Field)

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.

Thanks in advance!
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...

AND( 
Modify_Existing_Report__c = FALSE, 
Create_New_Report__c = FALSE, 

OR( 
ISPICKVAL (SF_Request_Type__c, "Report: New/Modify (Complete Section I)"), 
RecordTypeId = '012a0000000AWNv'))
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..

Can someone walk me through how build such a trigger in Apex? 

Thanks,
Fares Alsyoufi.
Hi All,

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.

Thanks!
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 two picklist fields which are dependent.I have to populate a text based on the two picklist fields
HI All,

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 

Need an validation rule for this.. 

Thanks!!
Hello All ,  I know how to add a lightning component created via developer console to a VF page.

My question is , is there a way to a component created via Lightning App Builder to a VF Page ?

Thank you all
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:
 
AND
(
 $Profile.Name = "Freelance Writer",
ISCHANGED(Status__c),
NOT(ISPICKVAL(Status__c,"Assigned")),
NOT(ISPICKVAL(Status__c,"Sent for Revisions by Editor")),
NOT(ISPICKVAL(Status__c,"Sent for Revisions by Client")))
But its not quite right - seems it restricts the user from making change to Status__c even if Status__c is set to one of the acceptable values.  Do I somehow need to use PRIORVALUE for this?
 

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?  

Hi All,

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

Thanks in advance. 
Regards
-Riti
Hi, 

I need some help with a formula. 

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 

Could someone please help me out on this one?

Thanks
Tori
Can anyone see why my lead conversion is failing?

User-added image
Hi Friend,

Now I m using Professional edition . I need to avoide duplcate company websites in Account object. For this one how to write validation rule on this field ?
I want to create a Json string that has a document that shows base64
ex.
{ "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 map
thank you
 
Hi,

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.

Any suggestions?
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.

Please help.
​Thanks.
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. 

IF(ISPICKVAL(Service_Type_del__c, "One-time"),
ABS((Cost__c * Probability) / 1),

IF(ISPICKVAL(Service_Type_del__c, "Yearly"),
ABS((Cost__c * Probability) / 1),

IF(ISPICKVAL(Service_Type_del__c, "Twice Yearly"),
ABS((Cost__c * Probability) / 2),

IF(ISPICKVAL(Service_Type_del__c, "Quarterly"),
ABS((Cost__c * Probability) / 4),

IF(ISPICKVAL(Service_Type_del__c, "Monthly"),
ABS((Cost__c * Probability) / 12),

IF(ISPICKVAL(Service_Type_del__c, "Twice Monthly"),
ABS((Cost__c * Probability) / 12),

IF(ISPICKVAL(Service_Type_del__c, "Weekly"),
ABS((Cost__c * Probability) / 12),

IF(ISPICKVAL(Service_Type_del__c, "Twice Weekly"),
ABS((Cost__c * Probability) / 12),

IF(ISPICKVAL(Service_Type_del__c, "Daily"),
ABS((Cost__c * Probability) / 12),

0
)))))))))