Create Sequential Code for New Activity

AmeliaKn

Hi Team,

I am trying to create automated code for the new activity I added to a numbered list
The format should be like this:

Department code - Activity Sequential Code (the structure attached for example)

 

I've tried to make a system module, but the activity code still has duplicates. Is there a way to make automated code?

Please advise,
Thanks.

Screenshot_2022-10-10_212549_149000.png

Screenshot_2022-10-10_212902_149000.png

KirillKuznetsov

@AmeliaKn 

Good job, you are very close to the solution!

It depends on what user experience you are trying to achive.

If you want user to create items one by one then you have to publish an import which will generate an item by calculated code based on selected parent (department). When parent is selected - system have to find the max code value of the elements which were already created underthis parent element and add 1 to it.

For example. In tech department (200) you now have 3 elements. 200-001 200-002 and 200-003. Remove the parent's part and change format to number and you get 1 2 and 3 accordingly. The biggest code value is 3 (003) . Add 1 to 3 = 4. Convert back to calculated code. And this is your next code 200-004.

 

Here you will have to use Max summary method. The tricky part with it is that when there are no items under a parent - the output of it will be -Infinity. In this cases you have to override the -Infinity value using IF statement to get code "001". Simply IF TEXT(<max value line item>) = "-Infinity" THEN 1 ELSE <max value line item>+1