QR-Linked Machine Maintenance Tracker

I need a single, central Google Sheets workbook that keeps every maintenance detail for 14 identical machines: the fault reported, the date it was fixed, the part involved, and the next scheduled replacement. Each machine will have a unique QR code mounted inside its housing; when a tech scans it, a short, machine-specific form should open, capture the data, and feed it straight back into the master sheet with a time-stamp and the machine ID already filled in.

Because the QR codes are part of the workflow, I’d like the solution to generate them automatically—no external websites or manual downloads—so everything remains self-contained. Once the data lands in Google Sheets, the system must watch the “next replacement” column and fire off an email whenever a part is due soon. For now the email only has to list the upcoming component replacement dates, but it should be coded in a way that makes adding full reports later easy.

Deliverables
• Google Sheets master file with tables for issues, fixes, and replacement schedule
• Google Forms (or equivalent script-generated forms) pre-populated with machine IDs
• Script to create and embed QR codes for each form, ready to print
• Apps Script automation that:
 – logs form submissions into the proper tables
 – checks dates daily and emails the upcoming replacements list
• Brief hand-off guide so future staff can tweak ranges, email lists, or add machines

Acceptance criteria: scanning any QR code opens the correct form, submitting the form instantly updates the sheet, and an email arrives when a replacement date is within the alert window we agree on.