So I am wondering if I can create an automated incremental numbering for my database entries, because I am trying to register each activity I have done with my coworkers every month.
So I am trying to have a system where each data entry made by me or my coworkers to have an automated numbering in my table database every time a new page is created into my database without having the risk of my coworkers to accidentally double input the numbering order.
For Example:
001/10/24
002/10/24
003/10/24
I am looking to have such numbering to be automatically created in my table database without having my coworkers input these numbers manually. Having to input these numbers manually by multiple users are causing multiple double entries and even typo in the numbering/months/year and I would like to avoid that if possible.
Is there any way to do this? I have tried using formulas and I have been able to automatically produce the specific month and year for each new data entry, but I haven't been able to find a way to make the automatic incremental numbering happen. Can anyone help me?
