Automate Time Sheet Creation, Capture Omni Status Change, and Calculate Shrinkage

Set up basic time sheet automation. Log agents’ Omni-Channel status changes throughout the day and use that information to calculate the shrinkage percentage within a shift.

  • Ease of Implementation: Easy
  • Estimated Time to Implement: 60 minutes

This example requires Omni Channel and Workforce Engagement to be turned on.

Create custom fields on the Time Sheet object in Salesforce to correspond to the data that you use to calculate shrinkage.

  1. From Setup, select Object Manager.

  2. In the Quick Find box, enter Time Sheet, and then select the Time Sheet object.

  3. Select Fields & Relationships from the left pane.

  4. To create a field, select New.

  5. To create a custom field to hold the data, follow the steps. To learn more about creating custom fields, see Create Custom Fields.

  6. Create these fields.

    time sheet with customized fields

  7. Make sure to add these fields to the layout for testing and deployment.

Create custom fields on the Time Sheet object in Salesforce to correspond to the data that you use to calculate shrinkage.

  1. From Setup, at the top of the page, select Object Manager.

  2. In the Quick Find box, enter Time Sheet Entry, and then select the Time Sheet Entry object.

  3. Select Fields & Relationships from the left pane.

  4. To create a field, select New.

  5. To create a custom field to hold the data, follow the steps. To learn more about creating custom fields, see Create Custom Fields.

  6. Create these fields.

    Time sheet fields for creation

  7. Make sure to add these fields to the layout for testing and deployment.

Two flows are used to allow agents to clock in, generate a Time Sheet, and capture Omni Channel status changes throughout the day.

  1. From Setup, in the Quick Find box, enter Flows, and then select Flows.

  2. To create your first flow, select New.

  3. For more information, see: Salesforce Flows

  4. Create a screen flow to place on the home page.

    Salesforce flow showing automation

    Automation flow with shift times and records

  5. Create a record-triggered flow to capture an Omni status change.

    Record-triggered flow to capture Omni status

    Flow with entries for decisions and status

  1. Clock in using the screen flow.
  2. To simulate the changes in agent availability, change Omni statuses between different presences.
  3. Verify that time sheet entries are created and shrinkage is calculated.