Main Goals: Have one source of truth, easy oversight and save time on manual work. There are many library softwares but not many that manage donations as well so we chose another route.

How we achieved those goals:

1. Configure one software to track books, patrons and donations
2. Easy creation of new records via forms and automations
3. Easy book check in and out
4. Visibility for due and overdue books

Airtable is a flexible platform that allows for these objectives as well as future custom automations. It has a similar experience to a spreadsheet but has the power of a proper database.

Configure one software to track books, patrons and donations:

Easy creation of new records via forms and automations:

We can add new books by inputting the ISBN#. Automation pulls in the name and author of the book.

Patrons can fill out a simple form to join the library

Easy book check in and out

Books are checked out via form

Books are checked back in by switching statuses on this screen

Visibility for due and overdue books

Potential Add-ons:

1. Automation to contact patrons with overdue books with reminders to return
2. Automation to generate Thank You letters to donors