🗝 Tips to get started with Baserow, divided by first-day users, experienced builders, and developers

First-day Baserow users

:arrow_forward: Before you start: Learn how Baserow works

Let’s get started with a quick overview of the basics:

:arrow_forward: Experiment with templates

Explore over 70 tried-and-true (and completely editable) templates for work and life.

:arrow_forward: Model your Baserow data like a pro

Follow these guidelines to ensure that your data is structured properly in a database.

:arrow_forward: Organize your data however you like

Each view is based on a model of the data and the view you are currently looking at reflects your data in a specific model.

Gallery view is best for social media content dashboards, mood boards, employee directories, and more.
Kanban view is best for bug tracking, release planning, project management, and more.
Calendar view is best for resource management, event planning, monthly scheduling, and more.
Form view (we have both — Form and Survey modes) is best for online ordering, application submissions, feedback collection, and more.
With Personal views, you can now create individual views with custom configurations (custom filtering, sorting, row coloring).

View configuration options: Export view, Duplicate view, Filtering view, Importing a file, Sharing view, Row coloring, Create webhooks.

:arrow_forward: Add workspace collaborators

:large_blue_circle: Share a specific view: create a private shareable link to the view.
:large_blue_circle: Add a user to your workspace: in Baserow Free and Premium plans, you can add Admins or Members to your workspace, in Baserow Advanced and Enterprise plans, you can assign members one of the following roles – Admin, Builder, Editor, Commenter, Viewer, No Access or No Role at three levels: Workspace, Database, and Table.

:arrow_forward: Speed up your workflow with keyboard shortcuts

Navigate Baserow with your keyboard using these shortcuts to quickly move between different areas of the platform.

:arrow_forward: Open an entire row

Expand a row in one click by clicking on the icon to the left of the row to see all the details about the row.

:arrow_forward: Learn Baserow formula fundamentals

Maximize your usage of Baserow formulas with these examples and helpful tips.

:arrow_forward: Set a timezone for your date field types

Select a timezone for your date fields or optionally see the dates in your local timezone. If you want to switch from one timezone to another, Baserow will do an automatic conversion in a few seconds.

:arrow_forward: Visualize your data stored in Baserow

:large_blue_circle: Highlight key details with colors: use row coloring to group rows by specific criteria.
:large_blue_circle: Build charts: generate charts from Baserow using this community-powered app: Baserow Explorer.

:arrow_forward: Build PDF files

Create PDF files with Baserow data using the Baserow PDF Generator app in Appsmith.

:arrow_forward: Protect yourself against accidental data loss

Baserow provides three ways to protect against data loss:

:muscle: Small tricks and hacks to achieve more with Baserow:

:magic_wand: Row identifier: use the row_id() formula to return the unique identifying number of a row.

:magic_wand: Rollup field workaround: combine the lookup formula function with any mix of aggregate functions to achieve even more advanced functionality.

:magic_wand: Button field workaround: create a button using the URI (first argument) and label (second argument).

:magic_wand: Delete multiple rows in bulk: if you need to delete 1000+ rows you can try using this workaround.


For experienced users

:arrow_forward: Get step-by-step guides

Dig into dozens of articles to help you learn Baserow:

How to create REST API from a CSV file
How to generate unique IDs with Baserow formula
How to generate content with OpenAI’s GPT-3 and Baserow
How to use link row data to pre-fill forms automatically
How to update row data with Baserow forms

:arrow_forward: Connect Baserow with tools you use every day

We offer official integrations with:
Internal app builder: ToolJet.
Automation: n8n, Zapier, Make, Pipedream.

Alternatively, you can use our advanced API to integrate Baserow into your current tech stack. Here are some examples of how to connect Baserow with other tools:

AppSmith
Retool
Bubble
Webflow
Flutterflow
Softr

:arrow_forward: Trigger actions with Baserow webhooks

Receive real-time notifications about all changes that are made in your database by setting webhooks.

:arrow_forward: Stay up-to-date with Baserow updates and changes

Find out what’s new and what’s changed in Baserow by checking out the changelog or reading the release blog posts.

:arrow_forward: Check your current Baserow version with one click

Determine the version of Baserow you’re currently running by opening the API spec docs.

:muscle: Small tricks and hacks to achieve more with Baserow:

:magic_wand: Strong primary field: ensure that your primary field is informative and unique. Turn it into a formula field and pull together a set of data in it.

:magic_wand: Computed fields: reference the latest information from linked records, create custom calculations, and more with Last modified and Created on field types.

:magic_wand: Zapier Catch Hook webhook trigger: generate a custom webhook URL for sending requests. The trigger generates a unique URL where you can make POST requests.


For developers

:arrow_forward: Submit technical questions using this guide

To receive assistance quickly, please answer the following questions when opening a new technical help topic.

:arrow_forward: Easy way to debug any Baserow issues you might be having

Baserow 1.17.0 includes a new admin Health Check page to help you debug issues. Additionally, there is an Email Tester feature that shows detailed errors if your Baserow is not configured to send emails correctly.

:arrow_forward: Debugging connection issues

If you encounter the error message “Backend URL mis-configuration detected” when launching Baserow, or if you are having trouble connecting to your Baserow server, this tutorial explains why this error can occur and how to fix it.

:arrow_forward: Check out Baserow Formula technical guide

This guide explains the inner workings of Baserow formulas for developers.

:arrow_forward: Contributing code

If you’re a developer looking to contribute to the Baserow code, check out this list of good first issues.

:arrow_forward: API deprecations

To ensure that your application runs smoothly and without downtime, use this page to check out the latest API integrators. It lists which features are deprecated and how long we’ll continue to support compatibility for them.


Community activists

If you need urgent help, you can tag some of our community activists or @olgatrykush in your question. Here is an overview of what our activists are most skilled at:

  • @Peter is one of our first community members and is knowledgeable about how things are set up in Baserow. Feel free to contact Peter if you have any general questions.
  • @lucw built the first community-powered plugin and is an expert in this area. If you are working on the same project, feel free to ping Luc for advice.
  • @frederikdc is a no-code expert who can help with formulas, relations, and automation.
  • @joffcom is our technical leader and can troubleshoot questions related to self-hosting, API, or n8n (Jonathan is a part of the n8n team).

Don’t hesitate to message me in case of any questions or issues :raised_hands:


Switching to Baserow from Excel? How to transform any Spreadsheet into a Database!

Switching to Baserow from Airtable? How to Migrate from Airtable to Baserow in one Click.

1 Like