Skip to main content
October 24, 2023
Question

Limit character shown in a grid

  • October 24, 2023
  • 2 replies
  • 0 views

Hi All,

I was wondering if there is a way to limit the number of characters shown per column in a grid. For example, I have a grid that has one column that shows a field called description and its data max character limit is 2000, but in the grid visually I only want to show 500 and then .... if they put their cursor over can see the rest. Is this possible or even something similar, this way the grid looks more harmonic since some data has up to 2000 characters but other ones are only 100-200  and things like that.

thanks in advance

2 replies

stefanhelzle0001
Brainy
October 24, 2023

You can use the left() function to limit text to a certain number of characters. Then append some dots.

October 24, 2023

thank you for responding, but with this the only way to view the whole "paragraph" would be by opening the record itself right? the cursor part is not available in appian right?