---
title: "Create an inventory database"
canonical: "https://support.appfire.com/space/SCAFC/477468631/Create%20an%20inventory%20database"
format: markdown
---
> Macro (aura-html)
## Overview
Creating an inventory database provides you with a variety of useful data to keep track of your assets or items in stock. Having detailed inventory reports helps you spot trends, maintain adequate supplies, and spot potential problems.
In this example, we will build an inventory database using Scaffolding. Each inventory item is stored as a page and shares the same format, layout, and sections.
- You use a template to record new inventory items.
- Confluence users can then access the inventory record to get information.
Here is a video that steps you through the process of creating an inventory database:
Later, you can modify the template, and those changes automatically update all pages using it.
## Use Case
| | |
| --- | --- |
| Background | Your organization’s assets and items are increasing daily, making restocking and replenishing a growing challenge. |
| Solution | You want to be able to keep track of all your inventory, and you want to provide your end users with a simple way to fill out a form each time there are any updates to inventory items. As an administrator, you want to be able to create a template that you can edit with one click and have the changes reflected on every page using the template. |
| Final Outcome | You set up an Inventory Database space, then created a live template for the Inventory form with Scaffolding Cloud using key fields you created using the Field Group macro.
 |
## Building the knowledge base system
### Step 1 - Create the template
Creating the template
1. Go to **Space Settings > Look and Feel**.
2. Add a new template.
3. Name the new template `Inventory Item Template`.
4. Add a Field Group macro.
5. Create a basic table for `Barcode`, `Description`, `Category`, etc*.*
6. Use the appropriate field type for each. For example, a **Dropdown List** field for *Category.*
7. Create a dynamic table in a `Components `section using the **Table** **field** type.
> ℹ️ In this example, the `Name and details` field is a **Page list** field to pull a list of Confluence pages.
8. Save the template.
### Step 2 - Create an inventory item page
Creating an inventory item page
1. Create a new page
2. Add a **Live Template** macro.
3. Locate the template *Inventory Item Template.*
4. Save the macro and publish the page.
### Step 3 - Add content
Adding content
1. Choose **Edit Content** to turn the page into a form.
2. Populate the fields on the form.
3. Choose **Publish Content.**
Now you have an inventory database in your Confluence.