STS Services · QC Portal

Daily Entry

Sorting Inspection Form

⚙️ One-Time Google Sheets Setup

Open Google Sheets → create a spreadsheet named "STS Inspections"
Extensions → Apps Script → paste code below → Deploy → New deployment → Web App → Anyone → Deploy → copy URL
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);
}

Web App URL

Company Email

✔ Saved!

Job

Select Active Quote *

Customer

Customer Code *

Customer Name

Service Start

Service End

🔩

Part Information

01

#	Part Number *	Part Description	Defects

Add rows:

📊

Inspection Results

02

⚡ Inspected, Approved & Rejected are auto-calculated from the OK + NOK totals in the defect table below. Enter Reworked manually if needed.

🔍 Inspected

✔ Approved (OK)

✖ Rejected (NOK)

🔧 Reworked

⚠️

Defect Breakdown & Serial / Lot Numbers

03

#	Part Number	Mfg Date	Serial Number	Lot & Batch #	Defect Description	OK	NOK
Totals						0	0

Add rows:

Type a number and press Enter, or click + Add Rows

👷

Personnel & Hours

04

# of People *

↳ Rows appear below

#	Name / Employee ID	Role	Hours 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

Submitted By (Supervisor)

Notes

Submit daily — each submission = one row in Google Sheets.
Customer info stays filled. Admin can download PDF from Overview.

Admin

Service Overview

Select a Quote to view its summary

📋

All Submissions

📭

No submissions yet.

📖

Portal Guide & Setup

👤 User Roles

Admin — Full access: create jobs, view all submissions, manage client access, payroll, delete reports.
Operator (STS) — Sees only STS jobs. Submits inspections, edits own reports. No delete.
Operator 2 (SLI) — Same as Operator but sees only SLI jobs.
Client — Read-only portal. Sees reports grouped by Month → Job → Submission. Only available after admin releases.

🗂 Job ID System

Format: STS042026 = Company + Month (MM) + Sequence + Year (YYYY).
Sequence resets every month. Each company (STS / SLI) counts independently.
Admin creates jobs — operators just pick from the list. One job per company per sequence number, no duplicates.

📋 Inspection Workflow

1. Admin creates a Job (🗂 Jobs tab) with client info, dates, description.
2. Operator logs in → selects their job → customer info auto-fills → form is hidden.
3. Operator fills Part Info, Defects, Personnel, Photos → submits.
4. Admin reviews in Overview → filter by job to see totals for that specific service.
5. Admin goes to Clients tab → finds the client → clicks Release to Client.
6. Client logs in and sees their reports organized by Month and Job.

🌐 Wix Integration

Option 1 — Button link (Recommended): In Wix Editor, add a button → set link to portal.stslaredo.com → opens in new tab.
Option 2 — iFrame embed: Add Elements → Embed & Social → iFrame → paste portal URL. Set width 100%, height 900px.

⚠️ Important Notes

• Photos are compressed automatically before saving — large photo sets are handled safely.
• Submissions are linked to jobs. Deleting a job does not delete its submissions.
• The Clear All Data function has been removed for safety. Contact your developer to delete records.
• Client portal is always in Spanish. Admin/Operator portal is in English.

—

Select a day to view inspections

📅

Click any highlighted day.

Quote Management

Quotes

🗂

Create New Job

Company *

Quote Date

Customer Code

Customer Name

Service Start

Service End

Quote Description

Quote ID (auto-filled · editable)

Quotes

🗂

No quotes yet.

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 = {
  'sebastian.loera': { pass: 'Loer@0801',  role: 'operator', name: 'Sebastian Loera', company: 'all' },
  'jesus.arevalo':   { pass: 'sli2026',    role: 'operator', name: 'Jesus Arevalo',   company: 'sli' },
  admin:             { pass: 'sts@admin',  role: 'admin',    name: 'Admin',           company: 'all' },
  'cesar.loera':     { pass: 'Loer@0321',  role: 'admin2',   name: 'Cesar Loera',     company: 'sts' },
  'victor.loera':    { pass: 'sts@admin3', role: 'admin3',   name: 'Victor Loera',    company: 'sli' },
};

🗄️

Google Sheets Config

Web App URL

Company Email

✔ Saved!