Auto-Incremento

[kako]

Ola,

Estou querendo criar um campo no "Oportunidade" que fosse auto-incremento, tipo: AAA-000001

Alguém sabe onde encontro aolguma informação? Já tentei hoock, mas não consegui.

Alguma ajuda?

Obrigado
kako

[Kharg]

This extension by eymen-elkum does it:

https://www.eblasoft.com.tr/espocrm-extension-page/espocrm-number-pro

[shalmaxb]

This extension is a bit more advanced as it provides the possibility to have as much incrementals as you like, e.g. for product numbering, where every product will have its own incremental. I use that extension to count graphic edition copies and succeded to have a solution, which would not be possible in any other way,

[yuri]

Number field? https://docs.espocrm.com/administration/fields/#number

[kako]

Hi, yuri

Ok, I found it.

In the prefix, I'd like to put XXX-YY (three letters - current year). How can I include the year?

[shalmaxb]

you can have your increment number and use a second field for any prefix or suffix, for example year. Then you create a third field (Varchar) and by formula you concatenate the two former fields. So you can have 0001-2026, 0002-2026 and so on.
You could even put the year changing every year by formula. Only if you would like to start every year again at number 1, you have to reset the incremental number to 1. Maybe there would be a programmatic solution for that as well, but I did not try yet.

[kako]

Hi, shalmaxb
I've tried several methods, formulas, hooks, scripts, and nothing works.
I've already created two fields, one varchar and the other auto-increment, and concatenated them, but the varchar doesn't load the other field (auto-increment).
But this new number field (auto-increment) works; I just want to put the current year in the prefix.

[shalmaxb]

aqui o meu procedimento

//pega o ano
invoiceYear = datetime\year(rechnungsdatum);

//concatenate numero incremento com o ano
invoiceNumber=string\concatenate(rechnungsnummer,'-', invoiceYear);

invoceNumber1 = o campo de incremento, que ja vem com o prefixo 

Resultado:
campo varchar concatenado = prefixo-numero incremento-invoiceYear
RE-0001-2026

(rechnungsdatum = dataDaFatura, rechnungsnummer = numéro da fatura)
o rechnungsdatum e um campo dateTime, de onde eu pego o ano.

[kako]

oi, shalmaxb
Obrigado
Onde está implementando (Fórmula? Workflow? Hook?)

[shalmaxb]

apenas formula