Greetings all, I'm very interested in hearing responses to this as well. We're establishing a workflow process that repurposes fields in TMS so select users may electronically sign-off on object treatments. Ideally, this process would be fully automatic, where once X field is filled in/'signed', then an email is sent to a specific group of people alerting them to login to TMS and look at the records, and approve or disprove the request. I had heard that SQL Server 2005 will allow the programming of email ticklers/triggers, but I'm not sure if this can happen within TMS. Any ideas from folks out there or GS support? Thanks in advance, Kate Diggle Collections Database Administrator National Postal Museum Smithsonian Institution Tel: (202) 633-5512 [log in to unmask] www.arago.si.edu -----Original Message----- From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Dorothy Davila Sent: Friday, June 05, 2009 11:19 AM To: [log in to unmask] Subject: Art handling work flow application Dear colleagues, As our museum moves away from a model where curatorial staff manage their own storage spaces to one where Collections Management facilitates access to storage, we have begun to look about for an existing work flow application to integrate with our TMS database. Ideally this application would facilitate art handling requests, formalizing the process beyond email/phone calls/hallway conversations to provide our curatorial and conservation staff with a user-friendly solution for their requests. Specifically we envision staff using the application to refer to TMS object packages when making requests for object movement/installation/mounts/study appointments, etc. Requests would trigger email(s) to the appropriate staff and create a secure, manageable list with deadlines for our chief preparator to oversee. Does anyone have any recommendations for an out-of-the-box or home grown system that they would be willing to share? We would be most grateful! Best wishes, Dorothy Dávila Associate Registrar for Collections 617-495-0474 direct 617-495-2379 general line 617-495-9936 fax [log in to unmask] Harvard Art Museum 32 Quincy Street, Cambridge, MA 02138 www.harvardartmuseum.org