Table Report view with multiline text

  • 0
  • 2
  • Question
  • Updated 5 months ago
  • In Progress
Please take a look at this screenshot -




See the mitigation plan has made the viewing so cumbersome. I know that I can disable the wordwrap. However that makes the column very very wide. 

Is there anyway to collapse the rows to show only first few lines? 
Photo of Chinmay Dhandhania

Chinmay Dhandhania

  • 224 Points 100 badge 2x thumb

Posted 2 years ago

  • 0
  • 2
The low tech solution is to make a new field called  [Mitigation Plan ...]

The formula would be

Left([Mitigation Plan],100)
&
if(length([Mitigation Plan])>100, ".... and more")

There are fancier solutions that involve being able to hover to see the full text, but try that as a start.  You can adjust the 100 to suit.  That is the # of characters to show
Photo of Ernest

Ernest

  • 10 Points
What are the more fancier solutions

I have the raw materials for the fancier solution but nothing that I have handy to post.  You might want to post a new question and see if someone had a ready answer for you.  Or else contact me directly at QuickBaseCoach.com for one on one assistance to get this working.