You need to sign in to do that
Don't have an account?
Edward Vazquez
This is some of the html for my email template that shoots out automatically.The applicant names are not always all filled out it just depends on the specific contact record. Some may have 1 applicant, some may have 2, and some may have all 6. My Question is how do I add commas to seperate the applicant names only when needed. I don't just want to have commas with blank spaces. Any ideas?
Salesforce Email Templates Question
This is some of the html for my email template that shoots out automatically.The applicant names are not always all filled out it just depends on the specific contact record. Some may have 1 applicant, some may have 2, and some may have all 6. My Question is how do I add commas to seperate the applicant names only when needed. I don't just want to have commas with blank spaces. Any ideas?
IF (
NOT(ISBLANK(Applicant_6_Name__c)),
Applicant_1_Name__c & ", " &
Applicant_2_Name__c & ", " &
Applicant_3_Name__c & ", " &
Applicant_4_Name__c & ", " &
Applicant_5_Name__c & ", " &
Applicant_6_Name__c ,
IF (
NOT(ISBLANK(Applicant_5_Name__c)),
Applicant_1_Name__c & ", " &
Applicant_2_Name__c & ", " &
Applicant_3_Name__c & ", " &
Applicant_4_Name__c & ", " &
Applicant_5_Name__c,
IF (
NOT(ISBLANK(Applicant_4_Name__c)),
Applicant_1_Name__c & ", " &
Applicant_2_Name__c & ", " &
Applicant_3_Name__c & ", " &
Applicant_4_Name__c,
IF (
NOT(ISBLANK(Applicant_3_Name__c)),
Applicant_1_Name__c & ", " &
Applicant_2_Name__c & ", " &
Applicant_3_Name__c,
IF (
NOT(ISBLANK(Applicant_2_Name__c)),
Applicant_1_Name__c & ", " &
Applicant_2_Name__c,
Applicant_1_Name__c
)
))))