Auto-incrementation problem

Hi community !

 

I wanted to implement an auto-incrementing "Code" field for the "Opportunity" section. I managed to do so following the documentation (https://academy.creatio.com/documents/technic-sdk/7-16/how-add-auto-num…). I just have a problem that I can't solve right now, everything works but when the Client create a new opportunity and then cancels it (clicks on the button "Cancel" and tries to add a new opportunity again, the auto-incrementation is done but I don't want so. I want that the Code increments only if the opportunity related to the previous code already exists in the "Opportunity" section.

 

Here is my actual code :

 

 

Hope my explaniations are clear enough !

 

Thanks for your help :)

Like 0

Like

6 comments
Best reply

Hello Jonathan,

 

About the questions related to the  "Numerator for Creatio" add-on it's better to contact the responsible support team (their support team's mailbox: support@samarasoft.com).

 

And coming back to the previous quesion on how to move the auto-numbering logic the object level: for that you can try to create an event in the needed object which will be saved according to your configurations, for example, it's event of saving the record. For that you need to go to Advanced settings and find the needed object, then open it and go to the "Events" item and add the needed event there:

 

In your task it should be "After Record Saved" (OpportunitySaved). Than you need to save changes (click "Save" button) and in the same object click the "Open Process" item (on the top bar). After the process designer will be opened you will be able to create a process which will be triggered by the newly created event (in our example, when the Opportunity record will be saved). For that you need to add the "Event sub-process" element and set Message as OpportunitySaved (your event).

 

 

Once it's done you can add the script task/code which is responsible for  auto-incrementing logic:

 

 

So after that, the object process  will be triggered every time after the Opportunity record was saved and your custom code will assign the needed number to that record. 

 

More useful infromation can be found in our Academy in the links below:

Kind regards,

Roman

Hello Jonathan,

 

Hope you're doing well.

 

For the task, you have described the auto-numbering logic should be moved to the object level, so the user will receive the appropriate number after saving that record. First of all, you can try to replace the method in JS responsible for auto-numbering entries on the page. Also as an option, there can be created the SQL trigger for new records.

 

Additionally, for your business task, you can try to use the "Numerator for Creatio" add-on. Using this addon the system will form the number automatically according to your own preferences and settings.

 

Best regards,

Roman

Roman Rak,

 

Thanks a lot for your answer.

How could I change the auto-numbering logic to be moved to the object level so that the user will receive the appropriate number only after saving that record and not when creating a new record ? 

 

I'm new to the dev side in Creatio, sorry for that. In a normal code situation, I could just compare if the UsrCode already exists in my opportunites and if it already exists I don't increment the UsrCode. But how to do that with objects in Creatio ? An example could be really useful. 

 

Why would I need to replace the method in JS for auto-numbering entries on the page ? Why could it be useful in my case ?

 

I basically only need to add the Code number and increment it only if the user saves the record, otherwise I don't want to increment it. Isn't there a method like "this.isAddMode" for the "Cancel" button ? (like if(this.cancel) { do something } or, with the same logic, this.save ?

 

If you have a coding solution with some examples to help me out I would be grateful :)

 

Thanks !

Jonathan,

 

Thank you for your reply.

 

Please check the following Community posts it might cover your questions:

Also, please try to use this  "Numerator for Creatio" add-on, and in case it doesn't fit your business task requirements, don't hesitate to contact us.

 

Best regards,
Roman

Roman Rak,

 

I'm trying to use the "Numerator for Creatio" add-on and it is really great ! However I encounter the same problem as before, when a user cancels the opportunity it continues to increment the number.

 

Furthermore, if you look at this screenshot :

I want that my text field "SOT-" to be static, but my "Sequence number" field to be dynamic and it must auto-increment every time a user saves the opportunity. Furthermore, why does the sequence number start at "00012" and not "00000" ? Any suggestion ?

 

Thanks really a lot for the help you are providing ! :)

Hello Jonathan,

 

About the questions related to the  "Numerator for Creatio" add-on it's better to contact the responsible support team (their support team's mailbox: support@samarasoft.com).

 

And coming back to the previous quesion on how to move the auto-numbering logic the object level: for that you can try to create an event in the needed object which will be saved according to your configurations, for example, it's event of saving the record. For that you need to go to Advanced settings and find the needed object, then open it and go to the "Events" item and add the needed event there:

 

In your task it should be "After Record Saved" (OpportunitySaved). Than you need to save changes (click "Save" button) and in the same object click the "Open Process" item (on the top bar). After the process designer will be opened you will be able to create a process which will be triggered by the newly created event (in our example, when the Opportunity record will be saved). For that you need to add the "Event sub-process" element and set Message as OpportunitySaved (your event).

 

 

Once it's done you can add the script task/code which is responsible for  auto-incrementing logic:

 

 

So after that, the object process  will be triggered every time after the Opportunity record was saved and your custom code will assign the needed number to that record. 

 

More useful infromation can be found in our Academy in the links below:

Kind regards,

Roman

Roman Rak,

 

You reply is just awesome. Really. It will help me with more than a problem for the implementation of future things ! It's really smart to do a sub-process with a script so that the script is triggered only when a certain action is done.

 

Last question, in the script code task, how could I implement the same logic ? I can't get the value of the "UsrCode" field for instance or I can't use the this.getIncrementCode method because i'm not overriding the Terrasoft.BasePageV2 getIncrementCode method. I can't add a field to read the data too to get my UsrCode. How can I get all these values to implement my auto-incrementation logic ?

 

Thanks a lot for your advices !

Show all comments