You need to sign in to do that
Don't have an account?
Alexej Ignatow 1
I have numbers and long account names, i would like to shorten it only to show one part of it. Any help would be great
Currently my name is made up as follows
1. London, Royal Opera Hous
i would like to show the account name only as
London (i.e. without "1." and without the second part after comma)
All this i also would like to be able to use as a hyperlink so that when i click on it, i am redirected to the relevant account
Please help, currently i only got to
Data TypeFormula
LEFT(Account.Name, FIND( ",", Account.Name ) -1 )
which eliminates the second part however, i cannot remove the "1." and also cannot make it work as a link
MANY thanks
1. London, Royal Opera Hous
i would like to show the account name only as
London (i.e. without "1." and without the second part after comma)
All this i also would like to be able to use as a hyperlink so that when i click on it, i am redirected to the relevant account
Please help, currently i only got to
Data TypeFormula
LEFT(Account.Name, FIND( ",", Account.Name ) -1 )
which eliminates the second part however, i cannot remove the "1." and also cannot make it work as a link
MANY thanks
This might help:
Thanks,
Princy
All Answers
This might help:
Thanks,
Princy
Hope this make sense
Currently i now have London as hyperlink that when clicked opens the London account. I now also want to show next to London an image that is also a hyperlink but redirects to a different webpage. is that possible?!