Stock inventory spreadsheet

Objectives

You want to generate a spreadsheet for your stock inventory with the following features:

• Automatically create new sheets,
• Display products using a loop,
• Show characteristics from a nested array.

Solution

Here’s how you can achieve this using Carbone:

1. Design your template

   Use Carbone tags to define how your data is displayed, using loops and nested loops.

   Example:

   {d.brands[i].products[i].name}      
      {d.brands[i].products[i].packaging[i].size} {d.brands[i].products[i].packaging[i].quantity} 
      {d.brands[i].products[i].packaging[i+1]}        
   {d.brands[i].products[i+1]}     

2. Define alias

   Use {#...=...} to define alias.

   Example:

   {#sheet1 = d.brands[i].name}
   {#sheet2 = d.brands[i+1].name}

3. Rename sheets using aliases

   Right click on the tab, and select "Rename sheet..." option.

   Write {$...} to use the alias previously defined

   Example: {$sheet1} and {$sheet2}

And there you go!