number filled line

Hey guys.

I have the form below.

every time i add some information in column line1.

I want my item column to generate a number in sequence.

Always starting with 1 .

Any tips on how to do it?

 

jjs814_0-1677635760709.png

 

0 2 88
2 REPLIES 2

Conceptually, count the relevant rows that precede or include the current row. Here's a draft  (and untested) expression for that approach. If the rows are sorted by some column, substitute that for [_RowNumber]. Depending on when you need the index number assigned and whether it might ever change, the expression might belong in the column's Initial value or App formula property. If the former, the expression might benefit from a modified approach; if the latter, the column might be either in the data source or virtual.

COUNT(SELECT(pag2[id_pag1], AND([id_pag1] = [_THISROW].[id_pag1], [_RowNumber] <= [_THISROW].[_RowNumber])))

 There are likely more elegant methods. Beware the potential drag on app performance.

Steve
Platinum 4
Platinum 4
Top Labels in this Space