How can we check if the record has an attachment in list view

divya_dattatray · ‎10-26-2016

How can we check if the record has an attachment in list view. As now we have to open every record to see if the record has an attachment.

so want to know if record has an attachment from list view itself, how we can achieve this.

ChrisBurks · ‎10-26-2016

Another way that is possible is using the hasAttachments() on the sys_ui_style table for the record. For instance if I wanted an icon or color change to indicate that the record has an attachment in the list view I could setup a style like so:

And if the record has an attachment it will display like below (I didn't have a paperclip icon 😞

(Notice the little yellow document icon)

I know, aesthetically it's not all that pretty. But it's an option. Perhaps maybe if the field were just an empty field and then this style placed on that field it may look better.

View solution in original post

Jeffrey Siegel · ‎07-21-2021

that worked, now im trying to get it to appear in its own column, anyone get it to work this way, ive added a field but unless it contains data it doesnt show.

ChrisBurks · ‎07-21-2021

When nothing is populated in a field the system doesn't render all of the html elements that would be there if a value was present.

ServiceNow has changed the structure of the platform since the original post. If you want the icon to appear in another field all by itself the best solution I think is to make that field an image field, write a BR script to populate it with the appropriate icon image when the record has an attachment.

Jeffrey Siegel · ‎07-21-2021

Any chance you can help with that code?

ChrisBurks · ‎07-21-2021

Of course. Give me a bit though as I need to work through my actual work load first.

Jeffrey Siegel · ‎07-22-2021

Thanks, much appreciated!!