Columns and rows are different ways that data can be organized into a grid. Rows and columns are different when it comes to data organization. The column width attribute can be adjusted based on the content of the cells in the column.
Data in a column is aligned vertically from top to bottom, while data in a row are arranged horizontally from left to right.
A Row ID is a number that uniquely identifies that row of data. Note that, the row ID is not intended to count the number of rows in a table. When a row is deleted, the rows that remain are not renumbered. The assigned number is permanently attached to a row and cannot be changed or deleted, even after the row is deleted. The numbering may then have gaps as a result.
A row count automatically generates a unique, automatically incremented number for each record. You can switch between the row numerical count and row identifier by clicking the field header. By switching to row count, you can see numbering without gaps.
Making a new row on Baserow is simple. There are three ways to make a new row:
You can also create a new row directly from the row select modal. To do this, click the ‘+’ button while choosing a relationship in the link to table field.
You can reorder rows in a table by dragging and dropping them.
To reorder your views,
⠿on the left-hand side of the view
Note that you can only reorder rows when there is no manually sorting of the grid. For more details on sorting rows manually and automatically within a grid view, check this article.
New grid views by default show rows at a set width. However, if you’d like to be able to see more data for your cells, then you can adjust the column width.
To expand a single row at a time,
To duplicate a row, you need to right-click on a row and select the duplicate row option from the dropdown.
To delete an individual item in a row, right-click on the row and select ‘Delete row’.
To multi-select a row, hold down the mouse and drag across the rows to select the.
Multi-selecting rows are limited to 200 selections at a time.
Copy and paste your Row information into another Row in Grid view with ease. Simply select the cells you wish to copy by clicking and pasting them with a keyboard shortcut -
You can easily expand a row with one click! You can expand a row by clicking on the icon to the left of the row.
Within an expanded row, you can add a new view, view the rows activity field and rows revision history to the right of the page.
If there are hidden fields within your table, this will also be hidden in the enlarged view.
Commenting on rows is only available in the Premium version only.
To view which rows have comments on them, there will be a number indicator beside the rows that have comments in them, showing how many comments have been made.
Click on the enlarge row icon to view all the comments that have been made.
You’ll see a comment box at the bottom right of the enlarged row where you may start typing to leave a comment. Just above the comment box, you’ll find a feed of any recent comments. To comment on a row, drop a comment in the form on the right side of the enlarged view.
This action is restricted to Premium accounts to allow collaborators to color-code rows.
Using row coloring, you can apply colors to the rows in a grid view. You can also use row outlines to create contrasts among rows. Row colors and outlines are particularly useful when you want to look for patterns within a single view.
Since row coloring is implemented at the view level, each view can have a different configuration without affecting other views. You can apply row coloring to grid views, gallery views and kanban views.
You can colour your rows based on two values:
You can automatically colour rows using custom filtering conditions, or you can add colour to rows by matching the colour of the row to the colour of an associated single select field.
To add a color,
Note that you can only have one decorator of a type for a specific view.
Row coloring by single select field
You can colour the row cards in your view depending on the single select field that was used to build the card. This is especially useful if you need to quickly identify which cards came from specific fields, such as when tracking task progress.
If you choose a Single select field option, select a single select field within your Grid that should the row be colored by. If your table does not have an existing single select field, you will be prompted to create one.
If there is more than one single select option, choose the desired field using the radio buttons. You can also add a new single select field and options to your table.
Row coloring by conditions
You can set rules by coloring records depending on conditions, and any record that satisfies those rules will instantly take on the assigned color. This is similar to creating conditions for filtering rows.
If you choose a field and condition, add color and condition to define which fields are colored and what color is used.
Add conditions by clicking on the ‘Add condition’ button or ‘+ add color’ to apply a color by default.
When a color is set, the color button will be highlighted and the number of colors stated.
To change a row color value,
You can also change the value of each color modification.
To delete a row color modification,
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!