Question
Autonumber
Sales_Creatio
8.0
How do we change the Autonumber's last generated number?
Syed Ali Hassan Shah
08:24 Nov 14, 2024

How do we change the Autonumber's last generated number? So, we can continue from there.

Like 1

Like

2 comments
Julio Falcón (NoCode-Services)
12:49 Nov 14, 2024

Hi Syed

 

Not an easy task in current version..., I suggest to review Ryan Farley article on https://customerfx.com/article/resetting-the-value-of-autonumber-fields-in-creatio/

 

Regards 

 

Julio

Syed Ali Hassan Shah
13:13 Nov 14, 2024

Julio Falcón (NoCode-Services),

Thanks a lot, it worked.

Show all comments
Question
Autonumber
Auto-numbering
event
Sales_Creatio
8.0
Auto numbering server side Not Working
Francine Braese
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!

Like 1

Like

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. 

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

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. 

Like 1

Like

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:

  1. Determine the UId of the auto-numbered column.
  2. 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? 

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:

  1. Determine the UId of the auto-numbered column.
  2. 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);

 

 

Show all comments
Subscribe to Autonumber