Library Check Out Sheet

A classroom or school library: a book catalogue with copies available and a loan log with two-week due dates and late fines.

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

Books, Loans

Fields

23

Views

grid, cards, 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.

Books

12 fields · 5 sample rows

  • Catalogue (Grid)
  • Bookshelf (Cards)
TitleTextAuthorTextISBNBarcodeGenreSingle selectReading LevelSingle selectShelfTextCopiesNumberCoverAttachmentLoansLink to another tableTimes BorrowedCountOn LoanRollupAvailableFormula
Malgudi DaysR. K. Narayan9780143039655FictionGrades 6–8F-NAR3Ananya Gupta, Sara Ahmed221
Wings of FireA. P. J. Abdul Kalam9788173711466Non-fictionGrades 9–12B-KAL2Rohan Das111
Charlotte’s WebE. B. White9780064400558FictionGrades 3–5F-WHI4Emma Wilson104
A Short History of Nearly EverythingBill Bryson9780767908184ScienceGrades 9–12S-BRY1Mr. Thomas101
Amar Chitra Katha: AkbarAnant PaiComicsGrades 3–5C-PAI2Kabir Shah111
Field details
Title · Text
Author · Text
ISBN · Barcode
Genre · Single select
Fiction, Non-fiction, Science, History, Comics, Poetry, Reference
Reading Level · Single select
Grades 1–2, Grades 3–5, Grades 6–8, Grades 9–12
Shelf · Text
Copies · Number
Cover · Attachment
Loans · Link to another table
Links to Loans
Times Borrowed · Count
On Loan · Rollup
sum of Is Out via Loans
Available · Formula
{Copies} - {On Loan}

Loans

11 fields · 6 sample rows

  • Loans (Grid)
  • On loan (Grid)
  • Calendar (Calendar)
  • Borrow a book (Form)
BorrowerTextClassSingle selectBookLink to another tableContactPhoneChecked OutDateDue DateFormulaReturnedDateIs OutFormulaDays LateFormulaFineFormulaCondition on ReturnSingle select
Ananya GuptaGrade 7Malgudi Days14 Nov 202628 Nov 202610₹0
Rohan DasGrade 10Wings of Fire30 Oct 202613 Nov 202616₹12
Emma WilsonGrade 4Charlotte’s Web3 Nov 202617 Nov 202618 Nov 202601₹2Good
Mr. ThomasStaffA Short History of Nearly Everything20 Oct 20263 Nov 20267 Nov 202604₹8Worn
Kabir ShahGrade 5Amar Chitra Katha: Akbar17 Nov 20261 Dec 202610₹0
Sara AhmedGrade 8Malgudi Days9 Nov 202623 Nov 202610₹0
Field details
Borrower · Text
Class · Single select
Grade 4, Grade 5, Grade 7, Grade 8, Grade 10, Staff
Book · Link to another table
Links to Books
Contact · Phone
Checked Out · Date
Due Date · Formula
IF({Checked Out}, DATEADD({Checked Out}, 14, 'days'), BLANK())
Returned · Date
Is Out · Formula
IF({Returned}, 0, 1)
Days Late · Formula
IF({Due Date}, MAX(DATETIME_DIFF(IF({Returned}, {Returned}, TODAY()), {Due Date}, 'days'), 0), 0)
Fine · Formula
{Days Late} * 2
Condition on Return · Single select
Good, Worn, Damaged, Lost

Form view “Borrow a book” asks for: Borrower, Class, Book, Contact, Checked Out.

Library Check Out Sheet: 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