Sequential code creation with department(code+1 ?)

ekta09
ekta09
edited February 9 in Modeling

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?

Answers

  • ekta09
    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

  • devrathahuja
    devrathahuja

    Hi @ekta09 ,
    You could also get rid of the 3rd import & replace it with using the LNB summary instead. So if the list has item with codes 6759_00000 to 6759_00009 then the line item with LNB summary would give you the same value that you're trying to track with the import :)

Categories