ExpressionEngine Docs

# Grid Fieldtype

- Field Options
- Template Tags
- Parameters
- Variables
- Modifiers
- Examples

The Grid field in ExpressionEngine provides a way to group fieldtypes in repeatable rows. This is useful for when you need to group a subset of data in your channel entry form that may or may not have a varying number of rows. You can select a minimum and a maximum amount of rows to allow data entry for, or it can be virtually infinite.

## Field Options

### Minimum Rows

Specifies the minimum number of rows this Grid will have. For example, if you enter `3`, the publish form will load with three rows ready to be populated and will not allow the publisher to have less than three rows in this Grid field.

### Maximum Rows

Specifies the maximum number of rows this Grid can have. For example, if you enter `10`, the publish form will not allow the publisher to add any more than ten rows to this Grid field.

### Grid Fields

Here, you specify the columns you want in your Grid field. All native fieldtypes are available to add and have many of the same configuration options as full fields do.

## Template Tags

Contents of a Grid field are accessed via a variable pair surrounding prefixed variables representing each column. For example, if you have a field `gallery` with an `image` and `credit` fields, your template code may look like this:

    {gallery}
        <figure>
            <img src="{gallery:image}">
            <figcaption>Photo by {gallery:credit}</figcaption>
        </figure>
        {gallery:description}
    {/gallery}

Grid has a number of parameters and other variables available in order to get the information you need out of it.

## Parameters

- `backspace=`
- `dynamic_parameters=`
- `fixed_order=`
- `limit=`
- `offset=`
- `orderby=`
- `row_id=`
- `search:column_name=`
- `sort=`

### `backspace=`

    backspace="7"

Just like the backspace parameter on the Channel Entries module, backspacing removes characters (including spaces and line breaks) from the last iteration of the loop.

### `dynamic_parameters=`

    dynamic_parameters="orderby|limit|sort"

The Dynamic Parameters feature permits a Grid field tag’s parameters to be set “on the fly” using POST data data submitted via a form. A practical use for this is to create some display options in a form on your page that your visitors can use to select their preferred page view.

Note: This feature will only work if page caching is turned OFF for the template in which it is being used.

Every parameter available to the Grid field tag can be set dynamically.

### `fixed_order=`

    fixed_order="10|21|15"

Allows the output of the tag pair to order rows in a fixed order of row IDs.

### `limit=`

    limit="5"

Limits the number of rows output by the tag pair to the number specified here.

### `offset=`

    offset="1"

Offsets the number of rows output by the tag pair to the number specified here.

### `orderby=`

    orderby="column_name"

Allows the output of the tag pair to be ordered by a specific column, defaults to row order as set on the channel entry publish form. Entering `random` will return the rows in a random order.

### `row_id=`

    row_id="5"

Tells the tag pair to only output rows for the database IDs of the rows specified. Multiple rows may be specified by separating them with a pipe character:

    row_id="11|5|55"

Or use “not” to exclude rows:

    row_id="not 8|15|87"

### `search:column_name=`

    search:height="<=20"

Tells the tag pair to return rows only matching a certain search criteria. The behavior and syntax is identical to the search parameter of the Channel Entries module.

### `sort=`

    sort="desc"

Specifies the direction of the sorting of the tag output. Defaults to ascending.

## Variables

- `count`
- `field_row_count`
- `field_row_index`
- `field_total_rows`
- `index`
- `prev_row`
- `next_row`
- `row_id`
- `switch=`
- `total_rows`

### `count`

    {gallery:count}

The “count” out of the current rows being displayed. If five rows are being displayed, then for the fourth entry the `count` variable would have a value of “4”.

### `field_row_count`

    {gallery:field_row_count}

The count of the row inside the field regardless of tag output.

### `field_row_index`

    {gallery:field_row_index}

The index of the row inside the field regardless of tag output.

### `field_total_rows`

    {gallery:field_total_rows}

The total number of rows in the field regardless of tag output criteria.

### `index`

    {gallery:index}

The count of the rows but starting at zero.

### `prev_row`

    {gallery:prev_row}
        <a href="/gallery/lumenhaus/{gallery:row_id}">Previous photo</a>
    {/gallery:prev_row}

Used as a tag pair within the parent Grid field tag pair, provides access to data in the previous row in the dataset.

### `next_row`

    {gallery:next_row}
        <a href="/gallery/lumenhaus/{gallery:row_id}">Next photo</a>
    {/gallery:next_row}

Used as a tag pair within the parent Grid field tag pair, provides access to data in the next row in the dataset.

