Autonumber | Community Creatio

Question

20:44 Sep 23, 2024

Hello,

I'm trying to add an auto-numbering field in the Leads section following the instructions here: https://academy.creatio.com/documents/technic-sdk/7-13/how-add-auto-numbering-edit-page-field

I've made the 2 new system settings required:

I've also made a replacing Lead object in the package I'm working on and added a new event trigger before the record is added:

The process triggered by this signal on the object is set up with the expected elements:

With conditional logic:

One thing I think is missing is how to tie the new system settings into this process. Is there a schema or input I need to update for this?

Also, do the process element parameters need to be populated on the user task?

Thank you for your help finding what needs to be fixed to get this working!

2 comments

Best reply

Ryan Farley

20:59 Sep 23, 2024

Is your column on the Lead object really called "CreatioNumber"? (the code for the column)

You've verified that your User Task is really named "LeadNumberCreation"? (click the three-dot button on the top right and switch to advanced mode)

As for the system settings, the user task locates and uses those.

As a side note, the new method is much easier (it works for classic as well as Freedom since it's simply added as a default value for the column). See https://customerfx.com/article/working-with-autonumber-fields-in-creatio/

Ryan

Ryan Farley

20:59 Sep 23, 2024

Is your column on the Lead object really called "CreatioNumber"? (the code for the column)

You've verified that your User Task is really named "LeadNumberCreation"? (click the three-dot button on the top right and switch to advanced mode)

As for the system settings, the user task locates and uses those.

Ryan

Francine Braese

23:18 Sep 23, 2024

I obfuscated the real code numbers for these screenshots but the ones I'm using do match the field column code and the user task code so that shouldn't be the problem.

That's great to know there is a more simple way to create an autonumber field right on the object now though! I tried it and it worked so that solution will work fine.

Thank you so much for your help!

Show all comments

Question

Autonumber

Sales_Creatio

8.0

Can I set the Autonumber field to start at a different value?

Andriana Pachella

16:25 Jun 02, 2023

We're looking to use the new Autonumber field feature on Leads to replace an existing custom field that we created to do a similar thing before this feature was available. We want the autonumber to start not at 0000001, but at where the other number left off (which now is 1026579). Hoping there's a setting somewhere I can make this change to utilize this feature.

3 comments

Best reply

Bogdan

13:17 Jul 04, 2023

Lena Smetnenko,

While there is no yet interface that would allow the user to configure this manually, the following steps need to be performed.

Instructions:

Determine the UId of the auto-numbered column.
Using the script, set a new number for the column. In the examples, "4a40180c-61bf-de86-2f08-b05852a5ea6d" is the UId of the auto-numbered column, and "1" is the next value from which the auto-numbering will start.

MSSQL script:

ALTER SEQUENCE [4a40180c-61bf-de86-2f08-b05852a5ea6d] RESTART WITH 1;

PostgreSQL script: SELECT setval('4a40180c-61bf-de86-2f08-b05852a5ea6d', 1, false);

Kyrylo Iudin

15:36 Jun 05, 2023

Hello Andriana!

In order to reach the goal, you need to find a system setting with the code "CaseLastNumber" and set its default value to the prefered one from which the autonumber shall start.

Lena Smetanenko

11:45 Jul 04, 2023

Kyrylo Iudin,

Hi Kyrylo, what about when we have created a new section in Freedom UI designer and used autonumbering feature there? What system setting is used for that?