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. 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
------------------------------

3 Replies

  • 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
      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
        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!