I do have a question (as every day :P), i want to create a field that is autoincremental, for example the field will be name as n_ invoice_1, and the format would be something like that, INV-01, INV-02, etc…
I searched on internet and i found some interesting post, they said that in studio it is not possible to do that, that you have to do it by yourself (php),
i found a code made by maranemil, but i dont understand it completely.
My field is named n_invoice_1, and the prefix is INV, what do i need to change from that code, to implement it on my suitecrm?
Here is the code.
I had issues with that module after reaching the 99999 it just stopped counting because I set the format to be 00001, and there’s no way to correct that (plus, I don’t like the zeros), I’m just using a simple database auto increment field now
Please can you guide me on how to create the auto-increment field with the database so i can add that in my suitecrm. Please guide me through also how to use it on the studio at the particular modules I wanted to.
Thanks a lot for your answer. But after creating this autoincrement on the phpmyadmin, I wanted to know how I can use it on the studio. or the module that I wanted to use on. what should i do on the Suite Crm ?
The only bug I found with this method is that rebuild/repair seems to infinitely say there’s an consistency issue between the database and vardefs which seems to relate to the way the repair module checks if the field is a unique key.