### `row_id`

    {gallery:row_id}

The database ID of the current row.

### `switch=`

    {gallery:switch="odd|even"}

Identical to the switch variable available in the Channel Entries tag pair, but prefixed for your Grid field.

### `total_rows`

    {gallery:total_rows}

The total number of rows being returned by the current display criteria.

## Modifiers

All modifiers have access to the tag parameters available to the primary tag which are listed above.

### `:average`

    {grid_field:average column="height" search:height=">55"}

Given a column name containing numeric data, returns the average of the column values in that field, or in the dataset paired down by additional criteria such as search.

### `:highest`

    {grid_field:highest column="height"}

Given a column name containing numeric data, returns the hightest of the column values in that field, or in the dataset paired down by additional criteria such as search.

### `:lowest`

    {grid_field:lowest column="height"}

Given a column name containing numeric data, returns the lowest of the column values in that field, or in the dataset paired down by additional criteria such as search.

### `:sum`

    {grid_field:sum column="height"}

Given a column name containing numeric data, returns the sum of the column values in that field, or in the dataset paired down by additional criteria such as search.

### `:table`

    {grid_field:table cellspacing="0" cellpadding="0"}

Outputs the data in the Grid field as a table. All parameters available to the primary tag are available in addition to these:

- border= Sets border attribute on the table’s HTML element
- cellspacing= Sets cellspacing attribute on the table’s HTML element
- cellpadding= Sets cellpadding attribute on the table’s HTML element
- class= Sets class attribute on the table’s HTML element
- id= Sets ID attribute on the table’s HTML element
- set_classes= If set to ‘y’, adds column name to the class attribute of each cell.
- set_widths= If set to ‘y’, sets the same column widths configured for each column in the Grid field’s settings.
- width= Sets width attribute on the table’s HTML element

### `:total_rows`

    {grid_field:total_rows search:height=">55"}

When outside of a Grid field tag pair, this modifier can be used to get the total number of rows in a field given a specific criteria.

### `:next_row`

    {grid_field:next_row row_id="{segment_3}"}
        Next up: <a href="/gallery/photo/{grid_field:row_id}">{grid_field:title}</a>
    {/grid_field:next_row}

Given a row ID, this tag pair will provide access to the next row in the field criteria. The `row_id` may be populated via a segment variable.

### `:prev_row`

    {grid_field:prev_row row_id="5"}
        Previous: <a href="/gallery/photo/{grid_field:row_id}">{grid_field:title}</a>
    {/grid_field:prev_row}

Given a row ID, this tag pair will provide access to the previous row in the field criteria. The `row_id` may be populated via a segment variable.

## Examples

### Checkbox and Multi Select Fields

For checkbox and multiselect single variables:

    {grid_field}
      {grid_field:my_checkbox}
    {/grid_field}

This would output a comma-separated list of the checkbox labels.

For checkbox and multiselect variable pairs:

    {grid_field}
      {grid_field:my_checkbox}
         Value: {item}<br>
         Value: {item:value}<br>
         Label: {item:label}<br>
      {/grid_field:my_checkbox}
    {/grid_field}

### Date Fields

    {grid_field}
      {grid_field:my_date format="%F %d %Y"}
    {/grid_field}

### Email Address Fields

    {grid_field}
      {if grid_field:my_email}
        {grid_field:my_email:mailto title="Email about their dog" subject="Question about your dog" encode="no"}
      {/if}
    {/grid_field}

### File Fields

A file field variable pair:

    {grid_field}
      {grid_field:my_image}
          Extension: {extension}
          Upload date: {upload_date format="%Y %m %d"}
          URL: {url}
          Custom med thumbnail url: {url:med}
      {/grid_field:my_image}
    {/grid_field}

Single variable file field:

    {grid_field}
      URL: {grid_field:my_image}
    {/grid_field}

### Relationship Fields

    {grid_field}
      {grid_field:my_relationship status="open"}
          {if grid_field:my_relationship:count == 1}<h3>Relationships ({grid_field:my_relationship:total_results})</h3>{/if}

          Related entry title: {grid_field:my_relationship:title}
          Related entry's file field, med custom image size: {grid_field:my_relationship:my_file:med wrap="image"}

      {/grid_field:my_relationship}
    {/grid_field}

### Toggle Fields

    {grid_field}
      {if grid_field:my_toggle}YES there is a toggle value!{/if}
    {/grid_field}

### URL Fields

    {grid_field}
      <a href="{grid_field:my_url}">Your Link</a>
    {/grid_field}