Google Sheets & Forms Automation for Engineering Job Tracking System
Budget: $30 – $250 USD
I need my current Excel-based job log rebuilt inside Google Sheets so the whole team can access it live from any device. The flow starts with a Google Form (mobile-first) that uses drop-down menus to capture three things—Job Details, Client Information and Site Information. As soon as the form is submitted a script should create a unique job number in the exact sequence style “ING-KLI-001”, “ING-GER-002”, and so on.
That record then feeds a master sheet where I can see every job at a glance. From that same data set I want a compact dashboard that automatically totals:
• Jobs per client
• Jobs per site
• Total revenue and a simple profit field that calculates Revenue – Cost
Nothing here should feel like a complex app; speed and clarity for the workshop and site crews are more important than fancy visuals. Keep the layout clean, colour-coded if it helps, but absolutely phone-friendly.
Deliverables I expect:
1. Google Form set up with the specified fields and drop-down inputs.
2. Google Sheets workbook containing:
– A raw data tab fed directly by the form
– Script or formula for sequential job number generation
– Calculation columns for cost, revenue and profit
– A dashboard tab with clear charts/metrics for the items above
3. All files shared in my Google Workspace with edit rights.
4. Brief hand-over notes so I can adjust clients, sites or sequences myself later.
When you reply, please include a quick example of a similar Google Sheets/Forms build you have done, outline your approach, confirm you can hit a two-to-three-day turnaround, and state your price.
That record then feeds a master sheet where I can see every job at a glance. From that same data set I want a compact dashboard that automatically totals:
• Jobs per client
• Jobs per site
• Total revenue and a simple profit field that calculates Revenue – Cost
Nothing here should feel like a complex app; speed and clarity for the workshop and site crews are more important than fancy visuals. Keep the layout clean, colour-coded if it helps, but absolutely phone-friendly.
Deliverables I expect:
1. Google Form set up with the specified fields and drop-down inputs.
2. Google Sheets workbook containing:
– A raw data tab fed directly by the form
– Script or formula for sequential job number generation
– Calculation columns for cost, revenue and profit
– A dashboard tab with clear charts/metrics for the items above
3. All files shared in my Google Workspace with edit rights.
4. Brief hand-over notes so I can adjust clients, sites or sequences myself later.
When you reply, please include a quick example of a similar Google Sheets/Forms build you have done, outline your approach, confirm you can hit a two-to-three-day turnaround, and state your price.