You need to sign in to do that
Don't have an account?
Ken sfdc1
Can anyone help me issue with encrypted field as can't use in workflow
please follow this workflow we are trying to create a formula of patient ID by a trigger with the combination of these conditions and fields.We are going for trigger because AEGR_Patient_Initials__c field is converted to encrypted field which is not possible in workflow.
Condition Created and every time edited.
AND(ISPICKVAL($User.AEGR_User_Country__c,"Brazil"),
OR(ISPICKVAL(AEGR_Product__c , "Lomitapide"),
ISPICKVAL(AEGR_Product__c , "Metreleptin"),
ISPICKVAL(AEGR_Product__c , "")),ISPICKVAL( AEGR_Status__c,"Identified" ))
Object : Patient Profile
Field to Update Patient Profile: Patient ID
Formula value:
IF(ISPICKVAL(AEGR_Product__c , "Lomitapide"),
AEGR_Patient_Initials__c & "-" & "LOM-BR" & "-" & TRIM(RIGHT( Name , 4)),
IF(ISPICKVAL(AEGR_Product__c , "Metreleptin"),
AEGR_Patient_Initials__c & "-" & "MET-BR" & "-" & TRIM(RIGHT( Name , 4)),
IF(ISPICKVAL(AEGR_Product__c ,""),"",
Condition Created and every time edited.
AND(ISPICKVAL($User.AEGR_User_Country__c,"Brazil"),
OR(ISPICKVAL(AEGR_Product__c , "Lomitapide"),
ISPICKVAL(AEGR_Product__c , "Metreleptin"),
ISPICKVAL(AEGR_Product__c , "")),ISPICKVAL( AEGR_Status__c,"Identified" ))
Object : Patient Profile
Field to Update Patient Profile: Patient ID
Formula value:
IF(ISPICKVAL(AEGR_Product__c , "Lomitapide"),
AEGR_Patient_Initials__c & "-" & "LOM-BR" & "-" & TRIM(RIGHT( Name , 4)),
IF(ISPICKVAL(AEGR_Product__c , "Metreleptin"),
AEGR_Patient_Initials__c & "-" & "MET-BR" & "-" & TRIM(RIGHT( Name , 4)),
IF(ISPICKVAL(AEGR_Product__c ,""),"",
AEGR_Patient_Profile__c [] updates = new AEGR_Patient_Profile__c[] {};
for (AEGR_Patient_Profile__c pp: Trigger.new) {
if (pp.$User.AEGR_User_Country__c == 'Brazil') {
updates.add(new Opportunity(Id = opp.Id, Opp.OppStatus__c = 'Won'));
}
}
update updates;
}
}