Digital job card / Job management

Jimzbobity

New Member
May 12, 2024
3
0
Hi,

I'm after advice on digitalizing job card management. We are a small engineering business with 6 employees, 3 of which are workshop based, and the other 3 mainly on-site from our mobile service vehicles. We specialize in the repair of agricultural & plant machinery, fabrication, hydraulics, and machining.

Currently, every job, whether on-site or at the workshop has a paper-based job card that contains the customer, date, PO, parts used, labour, and employee(s) name who have worked on the job. Any sketches, supplier quotes, calculations, cross references, and emails relating to parts or requirements for the job are hand noted or printed and stapled to the job card. Some job cards can be as simple as 1 sheet, others can have 7-8 pages of docs if it’s a larger job requiring multiple numbers of staff or visits.

On job completion, these job cards and accompanying documents are scanned in by our bookkeeper and archived on our business server based on customer and year. An invoice will then be manually created on Quickbooks Online showing parts used and total labour with a description of work completed. Each week we will complete anywhere between 15-40 job cards.

We can then look back at job cards with all relevant information on our server for reference when needed.

I'm looking to digitalize and streamline this whole process. We've looked at and tried EWorksManager, Fergus, Katana, Jobber, Job Logic, Jobify etc etc. There are hundreds of systems to manage this. The problem is, they are all too complicated for what we need, and as such won’t get used. They are also mainly field service-based systems that follow the usual job accepted, on-route, on-site, and completed procedure. Users can also only see jobs that are assigned to them.


We require a straight forward and simple system which will:


  • Sync with Quickbooks
  • Allow us to create a new job & add pictures, emails, notes etc.
  • Allow employees and managers to view all active jobs from both desktop PC and iOS app (or login via chrome on an iPad)
  • Allow employees to select an active job, add labour and parts
  • Invoice to Quickbooks
  • Allow managers to search back through past jobs for various customers
  • Allow managers to search for parts used in past jobs
  • Managers then check and authorize invoice to be send


We don’t need any type of scheduling, work planning or appointment planning. This appointment-type scheduling is the fundamental core of the above packages. This is great if you’re running 10+ plumbers, electricians or cleaners that are booked in with customers for a specific date and time. Or great if you had an administrator in the office 5 days a week dedicated to booking jobs, scheduling work load and appointment times for employees.

This wouldn’t suit us. We’d spend more time canceling appointments, moving appointments, and clubbing appointments together. We tend to have multiple in-house and on-site jobs going on at one time. Our job types mainly consist of:

  • Customers can turn up at the workshop unannounced to purchase parts or have a quick repair done
  • Jobs on-site can either be a breakdown in which case is immediately actioned, or pre-planned works, which depending on priority and complexity is clubbed together with other jobs in a similar location.
  • In-house jobs such as welding, lathe machining, machine rebuilds and repair is continuous. Each morning we will delegate staff work schedules for that day considering factors such as part availability, breakdown jobs etc. But given we are a small business, staff tend to know what jobs are waiting for parts, and which jobs they can crack on with. As such they are given some autonomy to work through jobs they know they can proceed with. Having a management tool they can look through themselves, update and set a job status will take a load off management and help them manage themselves as such.

Bearing the above in mind, can anyone recommend suitable software? Or alternatively, a UK-based company that can assist us in the development of a custom package?


I’ve also considered doing something with Microsoft Access or Google Forms, but these have their draw backs too. Has anyone had any experience in using Zapier for something similar?


Any help is appreciated.

Many thanks,
 

Craiglincs

Free Member
Apr 24, 2024
84
16
Zapier will be perfect for this. I've happily used it personally.(I've not started trading yet)

Set up spreadsheet template(s) on Google drive or office 365(do not use local office) then use zapier to sync with QuickBooks. Or use airtable and zapier. Airtable wil give you prettier forms for inputting and will be easier to search. You might also want to include a database or airtable(simpler but you need premium subscription) with zapier syncing to make searching easier. If you want to keep it more like the current system you can just print the spreadsheet files to pdf which gives you the same as scanning but with the zapier sync to QuickBooks.

There are zapier alternatives like make.com but zapier is the easiest for new people.
 
Last edited:
Upvote 0

Jimzbobity

New Member
May 12, 2024
3
0
Thanks Craig, is that using Google Sheets or Google Forms? I will have to look into Office 365 as we did wonder about switching all email accounts and apps to this. If it does forms as well, then it might work. The problem would be uploading pictures, PDF's and emails to Google Forms for each job. Is this do-able?

