An idea has been floating around in my mind for a while about documents in the system. One of he biggest complaints I get from users from all of our departments - Professional Services, Support, Sales, Accounting, etc. is that it is nigh impossible to track documents effectively across the life cycle of a customer and their numerous child records.
I would like to have the ability for a sales person to add a doc to an opp, and a ps consultant to add another do to a work order and a support rep to add another one to a case and for all of these people to see these docs, regardless of where they reside in the file cabinet, represented on the customer record. That way we could standardize on a folder scheme per department, set it and forget it and just look for docs on the parent record.
There is the ability to attach docs to another record. I think of it multiple pointers to the same file. I am thinking I could make a script that was deployed to multiple record types looking for files and add the attachment to the customer in the record at the same time. I don't know if it's possible, though. Looking in the records browser I am not seeing file, attach or document references on any records I have searched on: Opportunity, Transaction, Case, Project.
Has anyone else tried this? Is it even possible? I know you can add attachments with web services but can you do it in script? Is it a dead road?