Skip to main content
Question

Onboarding Requests Report

  • November 15, 2022
  • 1 reply
  • 84 views

Forum|alt.badge.img+4
  • Skilled Expert
  • 15 replies

I want to create a report on all onboarding requests where the Date of Joining is today. I am unable to create such a report as the Date of Joining is a field in the Onboarding Request form and not a field in the ticket form. So seems like there is no option to create a report with Date of Joining as a filter criteria. Any workaround is appreciated.

As a general comment, lately I am finding a lot of shortcomings in the Employee Onboarding module of Freshservice. Lot of simple features are missing.

Did this topic help you find an answer to your question?

1 reply

Forum|alt.badge.img+4
  • Author
  • Skilled Expert
  • 15 replies
  • November 18, 2022

I was able to achieve the functionality with the following steps.

  1. Date of Joining is a Onboarding form field. I created a new field called Hiring Date in the ticket form and hide the field without any condition.
  2. Created a new workflow to copy the Date of Joining to Hiring Date whenever any Onboarding SR is created or updated.
  3. To implement step 2, I used expression builder in the WF to extract the Date of Joining using the following expression,  date(year('{{ticket.onboarding_request.actor_1.cf_date_of_joining_iso}}'),month('{{ticket.onboarding_request.actor_1.cf_date_of_joining_iso}}'),day('{{ticket.onboarding_request.actor_1.cf_date_of_joining_iso}}'))
  4. In the next step set the Hiring date with value from expression step.
  5. Now as Hiring Date is a normal ticket field, I could create the report with filter criteria as Hiring Date = Today.

Reply