Difference between revisions of "Creating a workflow with scheduled reminders"

From SmartWiki
Jump to: navigation, search
Line 77: Line 77:
 
: '''Role''' → Add the role that should receive this reminder email. In this case, it is the '''Grant Staff''' user that has been assigned to record.
 
: '''Role''' → Add the role that should receive this reminder email. In this case, it is the '''Grant Staff''' user that has been assigned to record.
 
: You can Create a '''Default Task Connector''' to the previous task, but it is recommended to create all the tasks first and then create the connectors afterwards. In this case, the connector will need to be modified after it has been created to account for the scheduling.
 
: You can Create a '''Default Task Connector''' to the previous task, but it is recommended to create all the tasks first and then create the connectors afterwards. In this case, the connector will need to be modified after it has been created to account for the scheduling.
 
 
: Create the '''Message template''' which would include the '''Message Type''', '''Email Template''', '''From Address''', any other '''Cc Address(es)''', '''Message Format''', '''Message Subject''', and the '''Body''' of the message. You can use variables to populate content relevant to the triggering record, such as a name or grant id.
 
: Create the '''Message template''' which would include the '''Message Type''', '''Email Template''', '''From Address''', any other '''Cc Address(es)''', '''Message Format''', '''Message Subject''', and the '''Body''' of the message. You can use variables to populate content relevant to the triggering record, such as a name or grant id.
 
 
[[File:Message template for tasks.png|thumb|none|800px|Message template for tasks]]
 
[[File:Message template for tasks.png|thumb|none|800px|Message template for tasks]]
  
Line 130: Line 128:
 
      This task is created to change the status of the report to overdue. Note that if additional tasks need to be triggered by the overdue status, an additional workflow will need to be created and triggered.
 
      This task is created to change the status of the report to overdue. Note that if additional tasks need to be triggered by the overdue status, an additional workflow will need to be created and triggered.
  
INSERT IMAGE 
+
[[File:Status to Overdue task.png|thumb|none|800px|Status to Overdue task]]
  
 
: '''Task Name → '''Status to Overdue
 
: '''Task Name → '''Status to Overdue
Line 139: Line 137:
 
=Configuration - Creating task connectors=
 
=Configuration - Creating task connectors=
 
Now that you have created all of your workflow tasks, you will need to connect them. This can be done by creating Connectors. Workflows only run tasks if they have been connected together and have applicable conditions.
 
Now that you have created all of your workflow tasks, you will need to connect them. This can be done by creating Connectors. Workflows only run tasks if they have been connected together and have applicable conditions.
 
  
  
 
* Create a Starting connector to start your workflow. 
 
* Create a Starting connector to start your workflow. 
 
** Click the New button on the first row of your workflow tasks. 
 
** Click the New button on the first row of your workflow tasks. 
 +
 +
[[File:Create a new task connector.png|thumb|none|800px|Create a new task connector]]
 +
 
** The connector connects the starting point to the Initial Delay
 
** The connector connects the starting point to the Initial Delay
 
** Leave the '''Name''' and''' Trigger Type''' as the default for your starting connector, or name it appropriately if required.
 
** Leave the '''Name''' and''' Trigger Type''' as the default for your starting connector, or name it appropriately if required.
 
** For the '''Connect To''' option - select the task you want the workflow to start with - in this case it will be the Initial Delay task.
 
** For the '''Connect To''' option - select the task you want the workflow to start with - in this case it will be the Initial Delay task.
  
INSERT IMAGE
+
[[File:Start connector configuration.png|thumb|none|800px|Start connector configuration]]
  
 
After creating the first connector, it should look like this;
 
After creating the first connector, it should look like this;
  
INSERT IMAGE
+
[[File:Start task connecting to Initial delay.png|thumb|none|800px|Start task connecting to Initial delay]]
  
 
You will need to create connectors for the remaining tasks. Make sure that you connect the current task in the workflow. The default option in the connector is Complete - which will end your workflow.
 
You will need to create connectors for the remaining tasks. Make sure that you connect the current task in the workflow. The default option in the connector is Complete - which will end your workflow.
 
 
  
 
* The next connector connects the initial delay to 6 Week Reminder to Staff.
 
* The next connector connects the initial delay to 6 Week Reminder to Staff.
Line 164: Line 162:
 
