Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[MusicBringer]

I am having a bit of trouble with the Description field.
Some records seem to have "pages" of text, whereas others have just a line or two, which I prefer.
How can I make a view to filter out and display the Description fields that contain more than say 100 characters of text.
thanks,
☺

[Moe]

This should do it.  Put this in an expression column.  Any description longer then 100 will be marked "Over 100" any ones less than 100 will be marked as "Less Than 100".  You can go from there.

Code: [Select]

if(compare(length([Description]), >=, 100), Over 100, Less Than 100)

[MusicBringer]

It works.

It works very well.
thanks,
 
What type of view would you think suits this.

[Moe]

I would use a pane view, but I use pane views for pretty much everything.  But you could put that expression in one of your panes and with one click filter out all that are over 100.

[MusicBringer]

Yep, that's what I'm doing.
Thanks Moe 👍😊