ToolJet integration

Build internal tools and admin panels powered by Baserow data using ToolJet’s low-code platform. Connect to 30+ data sources, create custom queries, and build full applications without extensive coding. Perfect for teams building CRMs, dashboards, and data management tools.

To build applications within Baserow, try out Baserow Application Builder.

Overview

ToolJet is an open-source low-code platform that lets you build internal applications and admin panels quickly. When connected to Baserow, you can create custom interfaces for your databases, build dashboards, and perform complex data operations through a visual interface.

Why use ToolJet with Baserow? Build production-ready internal tools in hours instead of weeks. Connect Baserow data with other services like PostgreSQL, APIs, or cloud storage to create powerful business applications. Ideal for teams that need custom interfaces without hiring developers.

Prerequisites

Before you begin, you’ll need:

Supported operations

ToolJet provides full CRUD (Create, Read, Update, Delete) functionality for Baserow tables:

Operation Description Common use case
List fields Retrieve all field names and types from a table Build dynamic forms, validate data schemas
List rows Get all rows from a table with optional filters Display data in tables, create reports
Get row Retrieve a specific row by ID Show detailed record views, edit forms
Create row Add a new row to a table Submit forms, add new records
Update row Modify an existing row Edit records, update statuses
Move row Change a row’s position in the table Reorder tasks, manage priorities
Delete row Remove a row from a table Archive records, clean up data

Required parameters

Each operation requires different parameters:

  • Table ID: Found in your Baserow API documentation
  • Row ID: The unique identifier for a specific row
  • Before ID: (Move row only) Insert before this row ID, or leave empty to move to the end
  • Records: (Create/Update) Field values in JSON format

How to connect Baserow to ToolJet

To establish a connection with the Baserow data source, you can either click on the + Add new Data source button located on the query panel or navigate to the Data Sources page through the ToolJet dashboard.

Step 1: Add Baserow as a data source

  1. Open the data sources panel: In ToolJet’s app builder, click the Data sources tab in the left sidebar.

  2. Select Baserow: Search for “Baserow” in the data source modal. Click on Baserow to select it

  3. Configure connection settings: Select either the Development, Staging or Production environment.

    • Enter your Baserow API token (create one in Baserow settings)
    • Select your Baserow type:
    • Click Save to store the connection

Note: ToolJet encrypts sensitive fields like API tokens before storing them in its database.

Step 2: Create queries to interact with Baserow

Queries let you request and manipulate data from your Baserow tables. Each query performs one operation (list rows, create row, etc.).

  1. Open the query editor: Click the + icon in the query editor panel. Select your saved Baserow data source

  2. Choose an operation: Select an operation from the dropdown menu. Enter the required parameters (Table ID, Row ID, etc.)

  3. Test the query. Click Run to test the query. View the response data in the preview panel

  4. Connect to components: Bind query results to tables, forms, or charts. Trigger queries on button clicks or form submissions

Common query examples

List all rows from a table

Use this to populate tables or dropdown menus:

  • Operation: List rows
  • Table ID: Your table’s numeric ID
  • Optional filters: Add search or sort parameters

List all rows from a Baserow table in ToolJet

Create a new record from a form

Build forms that save directly to Baserow:

  • Operation: Create row
  • Table ID: Your destination table
  • Records: Map form fields to Baserow columns using {{ components.form1.data }}

Create a new Baserow record in ToolJet

Update a record based on user input

Let users edit existing records:

  • Operation: Update row
  • Table ID: Your table’s ID
  • Row ID: {{ table1.selectedRow.id }}
  • Records: Include only the fields you want to update

Update a Baserow record in ToolJet

Delete selected records

Add delete functionality with confirmation:

  • Operation: Delete row
  • Table ID: Your table’s ID
  • Row ID: {{ table1.selectedRow.id }}

Use cases and examples

  • Custom CRM system: Build a full-featured CRM with contact management, deal tracking, and activity logs. Connect Baserow customer data to email services and calendar tools.
  • Admin dashboard: Create internal dashboards that display key metrics from multiple Baserow tables. Add charts, filters, and real-time updates.
  • Inventory management: Build tools to track stock levels, process orders, and manage suppliers. Connect to external APIs for shipping and payment processing.
  • Support ticket system: Design a helpdesk interface where team members can view, assign, and resolve customer tickets stored in Baserow.
  • Project management tool: Create custom project trackers with task boards, timelines, and resource allocation views powered by Baserow data.

Frequently asked questions

What’s the difference between ToolJet and other Baserow integrations?

ToolJet focuses on building visual applications with user interfaces. Unlike n8n or Zapier which automate workflows in the background, ToolJet creates apps that people interact with directly. Use ToolJet when you need dashboards, forms, or admin panels. Use automation platforms for scheduled tasks and data syncing.

Can I connect multiple Baserow databases in one ToolJet app?

Yes. Add multiple Baserow data sources with different API tokens to access different workspaces or accounts. Each data source appears as a separate option when creating queries.

Do I need coding skills to use ToolJet with Baserow?

No, but basic understanding helps. ToolJet uses a visual interface for most tasks. You may need to write simple JavaScript expressions for complex data transformations or conditional logic, but many apps can be built without any code.

To build applications within Baserow, try out Baserow Application Builder.

How do I find my Table ID for ToolJet queries?

Open your Baserow database and click the three-dot menu. Select “API Documentation” to see all your Table IDs, field names, and data structures. Each table has a unique numeric ID like 12345.

Is my Baserow data secure when using ToolJet?

ToolJet encrypts API tokens before storing them. Data transfers use HTTPS encryption. For maximum security, use self-hosted versions of both Baserow and ToolJet within your own infrastructure. Review the security documentation for detailed information.

Baserow documentation

Integration guides

Tutorials

Still need help? If you’re looking for something else, please don’t hesitate to make recommendations or ask us questions; we’re here to assist you.