This article reviews how to use the column settings for Grid views.
To access the column settings for a specific column, simply hover over the column in the page preview and click on the pen icon to edit.
This action will open the column settings in the toolbox located on the left side of the grid preview. From there, you will have the ability to modify the properties, layout, and display rules of the column.
In the properties section, you have the ability to modify basic information about the column and its functionality.
Within this section, you can control the following settings, depending on the configuration of your grid and the types of fields used:
- Page to link to: The column displays a link to the page that it is linked to for view and edit action links. This functionality cannot be edited.
- Field: This displays the field that is utilized for that column. Editing this is not possible.
- Header: The text that is utilized as the column header.
- Grouping: Specifies a specific field to be utilized for grouping the grid.
- Group Order: Specifies the order in which the grouped field will be sorted.
- Link Type: Select whether to use custom text or a field value for the link text.
- Link Text: Specify custom text to be used as the link.
- Link Field: Choose a field to display as the link.
- Icon: Include an icon to represent record links for viewing, editing, and deleting records.
- Connection Link: If you are using a connected field, you have the option to enable this field to link to another related page in your app.
- Connection Separator: For connection fields that have numerous connected records, you have the option to specify how these values will be separated, either by using a comma or by displaying them on a new line.
- Truncate Text: If you are working with paragraph fields, you have the ability to truncate the text if needed.
- Character Limit: When the "Truncate Text" option is enabled, you have the ability to specify the maximum number of characters allowed in the field.
- Allow inline editing: Deactivate/activate inline editing for a specific field.
- Allow summary: Deactivate/activate column summaries for a specific field.
Page to Link to
For columns that contain action links to view or edit the record, this will specify the page within the app that the column links to. This field cannot be edited, but clicking the link will take you to that page within the Builder.
The “Field” option in the properties will display the name of the field shown in that column. When editing columns, the field name is not editable and can only be changed by changing the name of the field in the Data section of the Builder.
Connected fields will display with the connected table's name followed by the connection field's name.
The name of the column header will default to the name of the field in the table, but can be changed in the editor:
This text will display as the column header in the Live App.
To organize your records based on a shared value in a specific Grid column, you can select the "Grouping" option when editing the column. This allows you to specify which column(s) should be used for grouping.
Once grouping has been enabled, a “Group Order” option and “Group Position” option will be available.
The “Group Order” allows you to define how you will sort your grouped records. The “Group Position” allows you to define in which order records will be grouped if more than one group is used.
Any columns with grouping enabled will be automatically moved to the front of the grid. Here is an example of Products being grouped by an "In stock" field:
Note: If your grid is displaying any row summaries, such as totals or averages, those will also be displayed for the first level of each group.
For columns that contain record links to view, edit, and delete the record, it's possible to show either text as the link or a specific field value.
Choosing “Text” will allow you to use custom text for that link. Whereas, using “Field” will allow you to select a specific field in that table which can be used for the link.
For columns that contain record links to view, edit, and delete the record, it's possible to add an icon along with the text. Here, you can select the icon to show along with the link.
When adding fields from connected records, you can display these field values as a link. The value links allow you to link to another page in your app which can display these connected records. This option is only available under connected field columns.
When adding fields from connected tables which have multiple connected records, you can choose how multiple values will display in your grid. They can either be separated by commas or listed on a new line.
This option is only available under connected field columns.
When using paragraph fields in a grid column, you can choose to truncate the text. This will limit the number of characters which are shown in the paragraph field for each record.
Allow Inline Editing
Inline editing allows the user to edit each field directly in the grid without using a form view. To enable inline editing, click on the "Inline Editing" checkbox under "Options".
When enabled, the user can click on a grid cell and a form pops over it to edit that cell:
Once inline editing has been enabled, it will affect all columns. You will need to manually disable it for each column.
To disable inline editing, you can edit each grid column to disable it for that column. When editing a column, select the "No" radio button for "Allow Inline Editing" in order to disable inline editing for that column:
Note: Once a field has one or more conditional rules, you will not be able to edit records inline. The conditional rules would just overwrite any manually set values.
When column summaries are enabled on a grid view, this will show a summary row below the grid for all number fields. This option will allow you to disable this row summary for specific number fields.
From the Design section, you can adjust a column’s width and change the alignment of records:
Choose either a default width for your column or you can use a custom width of your choosing. The default width is based on the field name's length.
You have two options for setting the custom width of a field:
- Pixels: Define the width of the field in terms of pixels.
- Percent: Define the width of the field in terms of percent of the page. For example, entering "20" would make the column 20% of the width of the page.
Note: You cannot make a column's width smaller than the width of the column's header or the longest continuous string of characters in a field value (Example: A long link or file name).
This will align the data in that column based on your choice. You can choose to have data aligned to the left, center, or right.
Using display rules, you can add rules to update the column's display:
A display rule is added by defining the conditions (if) that trigger the actions (then):
If: The condition(s) that will trigger the actions when the condition is true. More than one condition can be added to trigger the action, in which case, every condition must be true.
Then: The action to trigger when the condition is met. There are five actions that can be triggered by display rules:
Set Text Color
Set Text Style
Set Background Color
Tip: You can learn more on using display rules here.