You need to sign in to do that
Don't have an account?
Ken sfdc1
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 ,""),"",
Can anyone help me with encrypted field can't use in workflow field update
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 ,""),"",