Automatic counter for a row number

[Marco1212]

Good morning all !

I find myself with a problem: I would like to put an automatic number for each measurement in the “Selection ID” column.

For example, I would like for the next measurement the number “3” to appear in the “Selection ID” column.

Could you help me on this?

Thank you in advance.

[Aurelien]

Hi @Marco1212

You may want to use this expression:

help.appsheet.com

COUNT()

Number of list items

In your case : COUNT([Numéro de mesure]) (or any other column, actually)

Be aware that row number is not a stable key-column, you may want to change it

EDIT : this formula is to write in the Initial Value expression

[Marco1212]

Hi @Aurelien !

Thank you a lot for your answer and your great help !

[Steve]

Serial Numbers, If You Must Tips & Tricks 💡

Danger Ahead! In general, sequential numeric identifiers (i.e., serial numbers) are risky in AppSheet: if two users happen to add rows at the same time, both rows could be assigned the same serial number, which could lead to confusion (at the least) or data loss (at the worst). For this reason, serial numbers are strongly discouraged! Basic Serial Numbers One way to implement serial numbers is with a normal (not virtual) column named (e.g.) Serial of type Number and an Initial value expression …