Forum Discussion

ChinmayDhandhan's avatar
ChinmayDhandhan
Qrew Trainee
8 years ago

Table Report view with multiline text

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? 
Ask about Quickbase functionality
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    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
    • QuickBaseCoachD's avatar
      QuickBaseCoachD
      Qrew Captain
      7 years ago
      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.