** You can select a time the email is scheduled to go out, if it is to only account for business days, and whether or not holidays are included.
 
** You can select a time the email is scheduled to go out, if it is to only account for business days, and whether or not holidays are included.
  
INSERT IMAGE
+
[[File:6 week Delay connector configuration.png|thumb|none|800px|6 week Delay connector configuration]]
 
 
 
 
  
 
* The next connector connects 6 Week Reminder to Staff to the 4 Week Reminder to Grantee.
 
* The next connector connects 6 Week Reminder to Staff to the 4 Week Reminder to Grantee.
Line 173: Line 169:
 
** There is a delay of -28 days because the email is to be sent out 4 weeks (28 days) before the report is due.
 
** There is a delay of -28 days because the email is to be sent out 4 weeks (28 days) before the report is due.
  
 
+
[[File:4 week Delay connector configuration.png|thumb|none|800px|4 week Delay connector configuration]]
INSERT IMAGE
 
 
 
 
 
  
 
* The next connector connects the 4 Week Reminder to Grantee to the 1 Week Reminder to Grantee.
 
* The next connector connects the 4 Week Reminder to Grantee to the 1 Week Reminder to Grantee.
Line 182: Line 175:
 
** The trigger date is set to the date that the report is due in the Application Manager
 
** The trigger date is set to the date that the report is due in the Application Manager
 
** There is a delay of -7 days because the email is to be sent out 1 week (7 days) before the report is due.
 
** There is a delay of -7 days because the email is to be sent out 1 week (7 days) before the report is due.
 
  
 
* The next 2 connectors connect 1 Week Reminder to Grantee to the On Due Date reminder to the Grantee, and then the On due date reminder to the Grant Staff respectively.
 
* The next 2 connectors connect 1 Week Reminder to Grantee to the On Due Date reminder to the Grantee, and then the On due date reminder to the Grant Staff respectively.
 
** The trigger date is set to the date that the report is due.
 
** The trigger date is set to the date that the report is due.
 
** There isn’t a delay required since it is supposed to be sent out the day the report is due.
 
** There isn’t a delay required since it is supposed to be sent out the day the report is due.
 
  
 
* The next connector connects On due date reminder to the Grant Staff to the Status to Overdue
 
* The next connector connects On due date reminder to the Grant Staff to the Status to Overdue
Line 194: Line 185:
 
** There is a delay of 1 day but this time, it is sent 1 day after the due date.
 
** There is a delay of 1 day but this time, it is sent 1 day after the due date.
  
INSERT IMAGE
+
[[File:Status to overdue connector configuration.png|thumb|none|800px|Status to overdue connector configuration]]
 
 
 
 
  
 
* The last connector connects Status to Overdue to the Complete.
 
* The last connector connects Status to Overdue to the Complete.
Line 203: Line 192:
 
** There is no delay and all other options are left as default.
 
** There is no delay and all other options are left as default.
  
INSERT IMAGE
+
[[File:Status overdue to complete connector.png|thumb|none|800px|Status overdue to complete connector]]
 
 
  
 
Once you are done creating connectors your workflow should look similar to this (below)
 
Once you are done creating connectors your workflow should look similar to this (below)
  
INSERT IMAGE
+
[[File:Overview of tasks and connectors.png|thumb|none|800px|Overview of tasks and connectors]]
 
 
  
  

Revision as of 16:41, 16 May 2022

Overview

Use case: Notifications that a task is due to be completed is a common requirement in grants administration. These reminders are particularly important when it comes to the completion of progress reports once a grant has been awarded. Automating these reminders reduces the administrative burden on internal staff members. This can also be helpful in the case of multi-year grants or grants with multiple reporting requirements, which can be time consuming to follow up on manually

Example: An application gets approved by a grants administrator. A report schedule is created with due dates set at 3 month intervals between the start and the end date of the grant. Automated notifications can be scheduled to remind the individual responsible to complete the task in a timely manner.

A Workflow is a set of repeatable steps used to automate and streamline your business processes within the system.

Configuration - Essentials

  • Click the Menu Icon and under the System Processes , click the Workflows link. You can also access this by going into the Global settings -> System 
Workflow Settings


  • The Workflows page is displayed. Click on the plus button to create a new workflow.
