How to identify if a record has a file attached in the list

[MiY]

Is there a way to identify in the list whether a record has a file attached?
For example, as in the screenshot below, if Row No. 1 has no file attached, but Row No. 2 has a file attached, I would like to be able to identify it by displaying an Excel icon in the list, etc.
Is this possible? If you know of a good way to do this, please let me know.

[KrushnakumaT]

Hi @MiY ,

 Possible Solutions
Option 1: Use a GlideAggregate script or business rule to track attachments
Create a custom field (e.g., has_attachment - type: true/false).

Write a Business Rule or Scheduled Script to check if a record has attachments.

Set the field has_attachment = true if an attachment exists.

Add this field to the list layout and use a list image (icon) based on true/false.

🔹 This doesn't show real-time data unless you update the field periodically or on record change.

Option 2: Use a UI Macro or List Decoration (advanced)
You can write a UI Macro that checks for attachments and returns an icon.

Then, use a List Layout Formatter or UI policy to show that icon in the list view.

This requires more development work and scripting knowledge.

Option 3: Attachment-related List (Not icon but visible)
In related lists, you can show the Attachments table (sys_attachment) as a related list for each record.

This shows attachments, but not as an icon directly in the list.

 Recommendation (Simple Way)
If you're okay with true/false indication (instead of an icon), the custom field method (Option 1) is the easiest and most maintainable solution.
If this response helped, please mark it as the correct answer so it can help others as well.
Thank you!!

[Ct111 · Accepted solution]

Something similar has been implemented in below 

THREAD

please check it for reference.

I hope this information helps.

[Ankur Bawiskar]

@MiY 

you can apply a field style and add icon and link shared by @Ct111 will work

If my response helped please mark it correct and close the thread so that it benefits future readers.