Insert Row Numbers Into Tables
This article introduces how to automatically insert row numbers into tables when the record is saved.
An event is triggered when the user navigates to the Record create page, navigates to the Record edit page, or makes changes to the Table field. This disables the Number field. An event is also triggered when the record is saved. The number of rows in the Table field is calculated, and the Number field is automatically filled in with row numbers.
Prepare the App
Create an App with the following fields and settings.
|Field Type||Field Name||Field Code||Notes|
|Table||User List||usertable||See the table below for the fields to place inside.|
Set the following fields and settings for the User List table.
|Field Type||Field Name||Field Code|
After saving the settings and clicking on Update App, create a new record. Add new rows into the table, and fill it with data. After saving the record, the Number field of the table should automatically be numbered, starting with the number 1.