Adjust column widths, row height, and line spacing in grid reports

Both builders and end users have control over column widths, row heights, and cell spacing in grid reports. These settings are organized in a hierarchy:

• Builders set the default column width, row height, and spacing settings for all reports in an app.

• Builders can override those settings for a specific report.

• End users can adjust the visual settings for any report according to their preferences.

Column widths

Builders can set default column widths for each field. To do this:

1. Open a field’s Field properties menu.

2. Go to Behavior > Default column width and set your desired width in pixels.

3. This default width applies to that field on any standalone or embedded report where it’s included.

End users can override builders' default settings to adjust widths as desired. Users' adjusted column widths are remembered on any standalone or embedded report on forms and dashboards.

There are multiple ways to adjust column widths:

• Drag column borders

• Double-click column borders to autosize

• Open a column’s More menu and select Autosize this column or Autosize all columns shown

Row height

Row height refers to the number of lines of data displayed for each record in a grid report. Choose from the following row height options:

• Short (1 line)

• Medium (3 lines)

• Tall (5 lines)

• Extra Tall (10 lines)

• Max (20 lines)

When you set the row height, it applies to all records in the report.

Default row height for grid reports in a table

Builders can set the default row height for each table in the default report settings under Options.

Initial row height for individual reports

Builders can also set the initial row height for each report individually (overriding the default report setting). This is done in the report settings menu for that specific report.

End user row height settings

End users can set their own row height preference (overriding the builder’s default setting) by using the Change row height button on the grid report. This selection will be remembered the next time the report is viewed as a standalone or embedded report.

Spacing

Spacing in grid reports refers to the padding or room around the content of a cell. Users can select their default UI spacing (relaxed, regular, or condensed) for all reports in the user preferences menu.

To override this default setting for individual grid reports, open the report’s More actions menu and choose one of the spacing options (relaxed, normal, or condensed).

Tip

Try different combinations of row height and spacing until you find your preferred display. For example, a short row height with condensed spacing maximizes the content shown on screen.