Hi,
i created schema where are differents records with different dropdown index
Example:
I have record with index Invoice
I have record with index Order
I would like to get automaticaly ID (like numerical series) for eachone by this formula
YEAR - CODE - ID
Example for Invoices
- 2021 170 001
- 2021 170 002
- 2021 170 003
etc…
Example for Orders
- 2021 150 001
- 2021 150 002
- 2021 150 003
etc…
How should I do it?