---
updatedAt: 2026-10-15T13:49:28.000Z
agentTools:
  projectIndex: https://docs.pebblestream.com/llms.txt
---

# bottom-row

Marks a column that receives a **constant**: the index of the last (bottom) row of the record's _block_ inside the template worksheet.

`pebblestream:bottom-row`

<br />

Together with [`top-row`](top-row.md), [`leftmost-column`](leftmost-column.md) and
[`rightmost-column`](rightmost-column.md) it describes the bounding rectangle of
the table the record was extracted from.

## Syntax

```
pebblestream:bottom-row
```

* No arguments.
* Placed on the **header cell of the column** that should hold the constant.
* Requires [`template-name`](template-name.md) on the same worksheet.

## Example

| column | header         | comment                                 |
| ------ | -------------- | --------------------------------------- |
| A      | `Block top`    | `pebblestream:top-row`                  |
| B      | `Block bottom` | `pebblestream:bottom-row`               |
| C      | `Item`         | `pebblestream:template-name:"Partners"` |

Every record extracted from a block ending at row `25` of the template gets `25`
in the `Block bottom` column.

## Errors

| Error                                 | Cause                             |
| ------------------------------------- | --------------------------------- |
| `dir-too-many-args`                   | Arguments were supplied.          |
| `missing-the-template-name-directive` | The sheet has no `template-name`. |

## Related

* [Template directives](template-directives.md) — how extraction works
* [top-row](top-row.md) — the other vertical bound
* [block-row-count](block-row-count.md) — height of the block