Add a new Workflow
  • Select the Workflow type. The type will dictate what options will be available when creating tasks and where the actions will occur. For this workflow, we’re going to be selecting Tracking Activities. We are selecting Tracking Activities for this workflow because we are looking at level 2 records which in this case are the reports.
Create a Report Reminder Workflow - Main setup page
  • Give the workflow a Name, add the workflow to a Category and add a brief Description to summarize the tasks within it, including any branching conditions for ease of review later. It is also recommended to keep track of any changes made to the task by adding some notes. 
    • Categories are created by your organization. We suggest creating categories based on the UTA and Record Level. 
      • EX: Reports - Reminders
    • Suggested naming convention: Activity Level (1/2/3) - Goal/Status/Reminders
      • EX: Grants Manager L1/L2
  • Set the Trigger on to determine what automated tasks are going to be triggered in this workflow. 
    • This will define when your workflow is triggered.
    • Depending on the workflow type, you will be selecting from a list of statuses. 
    • In our example, the activities will have been created in ‘Scheduled’ status. This is what we will set the trigger to as a result.
  • A termination trigger should be set for any workflow that’s scheduling tasks for the future. This will cancel any pending tasks if it is no longer required. In this example, if the applicant submits their reports ahead of the due date, the report status will change to Submitted, which can be set as a termination trigger on the workflow and prevent unnecessary reminders.
  • Click the Save button. The workflow is saved and the Workflow ID is now populated

Now you’ll see some additional options relating to this workflow. You can add notes, view the list of tasks, workflow connections, pending queue for upcoming workflow tasks, and a history of when this workflow was triggered.


Note: The field names, activity types, and status names referenced in this example are specific to the SmartSimple Grants Demo System. If you are trying to replicate this workflow in your own system, check that you are using the correct field names, activity types and statuses specific to your system.

*Tip* → You can build your workflow on your production system first and test it on your backup the next day. Make sure to set the Trigger-on to Deactivate so the workflow won’t run. Once your workflow appears in your backup, you can set the Trigger-On to the correct status and test your workflow without worrying about impacting your production environment. 


Configuration - Creating Tasks

*Best Practice* →  Create all of your workflow tasks before connecting the tasks. 


Navigate to the Tasks bar on the left-hand menu. A workflow will always have a starting point and a completion point where it can terminate. In between, you can have as many different tasks in  the workflow. 

Creating a New task

To create a new task, click on the plus button. Again, you would have to give the task a Name, select a Task type, and add a brief Description of the task. The task types mainly used in this workflow are either an Acknowledgement or a change in status. The options available will vary from task type to task type. 

Creating the tasks

  • Task 1: Initial Delay
    • The first task is named Initial Delay since it has no function but will indicate that a workflow has started when looking through workflow histories and logs. It is a branching task without any additional function.
Initial Delay task


  • Task 2: 6 Week Reminder to Staff

      The next task will be used to send out the first email reminder to the Grant Staff about the upcoming report that is to be filled out

6 week reminder to Grant Staff task


Task Name → 6 Week Reminder to Staff 
Task Type → Acknowledgement
Description → Add a brief description of what this task is performing
Role → Add the role that should receive this reminder email. In this case, it is the Grant Staff user that has been assigned to record.
You can Create a Default Task Connector to the previous task, but it is recommended to create all the tasks first and then create the connectors afterwards. In this case, the connector will need to be modified after it has been created to account for the scheduling.
Create the Message template which would include the Message Type, Email Template, From Address, any other Cc Address(es), Message Format, Message Subject, and the Body of the message. You can use variables to populate content relevant to the triggering record, such as a name or grant id.
Message template for tasks
  • Task 3: 4 Week Reminder to Grantee

      This next task will be used to send out the first email reminder to Grantee about the same upcoming report that is to be filled out.

4 week reminder to Grantee task
Task Name → 4 Week Reminder 
Task Type → Acknowledgement
Description → Add a description
Role → Add the role that should receive this reminder email - Owner
Create the Message template
  • Task 4: 1 Week Reminder

      This next task will be used to send out a second email reminder to the Grantee about the same upcoming report that is to be filled out.

