Saved Search to see if there are any attachments in the record

The client wants to see a field in the saved search to show whether the record is attached with any files or not.

If there is an attachment the field should show “Yes” otherwise the field should show “No”

Formula

CASE WHEN {custrecord_attached_url_case.internalid} IS NOT NULL THEN ‘YES’ ELSE ‘NO’ END

Leave a comment

Your email address will not be published. Required fields are marked *