Skip to main content
TimothyBr
TimothyBr
New Participant
November 8, 2023
Question

Minimizing characters in a cell in a report

  • November 8, 2023
  • 1 reply
  • 464 views

I have been wanting a way for years to minimize the amount of characters on a custom form. I know this is not possible at the time, but will vote up anything out there around it. 

 

On a different question, can I limit this in a report to only show x-amount in a cell via text mode? 


Thanks!

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    1 reply

    Madalyn_Destafney
    Madalyn_Destafney
    New Participant
    November 9, 2023

    Hi there! This would be a good starting point for you, you'll of course need to update the field name you're wanting to only show a certain # of characters for. We have last note pulling in a column of a view, and to help not have these cells get too big we have it cutting off at 140 characters. You can revise the 140 you see to any # you need, as well as the field names.

    valueexpression=IF(LEN({lastNote}.{noteText})>140, CONCAT(SUBSTR({lastNote}.{noteText},0,139),"...(open for more) -- ", {lastNote}.{owner}.{name}," on ", {lastNote}.{entryDate}), IF(LEN({lastNote}.{noteText})>0,CONCAT({lastNote}.{noteText}," -- ", {lastNote}.{owner}.{name}," on ", {lastNote}.{entryDate})))


    Adding this value expression above to our last note column makes it truncate like this:

     

    If this helped you, please mark correct to help others : )
    Terms & ConditionsAccessibility statement

    Loading footer...