Have a text field 'Summary' with ids as values and Summary1 with names as values
Summary = a00o0000001Lgmb,a00o0000001LZRN,a00o0000001id76
Summary1=new product,product1,product2
Have created a formula field 'new' which displays the values of the Summary1 field as hyperlink but when clicked it redirects to the record by the record ids in the Summary field. But this formula is not working correctly. I Want to map each Summary1 value with Summary value ie each name value with id value seperated by comma. Want to display the formula field as
new= new product,product1,product test (but with hyperlinks and when clicked redirects to the url/recordid)
Now the problem is the values dont get detect the Commas.It displays like
new=new product, duct1,duct test, product1 Please help.
(HYPERLINK("url/"&LEFT(Summary,15),LEFT(Summary1__c,FIND(",", Summary1__c,0)-1)))&(',')&
(HYPERLINK("url/"&RIGHT(Summary,15),RIGHT(Summary1__c,FIND(",", Summary1__c,1)+1)))&(',')&
(HYPERLINK("url/"&MID(Summary,17,15),MID(Summary1__c,FIND(",", Summary1__c,2)+1,8)))