Demo application - Construction Initiation Project
Vladi Gubler
Vladi Gubler
September 05, 2011 | Sample Applications

Hi,

In this demo application we are showing off how our Bi-directional Lookup bundle can help you create real-life application in SharePoint in just minutes. The bundle contains two products:

  • Connected Field - extends the built-in lookup field, adding various new capabilities, such as master-detail relationships between two or more fields, value sorting and filtering, in-line new value creation and more
  • Associated Tasks Field - allows creating relationships between lists, allowing managing related items or documents in the context of the parent item

The demo application is a construction initiation project. In it, we create an entry for a proposed constructions project, add various required documents to it, publish the documents for review and collect reading confirmations from the designated users. Once all the required reading tasks have been completed, the project is completed and we can now proceed on with our construction. As we only cover this initial stage, we will not be handling the actual construction stages here.

Watch the following video to see the system in action:

So lets get started.

First, we need to create a new blank site for the project. Then, we will create several lists that will manage our data.

Lists

  1. Designations - a simple Custom list holding list of designations for the project, such as Residential, Commercial or Agricultural. Just create the list from the Custom list template and enter some demo data, no changes to the list structure are required
  2. Building Types - for each designation we list several building types, such as House or Appartment Building for Residential, Bank or Shop for Commercial. Create a custom list and add a lookup column for the Designations list.
  3. Signing Tasks - list hoding reading confirmation tasks. We can either use the built-in Tasks list or the supplied Associated Tasks list. In the first case we will need to replace the built-in Task content type with the provided Associated Task content type. Using the built-in list type involves a little bit more work, but gives you the added benefit of email notification when a task is assigned.
    1. Create the list from Tasks list template
    2. In Advanced Settings enable content type management
    3. Add content type from Infowise group called Associated Task
    4. Remove built-in Task content type
    5. Remove unnecessary column, leaving only Title, Start Date, Due Date and Assigned To
    6. Add yes/no column Confirm Reading, set default value to No
    7. Signing Tasks
  4. Documents - document library to manage the construction documents
    1. Create the document library
    2. Allow content type management under Advanced Settings
    3. Add Associated Document content type under Infowise group
    4. Remove built-in Document content type
    5. Add Signers (person or group) field
    6. Add All Signed (choice) field with option Yes and No, No is the default. Set the column to be hidden in forms in the content type settings as we will be updating it programmatically using a workflow
    7. Add Document Type (choice) field with some demo data, such as Budget or Structural Plans
    8. Documents
    9. Add Read & Sign (Associated Tasks) field, pointing the the Signing Tasks list. Allow task generation for users in Signers field.
    10. Documents ATF
  5. Construction Projects - this is the main list of the system, where the actual projects are managed.
    1. Create list from Custom list template
    2. Create columns as shown in the following figure.
    3. Project
    4. The Building Type column is a Connected Field, it must be set to be filtered by the parent Designation column
    5. Connected Field
    6. The Document column is an Associated Tasks column pointing to the Documents library
    7. Documents ATF
    8. Status column contains values New, In Process, Completed (New is default). Set the column to be hidden in forms using the content type settings as we will be updating it using a workflow

Now we can add a couple of workflow to take care of our status columns. These are simple workflows created using SharePoint Designer 2007 or 2010.

First, let's create a workflow to run on the Signing Tasks list to update the All Signed column of the parent document. The workflow will run each time any task is updated, it will check if all tasked for the particular document are completed and then will update the document itself.

Note: make sure the Associated Tasks WF Support feature is activated for the web application.

Document WF

  1. Open the site in SharePoint Designer
  2. Create a new List workflow for the Signing Tasks list. The workflow is to be set to run each time an item is updated
  3. Call the workflow Document Status as that's what it is supposed to update
  4. Add condition of type Associated Item value check
  5. Set check for Confrm Reading column to be actual to Yes
  6. Add action Infowise Associated Tasks Extract Parent ID to get the parent document item ID from the related task and store it in a workflow variable
  7. Add action to update the parent document in the Documents list, by setting the All Signed value to Yes for item with ID matching the stored variable
  8. Publish the workflow

Now we add a workflow to set the project status to Completed when all documents are read by all users

Project WF

  1. Open the site in SharePoint Designer
  2. Create a new List workflow for the Documents list. The workflow is to be set to run each time an item is updated
  3. Call the workflow Project Status
  4. Add action Infowise Associated Tasks Extract Parent ID to get the parent projectitem ID from the related document and store it in a workflow variable
  5. Add Update List Item action to update the status of the parent project to In Process. This way any update will change the project status from the default New status
  6. Add condition of type Associated Item value check
  7. Set check for All Signed column to be actual to Yes
  8. Add action to update the parent item in the Construction Projects list, by setting the Status value to Completed for item with ID matching the stored variable
  9. Publish the workflow

This is it, you now have a functioning system and it took you just a few minutes!

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.