A
A
Alexander Rublev2019-02-04 18:11:41
Database
Alexander Rublev, 2019-02-04 18:11:41

How do you store/generate document numbering?

Hello.
Tell experienced programmers, how do you work with document numbering?
There is a task for different documents, to generate different numbers, someone just has 1,2,3, .. Someone with some kind of letters or symbols. With each new year, some start from 0, some do not.
How do you store and generate these numbers?
I now store a bunch of them in one table, it turns out a mess, but creating a table with numbers for each
type of document sounds kind of wasteful)
52aYXbZsEbQve2.jpg
Maybe someone has something to share.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Artem Cherepakhin, 2019-02-04
@Meller008

You can use the functions \ function that generates a number for each type of document, including the date, if necessary, then store the version of the document.
For example, the document number for the selected line in the screenshot id = 1156 may look like 338-PP-21-31012019(creation date) -01(version).
In principle, an experienced user can tell what the document is about before opening.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question