Send notifications for new purchase requests

This workflow increases visibility for purchase requests by sending a notification whenever a new one is submitted.

Configuration overview

Goal

Notify users when a new purchase request has been submitted.

Trigger

Activity

Steps

1. Go to Settings > Workflows.
2. Click New:
   
3. Enter a name for your workflow.
4. In the I would like to section, select Run separate activities based on an if/else condition:
   
5. In the Every time that a section, select Record was changed:
   
6. Click OK.
7. To configure the trigger:
   1. Click the Trigger tab:
      
   2. In the Table drop-down list, select Purchase Order Line Item:
      
   3. Click OK.
      This closes the workflow, which is necessary to apply your trigger settings before moving on to the next step.
8. To configure the activity:
   1. Click the workflow to open it again.
   2. In the Activities tab, click the activity that was created automatically based on the option you selected in step 4:
      
   3. In the Condition field, enter the following code:

      rec.getColumnValue('intPurchaseOrderID') is null

9. To configure the notification sub-activity:
   1. In the Execute these activities when the condition is true section, click the + button:
      
   2. Enter a name for the activity.
   3. Select the Send a notification to a user(s) or group(s) option:
      
   4. Click OK.
   5. In the Recipients field, select the users you want to send the notification to.
   6. In the Subject field, enter the subject line you want to use for the notifications (e.g. "New purchase request")
   7. In the Body field, enter the following HTML:

      <p> A purchase request has been submitted for the following item:</p>
      <ul>
         <li><b>Item</b>: <ma:expr expr="rec.intAssetID"/> - <ma:expr expr="rec.findRelatedRecord('intAssetID').strName"/></li>
         <li><b>Quantity</b>: <ma:expr expr="rec.qtyOnOrder"/></li>
         <li><b>Price</b>: <ma:expr expr="rec.dblUnitPrice"/></li>
      </ul>

10. If you want to see what the message will look like, click Preview. There may be some slight formatting differences between the preview and the actual notification email.
11. Click OK:
    
12. Click OK:
    
13. To activate the workflow, switch the status toggle to Active:
    
14. Click OK.

Once your workflow is activated, you may want to test it by creating a new purchase request and validating that the workflow ran successfully. To learn more, see Monitor workflow activity.