The title says it all. I would like to add a field to the attachment object to be able to sort/filter based on the attachment's type (eg, 'Will', 'Account Opening Document', 'Correspondence', etc.).

Thanks!

Attribution to: jackerman09

Possible Suggestion/Solution #1

1) I am assuming you are trying to use this in some apex/query and 2) I am not too familiar with attachment object but from docs I see

1) This read-only object contains all notes and attachments associated with an object. http://www.salesforce.com/us/developer/docs/api/Content/sforce_api_objects_attachment.htm ContentType is a already existing field desc : The content type of the attachment. If the Disallow HTML documents and attachments security setting is enabled for your organization, you cannot upload files with the following file extensions: .htm, .html, .htt, .htx, .mhtm, .mhtml, .shtm, .shtml, .acgi.

Does this help ?

Attribution to: Rao

Possible Suggestion/Solution #2

There is no way to add a custom field to the Attachment object. However, there are two ways to do what you want.

1) Create a custom document object to store additional information about the attachment and attach the files to that object. You would have one attachment per document and if you wanted to write a small trigger you could even automatically add direct links to download the attachment onto the document.

2) Use Chatter files instead of attachments. Chatter files and Content have much more robust searching/tagging/filtering capabilities than attachments.

Attribution to: Greg Grinberg
This content is remixed from stackoverflow or stackexchange. Please visit https://salesforce.stackexchange.com/questions/1604