How to create a custom column





  1. Go to Manager > Reports > Employee > Pre-payroll Report
  2. Click on the settings icon
  3. On the pop-up window, select Display Settings on Screen > Staff or Day view
  4. Then click on General Settings tab
  5. Scroll down to the bottom of Custom Columns and click on + New Column
  6. Input the name of the custom column and click on the tick icon
  7. You can then click on the pencil icon beside the new column’s name in HR Duo Column Heading to combine existing column values
  8. Each field can contain an existing column or a custom formula. To set this, you need to click on the field that you want to change. After clicking on the field, you will have 3 tabs where you can navigate:
    1. Options Tab: It will display a list of columns that can be selected.
    2. Custom Tab: It will display a button where you can open a new view where you can generate a formula. After you define the formula you need to click on the 'Save' button to save it, and this action will redirect you to the previous view. You can also use the 'Cancel' button to cancel and redirect to the previous view.
    3. Remove Tab: It will display a button where you can delete the field.
  9. Once the fields have been selected, click Save and the custom column can be selected as a column to be viewed