Keys out now

Check out a key

Click the key being handed over.

Keys out

Every key off the wall on loan. Use Change due when someone needs a key for longer.

Key	Address/Description	Held by	Phone	Held since	Due back

Permanent

Held indefinitely — building managers, cleaners with standing access. Set due date turns one back into an ordinary loan.

Key	Address/Description	Held by	Phone	Held since	Due back

Key types

The master series a key belongs to, such as Unit Master or Service Master. Individual keys are numbered within a type.

Type	Description	Keys

Key register

Every physical key and where it is right now.

Key	Address/Description	Status	Held by	Due back	Notes

Companies and their contractors

Built from what gets typed at check-out. Click a company to see its people. Tidy it whenever you like — merging a duplicate keeps all of its key history.

Contractor	Mobile	Email	Keys held

Key history

Every check-out and return for this office. Search and filter to narrow the list, then export exactly what is showing.

Key	Held by	Company	Out	Due	Returned	Note

Office settings

These apply to this office only.

Who gets told about overdue keys

These people are alerted whenever a key in this office passes its due-back time.

Name	Email	Mobile	Alerts

Global settings

These apply across every office, and only a super administrator can change them.

Text messaging

Credentials are held in Script Properties (SMS_USERNAME and SMS_API_KEY), never in the spreadsheet.

Global log

Everything done in the app, across every office. Pick the dates, then the boxes above each column narrow what is showing as you type.

When	Office	Who	What	Detail

Offices

Each office keeps its own keys, history, alerts and contractor directory.

Office	Key types	Staff	SMS credits

Who can sign in

Administrators can change settings and the register. Staff can check keys in and out.

Name	Google account	Role	Offices	Status