In this article, we’ll cover the process of creating and managing a grid view. Visit this support section to learn more about views in general.
If you’re used to using a traditional spreadsheet program like Microsoft Excel or Google Sheets, then you’ll feel right at home with the Baserow grid view. The grid view is the starting point to manage your data. Within this view, you can sort, filter, view, edit and export data at record speeds.
A grid view offers a more condensed way to look at a large number of items. A user can have a lot of data on a table, but still, be able to view all – even when the data is complex.
You can export grid views and non-members can access data contained via a public link.
You may customise a grid view by clicking the ellipsis next to it and making changes. To choose an action, click the ellipsis
••• at the top of any column:
To add a grid view:
The grid will be populated with existing data from other views.
Using the view switcher at the top-left of the table, you can easily switch between views you’ve created.
Baserow tip: Using your keyboard shortcut,
Enteron grid view to navigate to the field below.
To delete a grid view, click the view menu button (…) and then select ‘Delete view’ at the bottom of the dropdown menu that appears.
Grid views can be filtered. You can use filters to quickly locate those tasks that match multiple criteria. Simply select two or more filters from the list of filters. For example, you can limit which linked rows users can choose when filling out your form by using filtered views. The form’s users can only choose from the related records that are present in the selected view by choosing a view from this dropdown.
To add custom filters, you can show rows that apply to your conditions by clicking on the ‘+ Add filter’ button.
Sorting information is an integral part of the creative process for many people. Baserow makes that process simple by letting you sort rows by appropriate fields. You can sort the view automatically or manually to change the order in which the rows appear.
If you share a view with non-members using a view share link, note that sorting conditions applied to the view will be retained even after the view is shared.
When you create a new table, your data is sorted by when a new row is added. You can sort your rows in a view such that they display in a specific order based on the values in selected fields.
Click the sort button in the view bar to apply a sort to your current view. The sort menu will appear to reveal any sorts applied.
You can sort your rows by clicking the ‘Choose a field to sort by’ option. Once you’ve selected the field you want to sort by from the dropdown, fields will automatically be ordered based on the sort option.
You can add more sorts by picking more fields to sort by. To apply a new sort, click the ‘Choose a field to sort by’ and then select a field from the dropdown menu.
If you use the sort conditions, you will not be able to manually reorder rows with the drag-and-drop functionality.
When there are a few different columns to be sorted by, add the options in the order you want the fields to be sorted by.
To remove a sorting option, click on the
X button to the left of the sort option.
Thanks to the flexibility of Baserow views, you can rearrange your data to best fit your view of things in ascending or descending order. Sorting your table manually will allow you to organise your work in whatever way suits you.
You can change the order of rows when they are sorted by default by clicking and dragging the row using the drag handle on the left side of the row to manually reorder rows.
Once you’ve created a Grid, you can share the link with anyone. When sharing the view, you can control how others see what you share by using Filters or Hide fields.
The hide fields options within the grid view allow you to choose what you want to view and what you don’t. You can hide or show the fields in a table so that some of the fields are not visible, except for the primary field, which cannot be hidden. This is useful if you share a view via a public link and want to restrict access to some data.
Note that you won’t be able to hide/show the primary field.
To show or hide a field,
Record fields can be toggled individually or, you can quickly hide/show all fields using the ‘Hide all’ or ‘Show all’ buttons.
The Hide Fields dialog enables you to hide (gray out) or display (green) individual elements in a layout. Baserow will show you a preview of the number of fields that are currently hidden. If fields in the current view are hidden, the hide fields button will be highlighted and show the number of fields hidden.
If you have a lot of fields, you can use the ‘Search fields’ box to enter a term to help you find the field to hide or show quickly. You can also reorganise the order of the fields.
Another way to hide or show individual fields from a grid view is by opening up an expanded view or by clicking on the field header, then selecting the Hide field option from the dropdown menu.
The footer aggregations compute values based on a field. The footer can be used to quickly evaluate and summarize field values for a set of rows, except the lookup field. However, you cannot reference these values. You’ll see results for each column in your footer when you create an aggregation.
Each field’s footer summary is empty by default. To get the summary of a field:
The field type will determine the kinds of footer summaries that are available. Some summary functions will appear in date, single select, single line, phone number, email, file, multiple select, formula, link to table, long text, URL, last modified fields. These are:
In addition to the general function, certain functions will only appear in date, last modified and created on:
A special aggregation function for a boolean field allows you to see the number or percentage of checked and unchecked cells
In addition to the general function, you can use the number field footer aggregation to calculate the sum, minimum, or maximum of numeric data in Grid view columns. For numeric and rating fields:
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!