Welcome!
This community is for professionals and enthusiasts of the Genio platform.
Share your questions and challenges, and help your partners!
Automatic increment ( ID Number )
How to make a field in a table that automatically increments every time a new record is added to the table?
Hi,
In order to achieve that, you should select the following Field properties:
Default (F11 key): Highest +1
Unique: So it creates automatically a DB index on this field, to not allow repetitions
Example:
Remark: List of possible defaults start at position 0, so it will appear the alias of the type Numeric and position (N) 3 when you select the default. For instance, if you select the first option it would be N 0.
If you want this behavior, but inside a series (let's say you want to have several lists running and their numbers can be repeated, if they belong to different groups), you can fill the field property "Prefix non-duplication" with the table column that represents that group.
Hope it helps
Keep Informed
About the Community
Question tools
Stats
Asked: 24/09/19, 11:14 |
Seen: 1473 times |
Last updated: 17/12/19, 10:04 |
Thanks for the answer, it worked.