Ethan Bach
Ethan Bach
February 07, 2013

Ultimate Forms supports two types of approval processes. The first is static approvals, which means that each stage of the process has its own specific approver or approvers. A good example for that is our Vehicle Reservation System which has three stages – User Request, Manager Approval and Vehicle Supervisor. Although the user could be anyone, the Manager and the Vehicle Supervisor are strict and do not change according to the user who places the request.

The second type is dynamic approvers, which means that each stage can have different approvers according to rules and the entire approval route is changed according to selections. Good example for that is our HR Recruitment Process System which has five stages, each stage can have a different approver according to the association of the candidate. For example, if the HR recruiter associated the candidate to the Customer Service department then the approver should be the customer service manager, but if the HR recruiter associated the candidate to a different department, than the approver should be the person who runs that department and so on.

In our demo we will show how to create a simple process with dynamic approvers. This demo will be based on the existing Purchase Request system,
We will do some simple modifications to make it work with dynamic approvers.

The demo we will have three lists:

  1. Purchase Requests - this is where the users will place the purchase requests and the approvers will approve those requests
  2. Approval Tasks - will hold the tasks for each purchase request.
  3. Departments – will hold the mapping between the department and the approver/approvers.

The following steps will ensure you have the lists you need:

  1. First you would need to create the system (lists, columns and more) exactly as described in the following article - https://www.infowisesolutions.com/blog/Comments.aspx?ArticleId=85
  2. Create the Departments list from a custom list template
    1. Change the Title column name to Department Name.
    2. Add a new column and call it Purchase Requests Approvers, change the column type to Person or Group and save the column.
    3. Add items with your departments and approvers.
  3. Add a new column to the Purchase Requests list and call it Department, change the column type to Lookup and point it to the Department Name column in the Departments list. Mark it as required.
  4. On the Purchase Requests list
    1. Open the Tabs and Tab Permissions page, under list settings.
    2. Click on the Request tab and add the Department column to the tab (by double clicking on the column in list).
    3. Change the department column order to 3.
    4. Click on the Save button on the bottom of the page.
      Requester Tab Settings
  5. On the Purchase Requests list
    1. Open the Tabs and Tab Permissions page, under list settings.
    2. Click on the Approval tab.
    3. Click edit on the Write rule, under the Current permission rules.
    4. Next to the For users\groups: field, choose Column in the dropdown.
    5. On the dropdown next to it, choose Department.
    6. On the Dropdown underneath, choose Purchase Request Approvers.
    7. Click on the Update button.
    8. Click on the Save button on the bottom of the page.
      Approver Tab settings
  6. On the Purchase Requests list
    1. Open the Actions settings page, under list settings.
    2. Create a new action by expanding the Add/Update Action.
    3. Change the action type to Send e-mail.
    4. Change the name to Send e-mail to approver.
    5. Uncheck the Edit checkbox.
      Action Settings -> General Settings
    6. Click on the Advanced Settings tab.
    7. Check the Always runs, but remains invisible to users checkbox.
      Action Settings - Advanced Settings
    8. Click on Action Settings tab.
    9. On the To: field click on the right dropdown (and not the left people picker) and choose Department .
    10. On the dropdown underneath, choose Purchase Request Approvers.
    11. On the Subject field, write down the following - Purchase Request System - You have a new request to approve.
    12. On the Body Field, add the following HTML text:

      <div style="font-size:12px;font-family:Arial;" >
      Hello,
      <br /><br />
      There is a new purchase request wating for your approval.
      <br />
      <br />
      <b>To review this purchase request please press
      <a href="[Site URL]/Lists/[List Title]/EditForm.aspx?ID=[ID]&Source=[List URL]&iwtabID=1">
      here</a>
      </b>
      </div>


      Action Settings
    13. Click on the Conditions tab.
    14. Add the following conditions with the AND operator between them:
      1. Column Name: Requested Item, When: After Change; Operator: Not Equals, Value: Leave Empty.
      2. Column Name: Department, When: After Change; Operator: Not Equals, Value: Leave Empty.
        Action Settings -> Conditions
    15. Click on save.

Now the system should be up and running.

Let’s see an example of how it should work.

  1. Log-in with a requester user.
  2. Create a new request by adding a new item to the Purchase Requests list.
    Requester Form
  3. Fill out all the columns and click save
  4. Go to the approver’s email, in our case it would be the approver of the procurement department, the approver has link to review the request  directly from the email.
    Approver Email Notification
  5. Alternately, the approver can click edit on the request and will be directed straight to the Approve tab.
    Don’t remember to log-in with the approver credentials first.
     Approver Form
  6. The approver can approve or reject the request.

You now have a simple purchase request application which supports dynamic approvers!

Powered by Ultimate Forms

 

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
ULTIMATEforms is a complete platform that enables everyone to easily create and maintain Microsoft SharePoint-based business solutions without a single line of code
Powerful Forms
State-of-the-art responsive forms, complete with tabs, permissions, dynamic rules, repeating sections, electronic signatures and advanced validation, powered by our AI-assisted form generator
Powerful Automation
Replace complex workflows with simple, but powerful actions to create and update data inside SharePoint and in a variety of integrated applications and databases
Powerful Reporting
Transform data into actionable insights with detailed exportable reports, sophisticated dashboards, color-coded calendars and dynamic charts
100’s of Templates
Build and replicate business solutions with ease, selecting from our vast free library and creating your own custom templates, all installed with a single 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
© 2005-2024 Infowise Solutions Ltd. All rights reserved.
Privacy | Cookie Policy | Accessibility | Cloud SLA