Webstudio + Baserow

This template is using the template "Company Asset Tracker" found in Baserow.

Baserow company asset tracker

How to use

Baserow setup
  • Create new workspace
  • Create new database from template "Company Asset Tracker" within that workspace
  • Open "User settings" and navigate to "database tokens" tab
  • Create new token with read permission
  • In the left menu click the 3 menu dots on your database > navigate to "View API Docs"
  • In Baserow open "User settings" and navigate to "database tokens" tab. Create new token with read permission
  • In Baserow open "User settings" and navigate to "database tokens" tab. Create new token with read permission
Webstudio setup
  • Create new collection
  • Add a collection called "Assets" (there are 3 tables in that database, I believe they should be fetched individually - please confirm)
  • Type = Resource
  • URL = https://api.baserow.io/api/database/rows/table/{{yourTableID}}
  • Method = GET
  • Add header | Name = Authorization | Value = Token yourTokenID
  • Map all items as you normally would
  • Remember to create a collection within a collection for items that have multiple values (eg, Employees table "item(s) being used" column

Tables within the database

Serial number
Item type
Image
Cost
Condition
Notes
Using item
Date leased