Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Business situation:

You wish to manage on-boarding and off-boarding of colleagues, personal data, name, phone, mail, salary claims, which position they applied for, status of the process, what permissions to revoke, what devices to get back, last day in work, supervisor, etc.

Technical conditions:

You have one or more Jira projects which contain on-boarding and off-boarding data, several Jira custom fields containing relevant user data. Custom field types can be single- or multi-line text, number, radio button, checklist, single or multiple choice, date picker, date-time picker, etc.

You may have a simple Jira workflow to represent on-boarding and off-boarding processes, but in case you have a stricter process, JExcel respects possible workflow steps, conditions and validators.

Custom fields used for the example:

  1. Name (single-line text)

  2. E-mail (single-line text)

  3. Phone number (number)

  4. Position applied for (radio button)

  5. Salary claim (number)

  6. Currency (radio button)

  7. Last day in work (date picker)

  8. Permissions to revoke (multiple choice)

Workflows created for the example:

On-boarding workflow

Off-boarding workflow

How can JExcel support your work as a HR manager:

  • See all applicant data in one excel-like view

Image Removed
  • Colour Jira tickets representing applicants

Image Removed

Image Added

  • Manage application status in the same view

Image RemovedImage Added

  • Compare salary claims with showing charts (in case the same currency applies to all applicants).

Image RemovedImage Added

  • Manage off-boarding by viewing co-worker data in one page, no matter the data to be shown.

Image RemovedImage Added

  • Create reports for HR managers about applicants, positions, salary claims, dates, etc.

Image RemovedImage Added

  • Create reports for specific time frame

Image Removed

  • Visualize numeric values, such as salary

Image Removed

Create calculated columns by your own instead of going to your Jira administrator for new custom fields and scripting. Image Added

  • See average/sum/min/max values for numeric or financial columns.

Image RemovedImage Added

  • Manage upcoming dates like date of next action or next meeting

Image Removed

  • Rename your Jira fields to better suit your needs (it will only be visible in your workbook, the original name of fields will be shown when viewing issues in Jira)

Image Removed

  • Create new tasks directly from your workbook

Image Removed

  • View task details directly from your workbook by opening JExcel sidebar (similar to issue detail view in agile boards)

Image Removed

Image Added

  • See if your colleagues have reviewed an application and left you a comment or a new attachment has been uploaded

Image RemovedImage Added