View Customization

There are several ways to manipulate records within a table, and each method has a different appearance. You can define views for each table in your database, allowing you to control the fields, records, and other settings that appear in the view.

Customization options are available at the top of each view. Your customizations for field display are saved for each view, so you can have different preferences of your data without affecting all your Views. Each modification to the view is saved, so you can easily refer back to it.

Filter view

To make prioritization easier, use filters to apply single or multiple criteria to tasks. Filters allow you to show rows that apply to your conditions.

Because views work with rows in a similar way to how they work with tables, filtering a view discards records rather than deleting them. Simply choose one or more filters to sort your table by. For example, you can select a due date and a priority to see only tasks on your most important projects that are due soon.

Adding a new filter

You must choose a field, a condition, and a value before you can set a specific condition.

enter image description here

You can use a condition to create a rule that the records must follow to be visible in the current view.

To add custom filters to a view, you can show rows that apply to your conditions by clicking on the Filter link in the view bar at the top right of your table:

  1. Click ’+ Add Filter’
  2. Choose any field you want to filter your table by from the dropdown.
  3. Choose the condition you want to use, i.e. Contains, Contains not, is, is not, is empty, is not empty, higher than, lower than, length is lower than, is date, is not date, is today, is days ago, in this month, is after date, is before date, day of month is, in this year, in this month, has, has not, etc.
  4. Define the value of the field you want to see, i.e. a specific word, status or number.

enter image description here

You can easily remove filters by clicking the X icon next to them in the filter menu.

Customizing your filtering conditions with multiple conditions

View only the rows that fit certain criteria, depending on what you need by customizing your filtering conditions with multiple conditions. In order to create more complicated filtering, we can chain together several conditions. You can use this method to apply numerous filters at once using the And or Or conditions.

  • Use And when you want all conditions to be met.
  • Use Or when you’d like any condition to be met.

To add another condition for a color, click the ‘Add condition’ button. Adding a second condition creates a condition group with all the conditions connected via And or Or.

Disabling and enabling multiple filter options

You can toggle the ‘all disabled’ box to enable or disable all existing fields within the page. This will not remove the filters from the table but will only disable them from applying.

enter image description here

As you activate each filter condition, notice how the aggregated values at the bottom of the screen adjust accordingly to reflect the number of rows visible.

Export view

This option is restricted to the Grid view only.

Data on the Grid view can be exported in three ways:

  • Export to CSV
  • Export to JSON, currently available only with Premium subscription.
  • Export to XML, currently available only with Premium subscription.

To export a view,

  1. Click on the ellipsis ••• beside the required view you want to export to open your view settings.
  2. Select ‘Export view
  3. Select the view to export
  4. Choose the file format you would like to export
    • When exporting as CSV, you have additional options to select a Column separator and Encoding. The default delimiter to separate values with is a comma ,. Other delimiters include ;, |, <tab>, record separator (30), unit separator (31).
    • Encoding converts the data into a format that can be supported and used by different systems.
    • If the first row is header, tick the option.
  5. Click ‘Export’ and Download

enter image description here

Import additional data into existing tables

You can import a CSV file, a JSON file, an XML file with tabular data, or copy the cells from a spreadsheet and paste the table data.

To import a file into an existing table,

  1. Click on the ellipsis ••• beside a view to open your view settings.
  2. Select ’Import file
  3. Select the file type you would like to import and click ‘Import

The columns of the Baserow fields will be automatically mapped to the correct fields in your table. You can optionally change the mapping by choosing the desired target field, or use the mapping to manually set up the logic of which fields to merge and where. Any incompatible cell will remain empty after the import.

enter image description here

Rename a view

To rename an existing view,

  1. Click on the ellipsis ••• beside the required view
  2. Select ‘Rename view
  3. Enter the new name of the view

enter image description here

Delete a view

To delete a view, click the view menu button (…) and then select “Delete view” at the bottom of the dropdown.

To delete an existing view,

  1. Click on the ••• beside the required view
  2. Select ‘Delete view

enter image description here

Organize a view

To change the order of your views, select the view and drag to a new order.

enter image description here

Duplicate a view

To duplicate a view, you need to click on the view’s options at the top left side of the table and select the duplicate view option from the dropdown.

enter image description here

Create Webhooks

Webhooks can be used in order to inform 3rd party systems when a row in Baserow has been created, updated or deleted. You can send a webhook when an event occurs in an app.

https://baserow-media.ams3.digitaloceanspaces.com/pagedown-uploads/Untitled%2012.png

For more on creating a webhook, you may find our help section useful.

If you’re looking for something else, please feel free to make recommendations or ask us questions in our online community —we’re ready to assist you!