Skip to main content

Tool library

A worked example: a neighborhood tool library where members borrow drills, ladders, and garden gear, run by a couple of volunteers. It leans on Assets, Locations, QR labels, and a member-facing custom app.

What you end up with​

  • Every tool as an asset: one record per physical thing, with its own condition, purchase date, and history. A ladder and a drill aren't interchangeable stock, they're specific items, which is exactly what an asset is.
  • A few fields that turn assets into a lending record: a status choice (available, out, being repaired), who has it, and a due-back date.
  • A QR label on each tool, so checking one out or back in is a scan, not a search.
  • A calendar view of due-back dates, so volunteers see what's coming back this week.
  • A member app that shows what's available to borrow and nothing else.

Putting it together​

  1. Enable Assets and add your tools, fastest by scanning the ones with barcodes. Add the lending fields: a status choice, a "borrowed by" field, and a due-back date.

  2. Build a locations tree for where tools live on the shelves, and print QR labels for them. A returned tool gets scanned back to its spot.

  3. Save the views the desk actually needs: a table filtered to "out" for chasing overdue items, and a calendar on the due-back date for the week ahead.

  4. Bring volunteers in as members with grants, not full admins. They can flip a tool's status and set who has it without touching the rest of the workspace.

  5. Give members a custom app: a gallery of available tools, read-only, so anyone can see what's free to borrow before they walk over.

Where it goes next​

Add a computed field that shows a tool's due date as "in 3 days" or "5 days ago", and you have an at-a-glance overdue view. Point the "out" table at a public screen by the desk and the checkout status is visible without anyone opening a laptop.

Lending here is modeled with fields and views rather than a dedicated checkout module, which keeps it flexible: the same pattern fits a costume closet, a board-game library, or an AV cart.