Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Truncate Value in Text Field?


Recommended Posts

I have a field (Company Name). It has a Maximum of 50 Characters defined in Options>Validation>Maximum Number of Characters. This is fine for most layouts.


However, I want to place (CompanyName) on one layout where it displays only 25 characters including spaces. On the most basic level, I can just make the field shorter on the layout, but this does not work properly for all situations because FM breaks at the nearest "space" that is located prior to the end of the field and then hides the rest of the text until you enter the field.


It seems that there must be a way to define another field (CompanyNameCalc) that takes the text from the Company Name field and truncates it at 25 characters.


I cannot come-up a calculation or text function that will do this. Any ideas?

Link to comment
Share on other sites

Good morning:


Your hunch is right; you'll need a calculation field (Text) to handle this 25-word truncation.


In the "box" where you define the calculation's argument, take a look at the "Text functions." You'll find a bunch of toys there.


Try the Left ( text ; numberOfCharacters ) function, in which you can declare the number of characters you want to keep. Replacing the parameters with your real-world stuff, it will end up probably look something like ...


Left ( Company Name ; 25 )


Let us know if this is what you had in mind.

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...

Important Information

Terms of Use