1 week reminder to Grantee task
Task Name → 1 Week Reminder 
Task Type → Acknowledgement
Description → Add a description
Role → Add the role that should receive this reminder email - Owner
Create the Message template
  • Task 5: On Due Date Reminder to Grantee

      This next task will be used to send out a third email reminder to the Grantee about the same upcoming report that is to be filled out.

On due date reminder to Grantee task
Task Name → On Due Date Reminder to Grantee
Task Type → Acknowledgement
Description → Add a description
Role → Add the role that should receive this reminder email - Owner
Create the Message template
  • Task 6: On Due Date Reminder to Grant Staff

      This next task will be used to send out a third email reminder to the Grant Staff about the same upcoming report that is to be filled out.

On due date reminder to Grant Staff task
Task Name → On Due Date Reminder to Staff
Task Type → Acknowledgement
Description → Add a description
Role → Add the role that should receive this reminder email - Grant Staff
Create the Message template
  • Task 7: Status to Overdue

      This task is created to change the status of the report to overdue. Note that if additional tasks need to be triggered by the overdue status, an additional workflow will need to be created and triggered.

Status to Overdue task
Task Name → Status to Overdue
Task Type → Change Status
Target → Current Object (report)
Entity → Level One
Change Status To→ Application Manager - Overdue

Configuration - Creating task connectors

Now that you have created all of your workflow tasks, you will need to connect them. This can be done by creating Connectors. Workflows only run tasks if they have been connected together and have applicable conditions.


  • Create a Starting connector to start your workflow. 
    • Click the New button on the first row of your workflow tasks. 
Create a new task connector
    • The connector connects the starting point to the Initial Delay
    • Leave the Name and Trigger Type as the default for your starting connector, or name it appropriately if required.
    • For the Connect To option - select the task you want the workflow to start with - in this case it will be the Initial Delay task.
Start connector configuration

After creating the first connector, it should look like this;

Start task connecting to Initial delay

You will need to create connectors for the remaining tasks. Make sure that you connect the current task in the workflow. The default option in the connector is Complete - which will end your workflow.

  • The next connector connects the initial delay to 6 Week Reminder to Staff.
    • We have given it a Name, left the trigger as default and selected the task that it is connecting to.
    • The trigger date is set to the date that the report is due in the Application Manager
    • There is a delay of -42 days because the email is to be sent out 6 weeks (42 days) before the report is due.
    • You can select a time the email is scheduled to go out, if it is to only account for business days, and whether or not holidays are included.
6 week Delay connector configuration
  • The next connector connects 6 Week Reminder to Staff to the 4 Week Reminder to Grantee.
    • We have also given it a Name, left the trigger as default and selected the task that it is connecting to.
    • The trigger date is set to the date that the report is due in the Application Manager
    • There is a delay of -28 days because the email is to be sent out 4 weeks (28 days) before the report is due.
4 week Delay connector configuration
  • The next connector connects the 4 Week Reminder to Grantee to the 1 Week Reminder to Grantee.
    • We have also given it a Name, left the trigger as default and selected the task that it is connecting to.
    • The trigger date is set to the date that the report is due in the Application Manager
    • There is a delay of -7 days because the email is to be sent out 1 week (7 days) before the report is due.
  • The next 2 connectors connect 1 Week Reminder to Grantee to the On Due Date reminder to the Grantee, and then the On due date reminder to the Grant Staff respectively.
    • The trigger date is set to the date that the report is due.
    • There isn’t a delay required since it is supposed to be sent out the day the report is due.
  • The next connector connects On due date reminder to the Grant Staff to the Status to Overdue
    • If, for some reason, the report does not get filled out on the due date, the Status to Overdue task changes the status of the report to overdue.
    • The trigger date is set to the date that the report is due.
    • There is a delay of 1 day but this time, it is sent 1 day after the due date.
Status to overdue connector configuration
  • The last connector connects Status to Overdue to the Complete.
    • If the report gets filled out on the due date, the workflow is completed. You should then connect this task to the Complete to confirm there are no more outstanding tasks and for the workflow log display.
    • The trigger date is set to the date that the report is due.
    • There is no delay and all other options are left as default.
Status overdue to complete connector

Once you are done creating connectors your workflow should look similar to this (below)

Overview of tasks and connectors


Testing the Workflow

