Genady Vaisman
Genady Vaisman
August 12, 2014

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.
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
WELCOME TO THE FUTURE
New faster ways for creating business solutions
ULTIMATEforms is a platform that enables everyone to easily create and maintain Microsoft SharePoint-based business solutions without a single line of code
Simple and Intuitive
Streamline form creation with smart, user-friendly tools
Deploy smart dynamic forms that adapt to your business needs
Utilize a drag-and-drop interface for effortless form design
Experience rapid form customization with intuitive editing tools
Accelerate project timelines with user-friendly, immediate solutions
Powerful Automation
Enhance operational efficiency and compliance
Streamline complex workflows into straightforward actions
Quickly establish compliant business processes
Seamlessly integrate data from diverse applications
Access and combine information easily for better decision-making
Comprehensive Reporting
Transform data into actionable insights
Generate detailed reports and dashboards for informed decision-making
Customize alerts and notifications to stay updated
Print and export data to PDF, Excel, or Word for easy sharing
Visualize data with color-coded calendars and intuitive dashboards
100’s of Templates
Streamline form creation with smart, user-friendly tools
Access hundreds of customizable templates for every business function
Install easily with one-time set-up; free for ULTIMATEFORMS customers
Replicate entire sites with settings between site collections and tenants using Template Manager
Jumpstart projects with pre-built solutions from our growing catalog, applied with a click
Dive deeper
Watch a short introductory video showcasing the different unique capabilities of UltimateForms.
Ready to get started?
Hands-on training is the best way to get proficient. That's why we've created three unique training offerings which will help you master ULTIMATEFORMS. Our interactive sessions are delivered via web meetings and conducted within personal virtual workspaces.
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 GSA Schedule
© 2005-2024 Infowise Solutions Ltd. All rights reserved.
Privacy | Accessibility | Cloud SLA