ASUS CN Tracker — UberTech

New Support Request

SR-2026-XXXX

Case Type *

Product Line *

Requestor *

Internal Reference *

Customer / Project

Requested Amount (₱)

ASUS Case ID (if already issued)

Notes / Justification

Settings

Admin only — system configuration

📊 Google Sheets Database

Not connected — data saves locally only

Sign up free at sheets.google.com, follow the apps-script.js setup guide, then paste your Web App URL below.

Once connected, all data is saved to your Google Sheet automatically. You own the data.

💾 Backup & Recovery

Backups save a complete snapshot of all your data (requests, users, product lines, settings) as a JSON file to your computer.

Backup Schedule

Last Backup

Never

Export Data

CSV is for viewing in Excel. JSON is for backup/restore.

✉ Email Notifications (EmailJS)

Sign up free at emailjs.com then fill in your credentials. Template variables needed: to_email, subject, message, sr_num

Service ID

Template ID

Public Key

Notification recipients (one email per line)

📦 Archive Settled Cases

Move settled cases within a date range to a named archive tab in your Google Sheet. They will be removed from the active tracker but remain visible in the Sheet.

Settled From

Settled To

Archive Tab Name

This becomes the tab name in your Google Sheet

⚠ Archived cases are removed from the active tracker. Make sure you have a backup before archiving.