Choose which dashboard columns become WhatsApp questions, web form fields, or manager fields. One master table. Many report templates. Same operational database.
See which dashboard columns are covered, missing, or marked optional across all active templates.
| Field | CSV Column | Source | Required | Enabled | If Missing | Status |
|---|---|---|---|---|---|---|
| Report ID | Report ID | Worker | required | Yes | ask_worker_again | Covered |
| Report Status | Report Status | Worker | optional | Yes | allow_submit_needs_review | Optional |
| Report Date | Report Date | Worker | required | Yes | ask_worker_again | Covered |
| Submitted At | Submitted At | System | optional | No | use_default | Not collected |
| AI Short Summary | AI Short Summary | System | not_used | No | use_default | Not collected |
| AI Full Summary | AI Full Summary | System | not_used | No | use_default | Not collected |
| Report Language | Report Language | System | optional | No | use_default | Not collected |
| AI Translation Used | AI Translation Used | System | not_used | No | use_default | Not collected |
| Work Result | Work Result | Worker | optional | Yes | allow_submit_needs_review | Optional |
| Completion % | Completion % | Calculated | optional | Yes | use_default | Optional |
| Original Report Text | Original Report Text | Worker | optional | Yes | allow_submit_needs_review | Optional |
| Translated Report Text | Translated Report Text | Worker | optional | Yes | allow_submit_needs_review | Optional |
| Worker Name | Worker Name | Worker | required | Yes | ask_worker_again | Covered |
| Worker Role | Worker Role | Worker | optional | Yes | allow_submit_needs_review | Optional |
| Worker Company | Worker Company | Worker | optional | Yes | allow_submit_needs_review | Optional |
| Worker Type | Worker Type | Worker | optional | Yes | allow_submit_needs_review | Optional |
| Worker Team / Crew | Worker Team / Crew | Worker | optional | Yes | allow_submit_needs_review | Optional |
| Worker Manager | Worker Manager | Manager | optional | Yes | allow_submit_needs_review | Optional |
| Foreman / Site Lead | Foreman / Site Lead | Worker | optional | Yes | allow_submit_needs_review | Optional |
| Reported By | Reported By | Worker | optional | Yes | allow_submit_needs_review | Optional |
| Payroll Period | Payroll Period | Finance | optional | Yes | allow_submit_needs_review | Optional |
| Client Name | Client Name | Manager | required | Yes | send_to_manager | Covered |
| Client Type | Client Type | Manager | optional | Yes | allow_submit_needs_review | Optional |
| Client Contact Person | Client Contact Person | Manager | optional | Yes | allow_submit_needs_review | Optional |
| Project ID | Project ID | Manager | optional | Yes | allow_submit_needs_review | Optional |
| Project Name | Project Name | Manager | required | Yes | send_to_manager | Covered |
| Project Type | Project Type | Manager | optional | Yes | allow_submit_needs_review | Optional |
| Project Phase | Project Phase | Manager | optional | Yes | allow_submit_needs_review | Optional |
| Site / Unit / Area | Site / Unit / Area | Manager | optional | Yes | allow_submit_needs_review | Optional |
| Project Address | Project Address | Manager | optional | Yes | allow_submit_needs_review | Optional |
| GPS Location Captured | GPS Location Captured | Manager | optional | Yes | allow_submit_needs_review | Optional |
| GPS Coordinates | GPS Coordinates | Manager | optional | Yes | allow_submit_needs_review | Optional |
| Location Match Status | Location Match Status | Manager | optional | Yes | allow_submit_needs_review | Optional |
| Travel Required | Travel Required | Manager | optional | Yes | allow_submit_needs_review | Optional |
| Distance Travelled | Distance Travelled | Manager | optional | Yes | allow_submit_needs_review | Optional |
| Parking / Access Notes | Parking / Access Notes | Manager | optional | Yes | allow_submit_needs_review | Optional |
| Client PO Number | Client PO Number | Manager | optional | Yes | allow_submit_needs_review | Optional |
| Work Start Time | Work Start Time | Worker | required | Yes | ask_worker_again | Covered |
| Work End Time | Work End Time | Worker | required | Yes | ask_worker_again | Covered |
| Total Work Time | Total Work Time | Calculated | optional | Yes | use_default | Optional |
| Rounded Work Time | Rounded Work Time | Worker | optional | Yes | allow_submit_needs_review | Optional |
| Break Time | Break Time | Worker | optional | Yes | allow_submit_needs_review | Optional |
| Paid Break | Paid Break | Worker | optional | Yes | allow_submit_needs_review | Optional |
| Net Billable Hours | Net Billable Hours | Worker | optional | Yes | allow_submit_needs_review | Optional |
| Payroll Hours | Payroll Hours | Finance | optional | Yes | allow_submit_needs_review | Optional |
| Travel Time | Travel Time | Worker | optional | Yes | allow_submit_needs_review | Optional |
| No-show / Absence Flag | No-show / Absence Flag | Worker | optional | Yes | allow_submit_needs_review | Optional |
| Late Arrival Flag | Late Arrival Flag | Worker | optional | Yes | allow_submit_needs_review | Optional |
| Early Leave Flag | Early Leave Flag | Worker | optional | Yes | allow_submit_needs_review | Optional |
| Time Conflict Flag | Time Conflict Flag | Worker | optional | Yes | allow_submit_needs_review | Optional |
| Extra Pay Multiplier | Extra Pay Multiplier | Worker | optional | Yes | allow_submit_needs_review | Optional |
| Fixed Work | Fixed Work | Worker | optional | Yes | allow_submit_needs_review | Optional |
| Fixed Work Type | Fixed Work Type | Worker | optional | Yes | allow_submit_needs_review | Optional |
| Billable to Client | Billable to Client | Worker | optional | Yes | allow_submit_needs_review | Optional |
| Internal Cost Only | Internal Cost Only | Worker | optional | Yes | allow_submit_needs_review | Optional |
| Piecework Hours | Piecework Hours | Worker | optional | Yes | allow_submit_needs_review | Optional |
| Piecework Quantity | Piecework Quantity | Worker | optional | Yes | allow_submit_needs_review | Optional |
| Piecework Unit | Piecework Unit | Worker | optional | Yes | allow_submit_needs_review | Optional |
| Piecework Unit Rate - Worker | Piecework Unit Rate - Worker | Worker | optional | Yes | allow_submit_needs_review | Optional |
| Piecework Unit Rate - Client | Piecework Unit Rate - Client | Worker | optional | Yes | allow_submit_needs_review | Optional |