Hi all, I am auto updating an Opp child record's name with the name of the opp and some other characters but occasionally get THE STRING TOO LONG error.
How can I ensure that the Opp name is always shortened to 70Char for this update?
Thank you guys :)
7 answers
Eric Praud (Activ8 Solar Energies) 
Forum Ambassador
Yes, you can go with:
"CB-"+LEFT(OppName,IF(CONTAINS(OppName,";"),MIN(70,FIND(":",OppName)-1),70))This way, if there is a colon, it will stop there, unless there are more than 70 chars before this colon, in which case it will stop at 70. If there is no colon, it will stop at 70
