Automate process of copying project documents
Genady Vaisman
Genady Vaisman
August 12, 2014 | Products

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.

intro

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.

Project Department

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:

templates

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

Documents column

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.

Project lookup

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.

Lookup Field Action

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

Actions List

 

1. Action to create the Department folder inside Documents library

Department Folder Action

 

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

Project Folder Creation

 

3. Finally the action to copy the documents

Copy Documents Action

 

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

Final Result

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

 

 

Loading...

Add your comment

Comments are not designed to replace support calls. If you have a specific issue with one of our products, please send an email to support@infowisesolutions.com to open a support ticket.

UltimateForms

Build powerful business applications in SharePoint using only your browser.
100% No-Code Solution

It's never been easier, to create, innovate and share, all you need is your web browser!

Cost-effective

Address business process pain points immediately. Save time and money.

Fantastic Support Team

Facing difficulties installing the application? Contact our fantastic support team.

support@infowisesolutions.com

Related Topics

What is right for you?

Online Trial

Not ready to install yet? Create a trial site in our environment
  • Full control of the site and its settings
  • Optionally pre-install one of our solution templates
  • Site provisioned instantly
  • Automatically removed after 30 days
  • Available to everyone!

Error!

There was an error processing your request.
Please contact us for further details.

Installation

Install in your own environment, on Microsoft 365 and on premises
  • Start working with real users and data
  • Install online or on premises
  • Register for 30 day trial
  • Seemlessly convert to paid license
  • Requires administrator permissions

Success!

Download link has been emailed to .
If you do not receive it within 5 minutes, please check your spam.
The link is valid for 72 hours.
If you are having problems, please contact us.

Error!

There was an error processing your request.
Please contact us for further details.
Technical details:

Request a Live Demo

Book an appointment for a one-on-one with an ULTIMATEforms expert trainer.

Test drive the awesome power of ULTIMATEforms

Learn how to quickly and easily turn time-consuming business processes into automated, efficient workflows.

Have a strong start

Only thirty minutes of well-coached time can translate into great future savings in time and money. So, sit back and enjoy the ride.

It's Free

Learn how to address business process pain points immediately. Save time and money.