Formula demo
Categories
Baserow
Level
Beginner

Experience the power of automation with our Baserow demo template, featuring 10 practical use cases designed to streamline business processes. This template highlights the effective use of formulas to automate key operations, Ideal for businesses seeking to optimize workflows and boost productivity, this template provides a hands-on demonstration of how Baserow can transform your operations.

This template covers 10 use cases where each use case has its own database and sometimes an application.

  1. Generate a unique meaningful name for each record
  2. Add leading zeros for improved readability
  3. Automate task scheduling
  4. Enforce valid data input
  5. Build planning and deadlines for tasks
  6. Trigger automatic status updates with a webhook
    1. NOTE: replace the url in the Start task field with your own webhook url
  7. Set up an asset repository for documents and images
    1. NOTE: replace the url in the Details field with your own application url
  8. Build a pre-filled form for data input
  9. Manage capacity planning for your team
  10. Balance the weekly workload for your team

Database: Case 1 - Task Management

Tasks

Fields

  • Name (Formula)

  • Category (Single select)

  • Description (Text)

  • Title (Text)

  • Name - 1 (Formula)

  • Name - 2 (Formula)

  • Name - 3 (Formula)

  • Name - 4 (Formula)

  • Created on (Created on)

Views

  • All tasks (grid)

Tasks

Fields

  • Name (Formula)

  • Category (Single select)

  • Description (Text)

  • Title (Text)

  • Created on (Created on)

  • ID (Formula)

Views

  • All tasks (grid)

Tasks

Fields

  • Name (Formula)

  • Category (Single select)

  • Description (Text)

  • Title (Text)

  • Created on (Created on)

  • ID (Formula)

  • Importance (Single select)

  • Deadline (Date)

  • Is urgent (Formula)

  • Is high priority (Formula)

  • Desired start date (Formula)

Views

  • All tasks (grid)

  • Calendar: task schedule (calendar)

Tasks

Fields

  • Name (Formula)

  • Category (Single select)

  • Description (Text)

  • Title (Text)

  • Created on (Created on)

  • ID (Formula)

  • Importance (Single select)

  • Deadline (Date)

  • Is urgent (Formula)

  • Is high priority (Formula)

  • Desired start date (Formula)

  • Expected workload (Number)

  • Contractor (Link to table)

  • Required fields valid (Formula)

  • Contractor valid (Formula)

  • Task is valid (Formula)

Views

  • All tasks (grid)

  • Valid tasks (grid)

  • Invalid tasks (grid)

Contractors

Fields

  • Company Name (Text)

  • Address (Text)

  • Email (Email)

  • Phone (Phone number)

  • VAT Number (Text)

  • Check VAT (Formula)

  • Tasks (Link to table)

Views

  • All contractors (grid)

Tasks

Fields

  • Name (Formula)

  • Category (Single select)

  • Description (Text)

  • Title (Text)

  • Created on (Created on)

  • ID (Formula)

  • Importance (Single select)

  • Deadline (Date)

  • Is urgent (Formula)

  • Is high priority (Formula)

  • Desired start date (Formula)

  • Expected workload (Number)

  • Contractor (Link to table)

  • Required fields valid (Formula)

  • Contractor valid (Formula)

  • Task is valid (Formula)

  • Final start date (Formula)

Views

  • All tasks (grid)

  • Valid tasks (grid)

  • Invalid tasks (grid)

Contractors

Fields

  • Company Name (Text)

  • Address (Text)

  • Email (Email)

  • Phone (Phone number)

  • VAT Number (Text)

  • Formula (Formula)

  • Tasks (Link to table)

Views

  • All contractors (grid)

Tasks

Fields

  • Name (Formula)

  • Category (Single select)

  • Description (Text)

  • Title (Text)

  • Created on (Created on)

  • ID (Formula)

  • Importance (Single select)

  • Deadline (Date)

  • Is urgent (Formula)

  • Is high priority (Formula)

  • Desired start date (Formula)

  • Expected workload (Number)

  • Contractor (Link to table)

  • Required fields valid (Formula)

  • Contractor valid (Formula)

  • Task is valid (Formula)

  • Final start date (Formula)

  • Details (Formula)

  • Actual start date (Date)

  • Start task (Formula)

Views

  • All tasks (grid)

  • Valid tasks (grid)

  • Invalid tasks (grid)

Contractors

Fields

  • Company Name (Text)

  • Address (Text)

  • Email (Email)

  • Phone (Phone number)

  • VAT Number (Text)

  • Formula (Formula)

  • Tasks (Link to table)

Views

  • Grid (grid)

Tasks

Fields

  • Name (Formula)

  • Category (Single select)

  • Description (Text)

  • Title (Text)

  • Created on (Created on)

  • ID (Formula)

  • Importance (Single select)

  • Deadline (Date)

  • Is urgent (Formula)

  • Is high priority (Formula)

  • Desired start date (Formula)

  • Expected workload (Number)

  • Contractor (Link to table)

  • Required fields valid (Formula)

  • Contractor valid (Formula)

  • Task is valid (Formula)

  • Final start date (Formula)

  • Details (Formula)

  • Actual start date (Date)

  • Start task (Formula)

  • Assets (Link to table)

