In this example, we’ll cover how to add work tasks to your lookup tables if they don’t
already exist.
- Under Hub, go to Data Tools, and then the Look Up Table Editor.
You will see Work Tasks here. - Click on Work Tasks, and the Look Up Table Editor window will open. This
contains the list of all work tasks that are currently available. - Click on the ‘Add’ button.
- This will enable you to populate a new record in the look-up table with the
specific task, as well as the Work Category. - After adding the new work task, you can add costs for this task, or any other
existing tasks. In the Look Up Table Editor, first check the box next to the
work task you would like to associate costs with, and then select the ‘Costs’
button. - This will open the Costs window. In this case, we will set the costs based on
the DBH of the tree, but you have the ability to auto assign costs based on a
variety of attributes. Add size or categories, then assign a fixed price and/or an
hourly rate. Mark the checkbox next to each record to activate the tool and
auto assign costs based on your input values. When finished populating the
categories and associated costs, click the Save button in the upper left. Edits
are not applied until you do this.- To add additional categories and their associated costs, use the
button in the upper left, which will generate another row that can be
populated. - If you leave a minimum value blank, it will be assigned as negative
infinity. If you leave a maximum value blank, it will be assigned as
positive infinity. - If a fixed price or hourly rate doesn’t apply to your scenario, uncheck the
checkbox in those columns. - If you need to delete a Size/Category, check the box next to it, and then
click the Delete Checked button in the upper left.
- To add additional categories and their associated costs, use the
- After populating the costs table, this data will now be auto filled when
creating Work Records.