DP Expiry Check

Items expiring or expired

Shows items whose reminder date has been reached. Snooze to be reminded again later, or dismiss once handled.

Emails everything currently expired or expiring within 1 month — regardless of each item's own reminder setting — to the address(es) in Settings. Use this any time, on top of the automatic daily email.

Items with expiry dates recorded

Loading…

Date *

Repair No

Customer name *

Customer phone number *

Bill date

Bill number

Barcode *

Item name

Supplier

Complaint details

Upload the latest item Excel file

This replaces the department(s) you choose below with exactly what's in the file — existing items in other departments are left untouched.

Departments to replace (comma-separated, optional)

Google Apps Script Web App URL

Paste the URL you got after deploying Code.gs as a web app in your Google Sheet (Extensions → Apps Script → Deploy). This is saved on this device only.

Reminder email(s)

Daily digest of expiring/expired items, sent even if this app isn't open. Comma-separate multiple addresses. Requires the one-time trigger setup described in Code.gs.

Company details (shown on printed receipts)

Used only for the customer repair receipt header.

Company name

Address

Phone

TRN

DP Expiry Check

Expiry batches

Job detail