Sequential code creation with department(code+1 ?)

ekta09

I have a requirement where I need to create sequential codes with department (based on user selection) in a list .The user will click "Add item" from the dashboard and codes will be created and added in the list in a sequential manner .

Example :

1st time :

New code : 6759_00000

2nd time : 6759_00001

Similarly starts from 00000 for a different department

I am able to get the 1st item in my list but the iteration does not happen.

How can I go about with this?

ekta09

Was able to find an answer :) Providing solution incase someone might need it in the future

Worked with it using 3 modules 1 for inputting department from user

2 department list and a new list with only one member. (used for creating line items code and cumulate)

cumulate picks value from 3 cumulate +1

3 tracker module to store last imported code and increment cumulate)

2 imports

1 for importing module 2 code in the list

2 for importing module 2 in the tracker