# Get Row Number

### Overview

This procedure retrieves the row number of a specific row in a table. It's useful when you need to locate the position of a row for further operations like updating, deleting, or referencing data.

{% hint style="info" %}
Note: Table rows are numbered starting with the number 1.
{% endhint %}

### Input Concepts

| Concept | Type        | Description                                  | Default    | Required |
| ------- | ----------- | -------------------------------------------- | ---------- | -------- |
| `row`   | table's row | The row whose row number is to be retrieved. | No default | Yes      |

### Output Concepts

| Concept      | Description            |
| ------------ | ---------------------- |
| `row number` | The number of the row. |

### Examples

#### 1. Get the Row Number in a Sample Table

In this example, `the table` refers to the following table, which can be generated using the `create a sample table` procedure:

| Name | Number             | Address          | City          |
| ---- | ------------------ | ---------------- | ------------- |
| john | + 1 (415) 691 9426 | 123 east street  | San Francisco |
| joe  | + 1 (415) 691 1234 | 321 west street  | San Jose      |
| jack | + 1 (415) 691 4595 | 213 north street | San Francisco |

Here `the row` refers to the first row:

| Name | Number             | Address         | City          |
| ---- | ------------------ | --------------- | ------------- |
| john | + 1 (415) 691 9426 | 123 east street | San Francisco |

{% tabs %}
{% tab title="Automation" %}

```
create a sample table
get the table's row where
    the row selection formula is "Name == john"
get the row's row number
```

{% endtab %}

{% tab title="Results" %}
0
{% endtab %}
{% endtabs %}