Run a school or community library: a catalogue of books, a checkout log with due dates, and automatic overdue days and 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
Tables
Books, Checkouts
Fields
22
Views
grid, cards, calendar, form, dashboard
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.
9 fields · 5 sample rows
| TitleText | AuthorText | ISBNBarcode | GenreSingle select | ShelfText | CopiesNumber | CoverAttachment | CheckoutsLink to another table | Times borrowedCount |
|---|---|---|---|---|---|---|---|---|
| The God of Small Things | Arundhati Roy | 9780006550686 | Fiction | F-ROY | 2 | Ravi Shankar | 1 | |
| Sapiens | Yuval Noah Harari | 9780099590088 | Non-fiction | NF-909 | 3 | Neelam Joshi | 1 | |
| Malgudi Days | R. K. Narayan | 9780143039655 | Indian classics | F-NAR | 2 | Mira Nair | 1 | |
| Harry Potter and the Philosopher’s Stone | J. K. Rowling | 9781408855652 | Children | C-ROW | 4 | Ishaan Verma, Tanya Bose | 2 | |
| The Murder of Roger Ackroyd | Agatha Christie | 9780007527526 | Mystery | M-CHR | 1 | Alex Turner | 1 |
13 fields · 6 sample rows
| BorrowerText | BookLink to another table | Member IDText | PhonePhone | EmailEmail | Checked outDate | DueDate | ReturnedDate | StatusFormula | Days overdueFormula | FineFormula | Fine paidCheckbox | Condition on returnSingle select |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Ishaan Verma | Harry Potter and the Philosopher’s Stone | STU-1042 | +91 98100 22113 | 9 Nov 2026 | 23 Nov 2026 | On loan | 0 | ₹0 | ||||
| Neelam Joshi | Sapiens | STF-0021 | [email protected] | 30 Oct 2026 | 13 Nov 2026 | Overdue | 6 | ₹30 | ||||
| Alex Turner | The Murder of Roger Ackroyd | PUB-0305 | [email protected] | 25 Oct 2026 | 8 Nov 2026 | 11 Nov 2026 | Returned | 3 | ₹15 | Yes | Good | |
| Mira Nair | Malgudi Days | STU-1107 | +91 98450 99887 | 16 Nov 2026 | 30 Nov 2026 | On loan | 0 | ₹0 | ||||
| Ravi Shankar | The God of Small Things | PUB-0288 | +91 99000 11002 | 20 Oct 2026 | 3 Nov 2026 | 4 Nov 2026 | Returned | 1 | ₹5 | Worn | ||
| Tanya Bose | Harry Potter and the Philosopher’s Stone | STU-1133 | 1 Nov 2026 | 15 Nov 2026 | Overdue | 4 | ₹20 |
Form view “Book checkout” asks for: Borrower, Book, Member ID, Phone, Email, Checked out, Due.
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.
Log contractor hours against projects, approve timesheets and see billable totals per contractor at their own hourly rate.
2 tables · 20 fieldsCookie Order TrackerTake cookie orders, track baking and delivery, and see what is paid and owed for a home bakery or fundraiser drive.
1 table · 16 fieldsCoronavirus Monitoring SheetContact-tracing for an organisation: log confirmed cases, trace their close contacts and monitor isolation and quarantine end dates.
2 tables · 23 fieldsCorrection Tracking TemplateLog copy and content corrections with the original and corrected text, route them to editors and measure turnaround.
1 table · 16 fieldsCOVID-19 Daily Symptom TrackerA daily health self-check for staff or patients: temperature, symptoms and exposure, with an automatic fever flag and clearance status.
1 table · 11 fieldsDebt Tracker TemplateList every loan and card balance, log payments against them, and watch remaining balances and payoff progress shrink.
2 tables · 23 fields