the reference link needs to display as follows
If course code starts with a P, drop first char, then only pull next 5 char
eg. PE0090E -> should pull brochure E0090
Kindly advice
4 réponses
Hi Mathew & Syed,
Thanks for your reply...
I have modified the formula liitle bit (IF(BEGINS(CourseCode__c,'P'), MID(CourseCode__c,1,5),HYPERLINK("G:/Marketing/Course brochures/"& CourseCode__c & ".pdf", "View Course Brochure"))).
When i click on the Course Broucher Link on the program which contains course code starting letter as P, it should drop the first letter and display the broucher of E0090. With the above formula. its not removing P and link is not working.
Please tell me the better way to solve the issue.
