The drillhole template defines the collar-data fields that appear on every drillhole in your project. Easting, northing, elevation, dip, azimuth, geologist, hole status, drilling method — anything you’d record on a collar sheet goes here.
A project has exactly one drillhole template. All drillholes share it, so adding a field adds it to every existing hole (with a blank value).
Open the template editor
From the Dashboard, click the settings gear (⚙) → Templates. Or, from any drillhole page, click Edit Templates at the bottom of the left sidebar. Make sure the Drillhole Template tab is selected.
Add a field
Click + Add Field in the top-right. Each field has:
- Name — the field identifier (e.g.,
easting,geologist,hole_status). Use lowercase with underscores for consistency. - Type — see Column Types for the full list.
- Required — if ticked, the field must be filled before a drillhole can be saved.
- Default Value — pre-fill new drillholes with this value.
- Validation Rules — bound checks, regex patterns, custom expressions. See Validation Rules.
Common fields to add for a typical exploration program:
| Field | Type | Notes |
|---|---|---|
easting | number | Required |
northing | number | Required |
elevation | number | Required |
max_depth | decimal | Total hole depth |
dip | decimal | Negative = downhole (mining convention) |
azimuth | decimal | 0–360 |
geologist | text | |
hole_status | dropdown | Options: Planned / Drilling / Completed / Abandoned |
date_started | date | |
date_completed | date |
Fields appear as cards in a responsive grid. Each card shows the field name and a coloured type badge.
The name system field
Every drillhole template includes a name field that’s marked Required and System. This is the drillhole identifier (e.g., DDH-001). You can’t delete or rename it — Blue Butterfly relies on it everywhere (the dashboard, exports, the 3D Viewer, the Strip Log).
Reorder fields
Drag the ⠿ handle on the left of any card to a new position. The order here controls the order in the Edit Drillhole dialog and on the Dashboard cards (the first three non-system fields are surfaced on each card).
Delete a field
Click the 🗑 icon on a field card. A confirmation dialog appears. Deleting a field removes it from every drillhole — the data it held is no longer accessible.
Share a template (export & import)
Templates can be exported as JSON and shared with another project or another user. Useful when:
- Your company has a standard schema you want every project to start with
- You’re consulting and want to hand a colleague a ready-to-use template
- You want to back up your schema separately from the data
Export Template
Click Export Template in the top-right. A .json file downloads containing the complete template — drillhole fields and data tables, column types, validation rules, formulas, defaults, and dropdown options.
Import Template
Click Import Template and select a previously exported .json file. The template loads into the current project.
Note. Importing a template into a project that already has data is supported, but it will modify the schema. New fields and tables are added; conflicting fields are updated. Existing records keep their data, but cells that no longer have a column become invisible. Test on a backup first if you’re unsure.
For full project backup (schema and data), see Backup & Restore.
Field types at a glance
The drillhole template supports the same column types as data tables:
text,textarea— free-form textnumber,decimal— numeric valuesdate— date pickerdropdown— predefined list of optionscheckbox— true/falseformula— auto-calculated from other fields
For full details and badge colours, see Column Types. For formula syntax, see Formula Columns.