How to track the availability history of a user in Q-assign within a report
Salesforce allows to create and run comprehensive reports which can be used to create the availability history of a User in Q-assign. To create such a report, we need to populate custom object's records using a Process Builder whenever Available for Q-assign (a field on object 'User') is changed by a user. Please find steps to the solution below:
- Create a Custom Object and give it an appropriate name e.g., Availability History
- Create appropriate fields to store information regarding a user's availability to be then used in a report. Example fields
- Available (checkbox) – to store a User’s status i.e. Available (checked) and Unavailable (unchecked)
- User (Text) – to store full Name of the User changing his/her availability
- Status Change Time (Date/Time) – to store the time at which a user changed his/her availability
- Create a Process Builder to create and populate custom object’s fields whenever a User changes availability manually
- Create a Report on a custom object created in point 1 to show stats for a User, such as a User’s full name, Status Change Time and Available status
Please see the screenshot for assistance for process builder.
Further 'Immediate Actions' of 'Create Availability History' record, please see below:
- Available equals [User].ortoo_qra__Assignment_Group_Is_Active__c
- Status Change time equals NOW()
- User equals [User].FirstName + '' + [User].LastName
Sample User’s Availability Report:
Please find below User’s Availability Report based on the above-proposed solution. This report can be filtered out and summarized based on User or Status Change Time etc.
Once you run the report, it will show the tracked history of the user's availability.
Please contact us at firstname.lastname@example.org for any questions.