Limiting Characters Displayed in Table Reports

Question

Hi guysDoes anyone know/is there a way to limit the # of characters that can be displayed in a table report?I don't want to limit the amount of characters one can enter into the field itself. Only that when it's displayed in a table report it should stop after, say, 20 charachters and then show "..." to indicate that there's more data there (that can be viewed by selecting the record and going to it's form view).I'm trying to get my table report to look tidy without text wrapping and without having to slide right and left to view all the columns.Anyone know anything/have any ideas?Thanks!Elisha​​------------------------------Elisha Tenenbaum------------------------------

MarkShnierYou · Answer

Here is the low tech solution.
Make a new formula text field called [Notes first 20]

Left([Notes],20)
& IF(Length([Notes])>20, " more ...")

There are also fancier solutions which allow the More ... to be a hyperlink to open up the record in View mode.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community