🌐 stslaredo.com
?
β€”
β€”
Daily Entry
Sorting Inspection Form
βš™οΈ One-Time Google Sheets Setup
  1. Open Google Sheets β†’ create a spreadsheet named "STS Inspections"
  2. Extensions β†’ Apps Script β†’ paste code below β†’ Deploy β†’ New deployment β†’ Web App β†’ Anyone β†’ Deploy β†’ copy URL
  3. Paste the URL below and Save Config
πŸ“‹ Apps Script code
function doPost(e) {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var data = JSON.parse(e.postData.contents);
  if (sheet.getLastRow() === 0) {
    sheet.appendRow(["Form ID","Date","Customer Code","Customer Name",
      "Service Start","Service End","Part Number","Serial Numbers",
      "Lot Numbers","Mfg Date","Inspected","Approved","Rejected",
      "Reworked","Defect Summary","# People","Total Hours","Notes","Submitted By"]);
  }
  sheet.appendRow([data.formId,data.submitDate,data.customerCode,
    data.customerName,data.serviceStart,data.serviceEnd,data.partNumber,
    data.serialNumbers,data.lotNumbers,data.mfgDate,data.inspected,
    data.approved,data.rejected,data.reworked,data.defectSummary,
    data.numPeople,data.totalHours,data.notes,data.submittedBy]);
  return ContentService.createTextOutput(JSON.stringify({result:"ok"}))
    .setMimeType(ContentService.MimeType.JSON);
}
βœ” Saved!
Customer
πŸ”©
Part Information & Serial / Lot Numbers
01
#Serial NumberLot / Batch Number
πŸ“Š
Inspection Results
02
πŸ” Inspected
βœ” Approved
βœ– Rejected
πŸ”§ Reworked
⚠ Approved + Rejected + Reworked should equal Inspected.
⚠️
Defect Breakdown
03
#Defect DescriptionCodeQty
Total Defects0
πŸ‘·
Personnel & Hours
04
↳ Rows appear below
#Name / Employee IDRoleHours Worked
Total Hours: 0.00
πŸ“Έ
Photo Evidence
05

Upload photos of parts, defects, or any visual evidence. Photos are embedded directly in this session and the PDF β€” they are never saved to your device.

πŸ“·
Tap to take a photo or choose files
or drag & drop images here Β· JPG, PNG, HEIC
πŸ“
Notes & Observations
06
Submit daily β€” each submission = one row in Google Sheets.
Customer info stays filled. Admin can download PDF from Overview.
Admin
Service Overview
Total Inspected
β€”
all submissions
Total Approved
β€”
β€”
Total Rejected
β€”
β€”
Total Hours
β€”
β€”
⚠️
Defect Totals
πŸ“­
No submissions yet.
πŸ“‹
All Submissions
πŸ“­
No submissions yet.
🌐
How to Add This Portal to Your Wix Website
Option 1 β€” Link as a button (Recommended): In Wix Editor, add a button labeled "QC Portal" β†’ set link to your Netlify URL. Supervisors open it in a new tab. Clean and simple.

Option 2 β€” iFrame embed: Add Elements β†’ Embed & Social β†’ iFrame β†’ paste Netlify URL. Set width 100%, height 900px.

Custom subdomain: Netlify β†’ Domain management β†’ add portal.stslaredo.com β†’ update DNS in your registrar to point to Netlify.
Admin
Client Directory
πŸ“
No clients yet. Submit an inspection form to populate the directory.
πŸ”©
Service History by Part Number
πŸ“‹
All Submissions for This Client
Admin
Payroll β€” Hours by Operator
Total Hours Logged
β€”
Total Operators
β€”
Weeks on Record
β€”
Filter week:
πŸ’°
No payroll data yet. Submit inspection forms with personnel hours to see payroll breakdown.
Admin
Settings
πŸ”‘
User Credentials

To change passwords, open the HTML file in any text editor and find the USERS object at the top of the script.

const USERS = {
  operator:  { pass: 'sts2024',   role: 'operator', name: 'Operator'    },
  operator2: { pass: 'sts2024',   role: 'operator', name: 'Operator 2'  },
  admin:     { pass: 'sts@admin', role: 'admin',    name: 'Admin'       },
};
πŸ—„οΈ
Google Sheets Config
βœ” Saved!