Will Google Forms / Sheets and Office 365 forms read from a MySQL database? If so we could run the database on our server and use Forms as a front end. Then link Zapier to Quickbooks.

Not enough hours in the day for me atm. Can anyone recommend a consultant or IT specialist who could deal with this for me?
 
Upvote 0

Craiglincs

Free Member
Apr 24, 2024
84
16
Thanks Craig, is that using Google Sheets or Google Forms? I will have to look into Office 365 as we did wonder about switching all email accounts and apps to this. If it does forms as well, then it might work. The problem would be uploading pictures, PDF's and emails to Google Forms for each job. Is this do-able?

Will Google Forms / Sheets and Office 365 forms read from a MySQL database? If so we could run the database on our server and use Forms as a front end. Then link Zapier to Quickbooks.

Not enough hours in the day for me atm. Can anyone recommend a consultant or IT specialist who could deal with this for me?
Google sheets not forms. You could do it with forms in theory but then you'd need to zapier into database.

Forms will leg you upload those but you will still need a back end behind the forms. Spreadsheets give you both in one.

Sheets and office 365 will read from mySQL with zapier. Forms will only input data I believe. Id have to look it up.

You could definitely use zapier to link your front end to a mySQL it's just a question of picking the right front end and setting it up. Though mySQL actually has the option to set up forms for it. Then you can use zapier to link to QuickBooks

Alternatively you can have a separate database using airtable which natively supports forms,searching and gives you the backend. Which you can then zapier into QuickBooks.

I don't think Google forms will work for what you want. I do know a guy but he's quite busy (and expensive) mostly does more complex jobs but I can reach out.

My first port of call would be the guy who built/maintains your SQL database especially if you've got to integrate it. Though if you need to start adding more tables(which I suspect you will) then you may need a separate database to sync to the existing one instead of creating more tables. If you decide to go airtable/zapier route there are developers in those communities but you may need to hire a couple of specialists and project manage.

If you want more specific (free) advice I'm free for a video chat tomorrow or Friday. Do you have WhatsApp?
 
Upvote 0
Google Forms feed the data to Sheets, don't they?
 
Upvote 0

fantheflames

Free Member
  • Business Listing
    Nov 23, 2022
    490
    150
    Bristol
    fantheflames.co.uk
    Welcome @Jimzbobity! If you're looking at Zapier, feel free to shoot any questions you have. There's always a reason I go back to using Zapier whether it's for a long trigger funnel or there's nothing else compatible, Zapier always comes in handy 9 times out of 10. Google Sheets have add-ons, some are free with limits, and others are free. Most are one-time payment, which is nice! :)
     
    Upvote 0

    Kelvin

    Free Member
    Apr 30, 2024
    20
    6
    Hey

    At high level this should be done with a few tools and integration

    Airtable or Monday

    Managing boards, include fields for customer details, date, PO, parts used

    Attach pictures, emails, notes, and other relevant documents directly to each job card entry.

    Make or Zapier

    Automation tool that allows to integrate to Quickbooks and automated all invoicing aspect

    I do recommend Make because it is more flexible but Zapier more user friendly as a beginner.

    Job Search and Reporting
    Again, Airtable or Monday offer powerful search functionalities allowing managers to search past jobs by various criteria like customer, date, parts used, etc.


    Whilst these tools are not deeply technical there's an initial learning curve that you'd have to embark on.

    Happy to answer any more questions you may have
     
    Upvote 0

    Jimzbobity

    New Member
    May 12, 2024
    3
    0
    Thanks for the replies,

    I'll do more research this next couple of days. I have no experience with Airtables or Zapier, but If they'll do what we require then its worth the time. I'll also have a word with our IT man, but it may be out of his remit.
     
    Upvote 0

    Craiglincs

    Free Member
    Apr 24, 2024
    84
    16
    Google Forms feed the data to Sheets, don't they?
    They do. That's write. Forms can't read from sheets I believe. But you can always search the sheet.

    You may not need zapier with airtable as it will have forms/sheets/searches/database all built in.
    Make or Zapier

    Automation tool that allows to integrate to Quickbooks and automated all invoicing aspect

    I do recommend Make because it is more flexible but Zapier more user friendly as a beginner.
    Nice thing about make is it let's you cycle back to a specific start date whereas zapier only handles new events since the integration is set up I think. Zapier is definitely a lot more beginner friendly and has some nice guides. Where as make is more sink or swim.
     
    Upvote 0

    Latest Articles