Now that you have built the workflow, you want to make sure that it functions correctly. You can do so by setting a test record to the Approved status and checking the workflow history on the workflow. However, this particular workflow has been scheduled to send reports as far as 6 weeks in advance, the initial delay task will be listed, and the status will display as pending while it waits for the trigger date. You would need to go to the workflow history on one of the reports to see the pending email tasks.

 

Once the time comes for these emails to get sent out, here is how to check to see if the workflow is performing these tasks.

  • Navigate to the Logs drop down near the top left of the screen and select the Workflow History option

INSERT IMAGE

  • You will be able to see a list of completed workflow tasks from your workflow here. Make sure the task status is completed for each of your tasks i.e. the last connector is set to connect to Complete, for the benefit of workflow logs against a record.


  • You can also confirm that your email was sent to the applicant by navigating to your Message Queue in the Menu. This can also be accessed by going to the Global Settings -> Communication
    • Note: Not all of the options in the menu below will be visible in your menu.

INSERT IMAGE

  • You will be able to see the email sitting in the queue and you can open the body of the email by clicking the envelope icon.


Options and Settings

Explain all applicable misc options and settings that shouldn t be explained above here

General Settings

Option Description Example


Display Settings

Option Description Example

Examples

class wikitable Option Description Example Sample Syntax Format Empty space at start of line to highlight the row italicize any variables that the user would fill in (as opposed to literal words that need to be used in syntax) section SectionNodeName Sample Code Block When you want to write an example block of code you should highlight it and also escape any special characters that might be construed as HTML formatting and outputted incorrectly by the Wiki by using a pre (pre formatted text) tag pre xml version 1 0 Company Name Oranges Inc Name Description Peel Eat Repeat Description Company Company Name Bananas Ltd Name Description You re going to go bananas over our product Description Company pre Unordered list When listing information with bullet points in no order Point 1 Point 2 Point 3 Ordered list When listing information with numbers to denote ordered steps Step 1 Step 2 Step 3 Sample Page Header Banners Deprecated Feature span class mceNonEditable template id bs_template TPL0 data bs name Deprecated data bs type template data bs id 0 span class mceNonEditable template id bs_template TPL0 data bs name Deprecated data bs type template data bs id 0 span class mceNonEditable template id bs_template TPL0 data bs name Deprecated data bs type template data bs id 0 span class mceNonEditable template id bs_template TPL0 data bs name Deprecated data bs type template data bs id 0 span class mceNonEditable template id bs_template TPL0 data bs name Deprecated data bs type template data bs id 0 Deprecated span span span span span Deprecated Page span class mceNonEditable template id bs_template TPL1 data bs name DeprecatedPage data bs type template data bs id 1 span class mceNonEditable template id bs_template TPL1 data bs name DeprecatedPage data bs type template data bs id 1 span class mceNonEditable template id bs_template TPL1 data bs name DeprecatedPage data bs type template data bs id 1 span class mceNonEditable template id bs_template TPL1 data bs name DeprecatedPage data bs type template data bs id 1 span class mceNonEditable template id bs_template TPL1 data bs name DeprecatedPage data bs type template data bs id 1 DeprecatedPage span span span span span Professional Services span class mceNonEditable template id bs_template TPL2 data bs name Banner Billable data bs type template data bs id 2 span class mceNonEditable template id bs_template TPL2 data bs name Banner Billable data bs type template data bs id 2 span class mceNonEditable template id bs_template TPL2 data bs name Banner Billable data bs type template data bs id 2 span class mceNonEditable template id bs_template TPL2 data bs name Banner Billable data bs type template data bs id 2 span class mceNonEditable template id bs_template TPL2 data bs name Banner Billable data bs type template data bs id 2 Banner Billable span span span span span Page Under Construction span class mceNonEditable template id bs_template TPL3 data bs name Banner UnderConstruction data bs type template data bs id 3 span class mceNonEditable template id bs_template TPL3 data bs name Banner UnderConstruction data bs type template data bs id 3 span class mceNonEditable template id bs_template TPL3 data bs name Banner UnderConstruction data bs type template data bs id 3 span class mceNonEditable template id bs_template TPL3 data bs name Banner UnderConstruction data bs type template data bs id 3 span class mceNonEditable template id bs_template TPL3 data bs name Banner UnderConstruction data bs type template data bs id 3 Banner UnderConstruction span span span span span