Automate process of copying project documents

The setup I'm going to describe can be applied to many business processes that require documents being copied for each given subject.

In this case the subject will be a project.

In my example I have a projects list, which gets filled with projects according to departments.

Each department has a preset of documents that need to be filled for each project, these documents are stored inside a Templates document library and are associated to the relevant department through a choice site column.

My goal is: as a new project is entered into the projects list, copy all relevant documents into a dedicated documents library under the path: {Department}/{Project Name} and then connect them back to the project item for fast access.

This is how the templates library looks like:

Each document is connected to a specific department.

The Projects list in my example is pretty simple and contains the following information:

• Title: name of the project
• Project Department: using the same column as in Templates to specify the relevant department
• Documents: using our Associated Tasks Field to connect the copied documents to each project

All the documents will be automatically copied into a documents library named Documents, where I have a Project lookup column, which is being used to connect a document to its project.

In order to set this field to the correct project, I have defined a simple action, using the Smart Action Pro. This action will set Project field's value to the value of the document's folder. I remind you that all the documents will be copied into a folder structure of type: {Department}/{Project Name}, so eventually each document's parent folder is also the title of the project.

Now let's get to the actions that do the heavy documents lifting. These are the actions that are defined in the Projects list:

1. Action to create the Department folder inside Documents library

2. This Action will create the project folder under the Department folder

3. Finally the action to copy the documents

and so after creating a project item with the title "Module X Development" and selecting the department to be RnD, the final result is:

A quick summary of the process:

1. Project item is entered

2. The following actions are activated on the Projects list

2.1 Create Depatment folder

2.2 Create Project folder

2.3 Copy department relevant documents from Templates library into Documents library, under the folder {Department}/{Project Name}

3. Each document added to the Documents library, triggeres the following action:

3.1 Set Project lookup column to the value of the parent folder, thus connecting the project item to the document through the Associated Tasks Column

hope you'll find this helpful and enjoy using our products