Table Report view with multiline text

Question

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?

QuickBaseCoachD · Answer

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

Sign up

Login to the community