Forum Discussion

ElishaTenenbaum's avatar
ElishaTenenbaum
Qrew Cadet
5 years ago

Limiting Characters Displayed in Table Reports

Hi guys Does 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. ...
Formulas and functions
reports and charts
MarkShnier__You's avatar
MarkShnier__You
Qrew Champion
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
------------------------------
ElishaTenenbaum's avatar
ElishaTenenbaum
Qrew Cadet
5 years ago
Thanks!!!
I'll try that and let you know what happens

************** 
Elisha Tenenbaum
Operations Coordinator



------Original Message------

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
------------------------------
  • ElishaTenenbaum's avatar
    ElishaTenenbaum
    Qrew Cadet
    5 years ago
    That worked perfectly!
    Thanks again

    ************** 
    Elisha Tenenbaum
    Operations Coordinator



    ------Original Message------

    Thanks!!!
    I'll try that and let you know what happens

    ************** 
    Elisha Tenenbaum
    Operations Coordinator

    sparkAV ltd. 
    672 dupont st. suite 410 
    toronto, ON 
    M6G 1Z6 

    tel. 416-422-4777 xt 211
    cell. 647-608-4363

    www.sparkAV.com 
    solutions that ignite the mind!