Vehicle checks from a form: alerts on critical, history in a sheet
The scenario checks a JotForm inspection against the vehicle's history, sends an urgent email via Gmail on critical issues and a routine report otherwise, and logs the result to Google Sheets.
- Critical issues caught at once, not when the vehicle dies
- Each check compared to that vehicle's history
- Urgent and routine take different routes
- A per-vehicle history builds in a sheet
Made with Scriptera