Get Row Number

Retrieves the row number of the specified row in the table.

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.

Note: Table rows are numbered starting with the number 1.

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 [phone]	123 east street	San Francisco
joe	+ 1 [phone]	321 west street	San Jose
jack	+ 1 [phone]	213 north street	San Francisco

Here the row refers to the first row:

Name	Number	Address	City
john	+ 1 [phone]	123 east street	San Francisco

Automation

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

Results