Follow the steps below to correctly fill in the spreadsheet for importing jobs into Autocheck.
✅ Step 1: Add a Job
Start with a Job row:
- In the Type column, enter: Job
- Complete the following required fields:
- Job Number (unique ID)
- VRM (Vehicle Registration Mark)
- Depot
- Due Date
✅Step 2: Add Task(s) for the Job
Each job must have at least one Task. On the next row:
- In the Type column, enter: Task
- Use the same Job Number as the job above
- Fill in the following required fields:
- Task Name
- Task Answer Model
- Is Photo Required — enter either Y (yes) or N (no)
You can add as many tasks as needed under each job.
✅ Step 3: Add Another Job
To add a new job:
- Start a new row with Job
- Fill in the job details as before
- Then add the tasks underneath it
Type | Job Number | VRM | Depot | Due Date | Task Name | Task Answer Model | Is Photo Required |
Job | J123 | AB12CDE | Depot1 | 01/07/2025 | |||
Task | J123 | Check Oil | Yes/No | Y | |||
Task | J123 | Tyre Pressure | Tyre Pressure | N | |||
Job | J124 | XY99ZXY | Depot2 | 02/07/2025 | |||
Task | J124 | Brake Check | Pass/Fail | Y |