RowId

The RowId() function returns the ID of the current row of a list.

Any database list also has a numeric [ID] field which holds the numeric primary key value for each row and gets automatically incremented on each add new row action. When you use that ID field in your expressions, you will see it in the form [12345: ID], which does not make it immediately clear which field (or rather, which list) you are pointing to. Other fields use the Technical Name in expressions, which helps to understand where they are coming from. When using the RowId(list) function in expressions, you will see immediately to which list you are referring, so this makes it far more usable.

A RowId of a List-item has multiple forms:

  • directly displaying in a label, will use the ToString() version, and yields the combined identifying information for the List and the Row;

  • with the ToNumber() function, it will yield the numeric id value - same as the numeric [ID] field;

This function is SQL compatible. For more information about SQL compatibility, see our documentation.

The Row ID value of one of the following:

  • The current row of a list (when using the List as parameter)

  • The referenced row of a reference field (when using a reference field as parameter)

Syntax

RowId(list)

RowId( [Users] ) => n196761_2000000001 {for a new row not yet saved}

RowId( [Products] ) => i1428100_2614 as string, when item with id 2614 is the current row => 2614 as numeric

RowId(reference)

RowId( [CurrentProduct-Reference] ) => i1428100_2614 as string, when item with id 2614 is the referenced item => 2614 as numeric

RowId( [ClearedProduct-Reference] ) => unknown - reference is empty, not pointing to a specific row

Parameters

NameTypeRequiredDescription

list

List

☑️

a list from the data-model

reference

reference field

☑️

a reference field

Last updated