Views

  • All tasks (grid)

  • Valid tasks (grid)

  • Invalid tasks (grid)

Contractors

Fields

  • Company Name (Text)

  • Address (Text)

  • Email (Email)

  • Phone (Phone number)

  • VAT Number (Text)

  • Formula (Formula)

  • Tasks (Link to table)

Views

  • All contractors (grid)

Asset repository

Fields

  • Name (Formula)

  • File (File)

  • is Image (Formula)

  • Task (Link to table)

Views

  • All assets (grid)

  • Image assets (grid)

  • Other assets (grid)

  • Add new asset (form)

Tasks

Fields

  • Name (Formula)

  • Category (Single select)

  • Description (Text)

  • Title (Text)

  • Created on (Created on)

  • ID (Formula)

  • Importance (Single select)

  • Deadline (Date)

  • Is urgent (Formula)

  • Is high priority (Formula)

  • Desired start date (Formula)

  • Expected workload (Number)

  • Contractor (Link to table)

  • Required fields valid (Formula)

  • Contractor valid (Formula)

  • Task is valid (Formula)

  • Final start date (Formula)

  • Details (Formula)

  • Actual start date (Date)

  • Start task (Formula)

  • Assets (Link to table)

  • Add asset (Formula)

Views

  • All tasks (grid)

  • Valid tasks (grid)

  • Invalid tasks (grid)

Contractors

Fields

  • Company Name (Text)

  • Address (Text)

  • Email (Email)

  • Phone (Phone number)

  • VAT Number (Text)

  • Formula (Formula)

  • Tasks (Link to table)

Views

  • All contractors (grid)

Asset repository

Fields

  • Name (Formula)

  • File (File)

  • is Image (Formula)

  • Task (Link to table)

Views

  • All assets (grid)

  • Image assets (grid)

  • Other assets (grid)

  • Add new asset (form)

Tasks

Fields

  • Name (Formula)

  • Category (Single select)

  • Description (Text)

  • Title (Text)

  • Created on (Created on)

  • ID (Formula)

  • Importance (Single select)

  • Deadline (Date)

  • Is urgent (Formula)

  • Is high priority (Formula)

  • Desired start date (Formula)

  • Expected workload (Number)

  • Contractor (Link to table)

  • Required fields valid (Formula)

  • Contractor valid (Formula)

  • Task is valid (Formula)

  • Final start date (Formula)

  • Details (Formula)

  • Actual start date (Date)

  • Start task (Formula)

  • Assets (Link to table)

  • Add asset (Formula)

  • Assignee (Link to table)

  • Status (Single select)

Views

  • All tasks (grid)

  • Valid tasks (grid)

  • Invalid tasks (grid)

Contractors

Fields

  • Company Name (Text)

  • Address (Text)

  • Email (Email)

  • Phone (Phone number)

  • VAT Number (Text)

  • Formula (Formula)

  • Tasks (Link to table)

Views

  • All contractors (grid)

Asset repository

Fields

  • Name (Formula)

  • File (File)

  • is Image (Formula)

  • Task (Link to table)

Views

  • All assets (grid)

  • Image assets (grid)

  • Other assets (grid)

  • Add new asset (form)

Team members

Fields

  • Name (Text)

  • Email (Email)

  • Phone (Phone number)

  • Tasks (Link to table)

  • Open expected workload (Formula)

Views

  • All team members (grid)

Tasks

Fields

  • Name (Formula)

  • Category (Single select)

  • Description (Text)

  • Title (Text)

  • Created on (Created on)

  • ID (Formula)

  • Importance (Single select)

  • Deadline (Date)

  • Is urgent (Formula)

  • Is high priority (Formula)

  • Desired start date (Formula)

  • Expected workload (Number)

  • Contractor (Link to table)

  • Required fields valid (Formula)

  • Contractor valid (Formula)

  • Task is valid (Formula)

  • Final start date (Formula)

  • Details (Formula)

  • Actual start date (Date)

  • Start task (Formula)

  • Assets (Link to table)

  • Add asset (Formula)

  • Assignee (Link to table)

  • Status (Single select)

  • Week (Formula)

Views

  • All tasks (grid)

  • All tasks grouped by week (grid)

  • Valid tasks (grid)

  • Invalid tasks (grid)

Contractors

Fields

  • Company Name (Text)

  • Address (Text)

  • Email (Email)

  • Phone (Phone number)

  • VAT Number (Text)

  • Formula (Formula)

  • Tasks (Link to table)

Views

  • Grid (grid)

Asset repository

Fields

  • Name (Formula)

  • File (File)

  • is Image (Formula)

  • Task (Link to table)

Views

  • All assets (grid)

  • Image assets (grid)

  • Other assets (grid)

  • Add new asset (form)

Team members

Fields

  • Name (Text)

  • Email (Email)

  • Phone (Phone number)

  • Tasks (Link to table)

  • Open workload (Formula)

  • This week (Formula)

  • Next week (Formula)

  • This week occupation (Formula)

  • Next week occupation (Formula)

Views

  • All team members (grid)

Application: Case 6 - Task Management

Task details

Data sources

  • Task details
Your product team’s OKRs. In one place.
Join thousands of teams and individuals who are creating their best work yet.
Sign up for free Contact sales