Creating inventory database

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 will be stored as a page, share the same format, layout and sections. Your team members will use the template to record new inventory items. Confluence users can then access the inventory record to get information. You can also make changes to the template in the future, which will automatically update all the pages your users have created.

Sample Use Case

BackgroundYour organization assets and items are increasing day by day. Restocking and replenishing items is becoming a heavy chore.
SolutionYou want to be able to keep track of all your inventory and end users provided a simple way to fill in a form each time there are any updates to inventory items. For you as as the administrator you want to be able to create a template that can be edited with one click and change reflected on every page using the template.
Final Outcome

You have setup an Inventory Database space, then created a live template for the Inventory form with Scaffolding Cloud using key fields you created using Field Group macro. 

End Result : 


         
Building the knowledge base system

 Step 1 - Create the template
  1. Go to your space settings, and add a new template. Name it Inventory Item Template.

  2. Add a Field Group macro.



  3. Create a basic table for Barcode, Description, Category, etc for item summary.
    Use appropriate field type for each. For example, a Custom List for Category.



  4. You might want a dynamic table to create rows of Components or History. For that, use the Table field type.
    Also, in this example, the Name and details field is a Content List to pull a list of Confluence pages.



  5. Save the template. 
 Step 2 - Create a project overview 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
  1. Click on Edit Content to turn the page into form.



  2. Populate the fields on the form.


  3. When you're done, click Save Content.

That's it! Now you have an inventory database in your Confluence!

See more Examples.