How to create an equipment checkout form with inventory tracking

Manage your equipment loans with clarity and control

In this guide, you’ll create an Equipment Checkout Form that allows employees, students, or field staff to borrow and return gear while automatically tracking inventory and availability.
You’ll use linked forms, logic, and dashboards to monitor what’s checked out, what’s due, and what’s available, all in one place.

📘 Learn more: Create your first form, app, or portal in a flash

Step 1: Create your equipment checkout form

Start from your workspace and click + New → Form, or choose Office Inventory App template from the gallery.
You can also use Magic Create, try this prompt:

“Equipment checkout form with borrower details, item selection, return date, and automatic stock updates.”

Add core fields such as:

• Borrower name
  
  
• Department or team
  
  
• Email (for reminders)
  
  
• Equipment item (Dropdown or Lookup from your inventory list)
  
  
• Quantity requested
  
  
• Checkout date (auto-filled as today)
  
  
• Expected return date
  
  
• Purpose of use (optional)
  
  
• Status (Checked out / Returned / Overdue)
  
  

💡 Tip: Keep your form concise, use dropdowns or lookups for item names to ensure data consistency.

📘 Learn more: How to create a form
📘 Learn more: Form editor and field types

Step 2: Create your inventory database

Create a second form called Equipment inventory list to track all available items.

Add fields like:

• Item name
  
  
• Category (Electronics / Tools / Audio / Other)
  
  
• Stock quantity
  
  
• Items checked out
  
  
• Items available (calculated variable)
  
  
• Notes or serial numbers
  
  

💡 Example variable formula:

@stock_quantity - @items_checked_out

📘 Learn more: What are variables, why and how to use them

Step 3: Connect both forms

‍
This ensures every checkout record updates the related item’s status and counts automatically.

📘 Learn more: How to connect forms with automatic data transfer

Step 4: Use logic to update inventory

Set up On submit logic in your checkout form to reduce stock automatically.

Example rule:

If @item = “Camera” → set “Items checked out” = previous value + @quantity_requested

Similarly, add On update logic for returns to restore availability.

📘 Learn more: What is on submit logic and how it works
📘 Learn more: What is on update logic and how it works

Step 5: Add automated email notifications

Under Settings → Notifications, create conditional emails to notify the borrower and admin team:

Examples:

• To borrower: “Your equipment checkout is confirmed.”
  
  
• To admin: “New checkout: @item for @borrower_name.”
  
  

Use dynamic fields to personalize each message:

Item: @item
Quantity: @quantity
Expected return: @return_date

📘 Learn more: How to send and receive conditional email notifications

Step 6: Build a return form for borrowers

Create a second form titled Equipment return form so users can log their returns.
Use Lookup fields to pull their previous checkout data (item name, quantity, return date).

Add fields for:

• Actual return date
  
  
• Condition on return (Good / Damaged / Needs maintenance)
  
  
• Notes or photo upload (optional)
  
  
• Status update (Returned)
  
  

Once submitted, logic updates both the borrower’s record and the inventory count automatically.

📘 Learn more: How to lookup the submitted data of another form

‍

Step 7: Visualize your inventory and loans

Go to Results → Dashboard and create a management view for admins.
Add:

• Table view: All checkout and return records
  
  
• Kanban board: Grouped by item or status
  
  
• Pie chart: Checked out vs available stock
  
  
• Bar chart: Equipment usage by department
  
  

📘 Learn more: How to create a Kanban board
📘 Learn more: How to showcase charts based on form responses

Step 8: Build an equipment management portal

Turn your setup into an Equipment Management Portal App for internal access.
Add pages for:

• Submit a checkout request — main form
  
  
• Return equipment — return form
  
  
• Inventory list — linked database
  
  
• Admin dashboard — analytics and stock tracking
  
  

Enable Login/Sign-up and assign roles such as Borrower, Admin, and Inventory Manager for controlled access.

📘 Learn more: How to create and assign user roles in your portal
📘 Learn more: How to let users view and edit their own data in your portal

Step 9: Generate checkout receipts or reports

Use PDF templates to automatically generate checkout receipts or inventory reports.
Include:

• Borrower and department info
  
  
• Equipment details and quantity
  
  
• Return date
  
  
• Digital signature or confirmation section
  
  

Attach the PDF to confirmation emails or store them for recordkeeping.

📘 Learn more: How to create PDF templates to turn responses into documents

Pro tips

• Enable autosave: Let borrowers fill long request forms easily on mobile.
  📘 Learn more: How to auto save incomplete responses and let users resume later
  
  
• Add AI Smart Content: Automatically summarize borrowing activity per user.
  📘 Learn more: Create dynamic ending pages with AI Smart Content
  
  
• Integrate Google Sheets: Sync equipment records for backup or reporting.
  📘 Learn more: How to set up two-way sync between Formaloo and Google Sheets
  
  

Example scenario

A student checks out a DSLR camera and tripod for a workshop.
Logic reduces the camera’s stock count by one and sends the admin team a notification.
When the student returns the gear through the return form, the inventory updates instantly, and an automated receipt confirms completion.
The dashboard shows all items returned and one lens still pending, marked as Overdue.

📘 Learn more: Build personalized and time-saving flows with logic, automations, and AI

FAQ

1. Can multiple users check out the same type of equipment?
Yes, as long as sufficient stock remains; inventory adjusts dynamically.

2. Can I track damaged or lost items?
Absolutely add status options like Damaged or Lost and flag them for maintenance review.

Your equipment tracking system is ready

You’ve built a complete equipment checkout workflow that manages inventory automatically, sends smart reminders, and keeps every item accounted for.
Next, expand it into a Full Asset Management Portal with maintenance logs, vendor details, and usage reports.

📘 Learn more: How to customize your portal with your brand identity

Last updated November 2025

‍