Column Types

By default, the data given to the grid is displayed in cells as text. However, the content might be a path to an image you want to display or a URL link you want to be clickable. Fortunately, ZingGrid comes with a large collection of pre-built column types that handles this for you.

Adding Columns

Adding a type attribute to a column renders the data in a pre-formatted pattern. You can use these to quickly render your content in common formats.

Aggregate

Adding the aggregate type renders a column of aggregation values specified by typeAggregateValue. The aggregate value is calculated from the numbers

Related Attributes

Boolean

The boolean type renders a boolean value and uses a checkbox as an editor.

Button

Set the button type is render buttons in the column. Using the supporting attributes listed below to easily disable, add an icon and/or label, and handler to the button.

Related Attributes

Checkbox

Set the the checkbox type creates a cell that can be toggled. A checkbox will display when you try to edit the cell.

Related Attributes

Color

Set the color type to render the preview of the color and display a color picker when editing the cell. The type-color-mode attribute configures the mode of the color picker.

Related Attributes

Currency

Set the currency type to format a number into a currency display. By default, the value is displayed in US Dollars. To display a different currency, set the locale and type-currency attributes. Learn more about ZingGrid's internationalization features here.

Related Attributes

Date

Specifying the date type on a column assigns the date editor to the cells. This tells the grid how to validate the cell value when changed via the editor. The date type also can format dates or translate it to relative time.

Related Attributes

Duplicate

Adding the duplicate type adds the duplicate buttons to duplicate the row.

Editor

Adding the editor type adds row editor buttons to edit all cells within the row.

Element

Setting the element type renders the specified element that wraps around the cell content. This feature also extends to custom-elements, allowing you to easily render your own custom elements into the grid!

Related Attributes

Email

Setting the email type on the column renders the mailto link and tells the grid how to validate the cell value when changed.

Icon

Set the icon type to convert the cell data into a built-in grid <zg-icon name=""> element. By default, the value must match the name of a native grid icon or the name of a custom icon. You can read more about adding custom icons in the styling section.

You can also set your grid to display icons per an approved icon library, such as Font Awesome. To do so, include the icon library source and then set the [icon-set="fontawesome"] attribute on your ZingGrid instance. Once the grid knows how to render the new icon (in FA's case, it renders an <i> instead of the native grid SVG icon), you can set the cell value to any valid icon name and it should render.

Built-In Grid Icons

The following list shows the built-in grid icons and how they are mapped internally. The last entry, fa-smile-wink, is not a built-in type and showcases how you can display any valid Font Awesome icon.

Iframe

Set the iframe type to display data (e.g., videos, maps, etc.) in an inline frame. You can set the alt attribute to assign an alternative text in case the iframe doesn't display. You can also add custom styles by setting the content-style attribute, which emulates the native style inline styling.

Related Attributes

Image

Set the image type to apply the cell data as the <img src=""> 'src' value. You can set the type-image-alt attribute to assign alternative text if images are disabled by the device. You can also add the content-style attribute to add inline styles, which emulates the native style inline styling.

Related Attributes

Number

Specifying the number type on a column assigns the number editor to the cells. This tells the grid how to validate the cell value when changed via the editor. The number type by default formats the number as a thousand's separated string, but can also format the number as a decimal. This is the default type for any number cell value.

Related Attributes

Password

Enabling the password type hides the text behind asterisks (***).

Percentage

Enabling the percentage type renders the number as a percentage string value.

Related Attributes

Radio

Setting the radio type on a column assigns the radio editor to the cells. Specified radio options will displayed when you edit the cell.

Related Attributes

Range

Specifying the range type on a column assigns the number editor to the cells. This tells the grid how to validate the cell value when changed via the editor. The number is formatted as a thousand's separated string value. Optionally, use the attributes below to set the minimum, maximum, and step when changing the values using the up/down keys.

Related Attributes

Record Duplicate

The record-duplicate type adds record-duplicate buttons to duplicate the row.

Record Key

The record-key type appends a row

Remover

Adding the remover type adds remover buttons to remove the row.

Row Group

The row-group type can be used two ways:

1. Enables row grouping by adding the row group column type. The field indices to group by are determined by the [group] or [index] attributes.
2. References the row group column type created by ZingGrid[groupBy] (an alternative way to enable row grouping).

Row Number

The row-number type renders a field to display the index of the row.

Select

When setting the select type, this creates the <select> element when editing the cell. You can then use the type-select-options attribute to set the dropdown options. Making a selection will set the cell data to that new value. Add the type-select-multiple attribute to display a multi-select <select> dropdown. Per the MDN specification, users must hold ctrl, cmd, or shift to select multiple options.

Related Attributes

Selector

Adding the selector type adds a column of checkboxes to enable selecting rows. With editing enabled, the selection of rows can be removed with one click.

Tel

Setting the tel type assigns the [type="tel"] attribute of the editor's <input>.

Text

The text type is the default type for string values. This assigns a text editor to the cell.

Toggle

Enable toggling on a column by setting the toggle type. Add the type-toggle-options attribute to set the options for true/false.

Related Attributes

Slotted Content

One of ZingGrid's most powerful features allows you to easily create custom columns with slotted content. This is a great way to customize individual columns and consolidate columns as well. Slotted content just means putting markup inside a <zg-column> tag. Inside that column, you have access to the index data through our templating system [[index.key]]. You also have access to all data through [[record.key]].

In the example below, we've applied custom columns to the "Character" and "1st Episode" columns to style and render the information in a cleaner, more readable layout:

<zg-colgroup>
  <zg-column index="img" header=" " type="image" cell-class="profile-avatar" content-width="50px" sort="disabled"></zg-column>
  <zg-column index="name,actor" header="Character" cell-class="character-info">
    <span class="character-info--header"><strong>Name:</strong> [[index.name]]</span>
    <br>
    <span class="character-info--subheader"><strong>Voice By:</strong> [[index.actor]]</span>
  </zg-column>
  <zg-column index="description" width="300"></zg-column>
  <zg-column header="1st Episode" index="episode_link" type="url" type-url-icon="outsidearrow" >
  </zg-column>
</zg-colgroup>

URL

Add a link by setting the url type. Then you can assign the text to click on by setting the attribute, type-url-text.

Related Attributes

Custom type

If none of these column types meet your needs, you can set the custom type and create a column that works for you.

Custom Columns Grid

Here is a complete grid with custom column types: