Navigating Row Configurations

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.

enter image description here

What is a Row Identifier and Count?

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.

enter image description here

How to make new rows

Making a new row on Baserow is simple. There are three ways to make a new row:

  • Click the last row at the bottom of the grid
  • Right-click on an existing row and select ‘Insert row above’
  • Right-click on an existing row and select ‘Insert row below’

enter image description here

Reordering rows

You can reorder rows in a table by dragging and dropping them.

To reorder your views,

  1. Identify the row you want to move
  2. Click and hold on the drag handle on the left-hand side of the view
  3. Move to its new location

enter image description here

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.

Adjust the width of each row

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,

  1. Click and hold your mouse on the dividing line next to the title of any field to lengthen or shorten the width as desired.
  2. Drag the line to increase the width. You’ll see a blue bar appear with the indicator.
  3. Unclick at the desired width to view more information in each cell

enter image description here

Duplicate a row

To duplicate a row, you need to right-click on a row and select the duplicate row option from the dropdown.

enter image description here

Deleting a row

To delete an individual item in a row, right-click on the row and select ‘Delete row’.

enter image description here

Multi-select rows

To multi-select a row, hold down the mouse and drag across the rows to select the.

enter image description here

Multi-selecting rows are limited to 200 selections at a time.

Moving rows using copy and paste functions

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 - cmd/ctrl + v.

0df7526080ef65ae7441e108b9e09ac37741ad49.gif

Enlarging rows

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.

enter image description here

Inside an enlarged view

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.

enter image description here

Commenting on Rows

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.

enter image description here

Click on the enlarge row icon to view all the comments that have been made.

enter image description here

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.

enter image description here

Row coloring

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.

enter image description here

You can colour your rows based on two values:

  • Single select: The only work for a single select field
  • Conditions: This value works on any field depending on the condition you want to use

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.

Add a color

To add a color,

  1. Click ’Color’ option in the view bar at the top of your table.
  2. Select the decorator type to colour your rows by
    1. Left Border - to color the left border of a row. Colors appear as color flags on the left side of the primary field of a grid view or on the left side of the kanban and gallery card.
    2. Background colour - Row coloring applies color to the entire row
  3. Define the value you want to color the left border by
    1. Single select: Select this option if you want to color rows the same as a single select value
    2. Conditions: Select this option if you want to color rows when they match the conditions

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.

enter image description here

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.

enter image description here

When a color is set, the color button will be highlighted and the number of colors stated.

Change Row coloring

To change a row color value,

  1. Click ’Color’ at the top right of your table.
  2. Select the specific decorator you want to delete, e.g. Left border or Background color
  3. Click the dropdown menu to select a new value, e.g. Single select or Conditions
  4. Configure the new value selected

enter image description here

You can also change the value of each color modification.

Delete Row coloring

To delete a row color modification,

  1. Click ’Color’ at the top right of your table.
  2. Select the specific decorator you want to delete, e.g. Left border or Background color
  3. Click the delete icon next to the color specification.

enter image description here

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!