Grid view
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.
Overview
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 customize 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:
- Export view
- Webhooks
- Rename view
- Delete view
Create a Grid view
To add a grid view:
- Open up the view dropdown by clicking on the view switcher in the top left-hand portion of the table
- Click on the Grid + button to bring up a menu where you will enter a name for this new view
- Click Add grid.
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.
Tip 💡: Using your keyboard shortcut,
Shift+Enterto move to the row 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.
Filter grid view
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.
Tip 💡: Double-click a grid field name to make quick edits.
Sort grid view
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.
Default sorting
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.
Automatic sorting
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.
Manual sorting
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 organize 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.
Share grid view
After creating a Grid, you have the option to share the link with anyone. When you decide to share the view, you have the flexibility to control how others perceive the shared information by utilizing Filters or Hide fields.
To embed a view via an iframe. Share a grid view publicly, copy the publicly shared URL, and replace YOUR_URL in the code snippet below:
<iframe src="YOUR_URL" frameborder="0" width="100%" height="400"></iframe>
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,
- select the ‘Hide fields’ link at the top of the page.
- Click the toggle next to the name of that field to turn on the fields you want to display and turn off the fields you want to hide.
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 reorganize 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, and then selecting the Hide field option from the dropdown menu.
Adjust the width of a field
By default, grid views display rows at a fixed width. Nevertheless, if you prefer to view more data within each cell, you have the option to adjust the column width. This attribute allows you to customize the width of columns based on the content present in the cells of that particular column.
To expand a single field at a time,
- Click and hold your mouse on the dividing line next to the title of any field to lengthen or shorten the width as desired.
- Drag the line to increase the width. You’ll see a blue bar appear with the indicator.
- Unclick at the desired width to view more information in each cell.
Footer aggregations
The footer aggregations compute values based on a field. Aggregations are performed to calculate values based on a specific field in a table.
By default, the footer summary for each field is empty. To obtain a summary of a specific field, visit this support documentation.
Related content
- View configuration options.
- Work with gallery views.
- Work with form views.
- Work with kanban views.
- Work with calendar views.
Still need help? If you’re looking for something else, please feel free to make recommendations or ask us questions—we’re ready to assist you.
Contact support for questions about Baserow or help with your account.