Hey everyone,

Here is what we're hoping to achieve... for our criminal case files, we are required to keep a log of any time that a new document pertaining to the case is entered into the LF repository. To do this, currently, we manually update an Excel spreadsheet (with each row having the name of the document, the user who stored it, and the date it was stored). This is fine, however, we would like to streamline this process for them so that, once a new file is entered into that repository folder, it'll automatically update the spreadsheet for them.

What I have heard so far is that without very advanced scripting, this is not possible utilizing the built-in tools from workflow. Have any of you been able to achieve something similar to this in Excel? That's the preference. If not, any other proposed solutions you could offer? I've thought of two...

1. A Word doc where the Workflow activity updates the table with the information of the new document. I've kind of struck out on this one though - can't seem to get that functionality to work.

2. Having Workflow kick off a basic form that overwrites itself each time a new document is entered into that folder of the repository. I have gotten this to work for ONE line of the form, which looks great. But subsequent rows aren't filled, and that first row just gets overwritten.

I am open to suggestions, but this would be a huge help to our Legal team if we could figure something out here! Please let me know if you need anything else from me to help troubleshoot this issue.

Thanks,

Ryan