rich text field max characters size

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • In Progress
We have a rich text field that is configured to be 4000 characters max. When I put a 3721 character field (with spaces) and it gives me an error when I try to save the record. Is there a formula to determine the "real" number of characters that can be entered?
Photo of Jeff

Jeff

  • 252 Points 250 badge 2x thumb

Posted 2 months ago

  • 0
  • 1
Photo of Slider

Slider

  • 1,326 Points 1k badge 2x thumb
Length([Rich Text Field]) will give you the actual number of characters detected.

It could be detecting hidden characters or spaces from excel, as a guess.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,486 Points 50k badge 2x thumb
The Rich text field is probably counting all the formatting fields such as <b> for bold etc.  I assume that you have a 4000 character limit as you are feeding data to another system with limited field size of 4,000 characters.  The number of characters will be depend on the amount of formatting that you do in the Rich Text field.

I suggest that you put the formula Slider suggested above on the form so the users can see how close they are to the limit.
Photo of Jeff

Jeff

  • 252 Points 250 badge 2x thumb
Thanks, great suggestion