Genady Vaisman
Genady Vaisman
August 12, 2014
Stay in the know
Get helpful videos

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 meant for support. If you experiencing an issue, please open a support request.
Products
Using Electronic Signatures in Microsoft SharePoint Forms
Vladi Gubler | March 27, 2025
In this post I'm going to go over the Signature component of our Ultimate Forms. I will explain...
Products
Infowise Ultimate Forms vs. InfoPath - feature-by-feature comparison
Vladi Gubler | January 27, 2025
When we started to develop Ultimate Forms, we did not position it to be an InfoPath competitor or...
Products
Use rating scale columns in your forms
Vladi Gubler | January 06, 2021
If you've used Survey lists in SharePoint, you are probably familiar with the nifty little column...
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
In addition to our responsive support team, a wide variety of resources, documentations, tutorials, blogs and webinars is available to you
Microsoft partner logo
© 2005-2025 Infowise Solutions Ltd. All rights reserved.
Privacy | Cookie Policy | Accessibility | Cloud SLA