Key Checkout Log

Know who has which key: a key register with copy counts and a signed checkout log that flags keys not returned on time.

Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.

Category

Log Sheets

Tables

Keys, Checkouts

Fields

21

Views

grid, calendar, form

Tables, columns and sample rows

The 2 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.

Keys

9 fields · 5 sample rows

  • Key register (Grid)
KeyTextKey CodeTextOpensTextTypeSingle selectCopiesNumberCheckoutsLink to another tableTimes Checked OutCountCopies OutRollupAvailableFormula
Main entrance masterK-001Front doors, all floorsMaster2ABC Electricals111
Finance officeK-014Room 204Office3Elena Novak112
Server roomK-020Basement server roomServer room1Ravi Shankar110
Delivery vanK-031Van MH12 PQ 4455Vehicle2Sunil Patil102
Stationery cupboardK-0452nd floor storageStorage4Meghna Roy104
Field details
Key · Text
Key Code · Text
Opens · Text
Type · Single select
Master, Office, Cabinet, Vehicle, Storage, Server room
Copies · Number
Checkouts · Link to another table
Links to Checkouts
Times Checked Out · Count
Copies Out · Rollup
sum of Is Out via Checkouts
Available · Formula
{Copies} - {Copies Out}

Checkouts

12 fields · 5 sample rows

  • Checkout log (Grid)
  • Keys out now (Grid)
  • Due back (Calendar)
  • Check out a key (Form)
BorrowerTextKeyLink to another tableDepartmentSingle selectPhonePhonePurposeTextChecked OutDateDue BackDateReturnedDateIs OutFormulaStatusFormulaIssued ByTextSignatureSignature
Ravi ShankarServer roomIT+91 98450 70707Router replacement19 Nov 202619 Nov 20261OutFront desk
Elena NovakFinance officeFinanceMonth-end close16 Nov 202618 Nov 20261OverdueFront desk
Sunil PatilDelivery vanLogistics+91 99220 80808Deliveries – Pune east18 Nov 202618 Nov 202618 Nov 20260ReturnedSecurity
ABC ElectricalsMain entrance masterContractor+91 98200 90909Weekend wiring work17 Nov 202620 Nov 20261OutFacilities manager
Meghna RoyStationery cupboardAdmin14 Nov 202614 Nov 202614 Nov 20260ReturnedFront desk
Field details
Borrower · Text
Key · Link to another table
Links to Keys
Department · Single select
Facilities, Finance, IT, Logistics, Admin, Contractor
Phone · Phone
Purpose · Text
Checked Out · Date
Due Back · Date
Returned · Date
Is Out · Formula
IF({Returned}, 0, 1)
Status · Formula
IF({Returned}, 'Returned', IF(AND({Due Back}, IS_BEFORE({Due Back}, TODAY())), 'Overdue', 'Out'))
Issued By · Text
Signature · Signature

Form view “Check out a key” asks for: Borrower, Key, Department, Phone, Purpose, Checked Out, Due Back, Signature.

Key Checkout Log: questions

Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.

Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.

Related templates