How To: Number Table Rows

Add row numbers to related list tables and control the starting index.

Use the rownum keyword when tables need a visible line counter.

Problem

You want to add row numbers to your related list tables.

Solution 1: Basic Row Numbers

<!--{{!
<lineitems>
<listname>opportunitylineitems</listname>
<column header="#">rownum</column>
<column>PricebookEntry.Product2.name</column>
<column prefix="$" format-number="#,###.##">unitprice</column>
</lineitems>
}}-->

Result:

| # | Product | Price  |
|---|---------|--------|
| 1 | Widget  | $10.00 |
| 2 | Gadget  | $25.00 |

Solution 2: Custom Starting Number

Start at 10:

<column startIndex="9" header="#">rownum</column>

Result: Numbering starts at 10.

Solution 3: Formatted Row Numbers

Add Prefix and Postfix:

<column prefix="Item " postfix=":" header="Line">rownum</column>

Result:

| Line    | Product | Price  |
|---------|---------|--------|
| Item 1: | Widget  | $10.00 |
| Item 2: | Gadget  | $25.00 |

Tips

• rownum is a special keyword, not a field name.
• Numbering starts at 1 by default.
• startIndex="3" starts numbering at 4.
• Combine it with prefix and postfix for custom labels.