Adding a Auto Number Field
This guide provides a detailed process for adding an autonumber field to your worksheet. Follow these steps to ensure the auto number field is configured correctly and operates as expected.
Step 1
In this document, I will guide you on how to add an autonumber field. Start by clicking the plus icon.
Step 2
After clicking the plus icon, a pop-up window will appear. In this window, select the "Auto Number" from type field. Then, enter a name for the field according to your preference.
Step 3
Set the 'Prefix' and 'Starting Number' fields, as these are mandatory when adding the auto number field.
Step 4
For now, enter 'TS' as the prefix and '101' as the starting number. You can adjust these values according to your preferences. After providing the details, click 'Save' to complete the process.
Step 5
To verify, click 'Add'. Don’t worry if the auto number field isn’t visible when adding rows, as it is auto-generated. Fill out the other fields as needed.
Step 6
After filling out the fields, click 'Save'. You will see that the auto number field is populated with the prefix and starting number you set when adding the field.
Step 7
You will notice that the auto number field displays the prefix 'TS' followed by the starting number '101' that you set earlier.
Step 8
To add another row, click 'Add' as mentioned earlier. Since this is an auto-generated field, you don’t need to worry about it. After filling out the necessary details, click 'Save'.
Step 9
The row will be added to the existing worksheet, and the auto number field will be filled with the next sequential number, maintaining the same prefix.