Highlighted
Regular Contributor

Auto Number

Hi,

I have a list of numbers, they are used for unique product codes. 

As you can see the last number we used was 201028.

bvfskuid.png

 

When a user enters a product in another module, it looks up the BVFSKUID from this list using the BVFSKU column, If there is no matching record, we need to create a new line in this list, with the BVFSKU Description they have, and a new BVFSKUID using the next number (201029) automatically.

 

How do i find the next (maximum) number in this list, so i can increase by 1 and use????

 

thanks

13 REPLIES 13
Highlighted
Master Anaplanner/Community Boss

Re: Auto Number

1 Create a module (if not already) by the list

2. Add two line items

- Code = CODE(ITEM(listname))

- Code Value = VALUE(Code)

3. Set the summary option for Code Value to MAX

4. you can then refer to this in your creation module

 

I hope that helps

David

Highlighted
Regular Contributor

Re: Auto Number

Hi David,

Hi, I had tried that but i now have a module with a number...

clipboard_image_0.png

I still don't know how i can reference it?

 

What am i missing, something simple no doubt

Highlighted
Master Anaplanner/Community Boss

Re: Auto Number

Look at the bottom (Top level item) and if the summary method is set to Max, you will see the last/maximum number created

David

Regular Contributor

Re: Auto Number

How do i look at the bottom (top level item)?

Highlighted
Master Anaplanner/Community Boss

Re: Auto Number

Scroll down?!

 

If you can't see it, have you got a filter or "select levels" turned on

 

As it's a top level, you can point another line item that is not dimensioned by the list and it will return the value.

 

You may want to hold this in a separate module; but it will depend on the logic for you building the numbered list

 

David

Highlighted
Regular Contributor

Re: Auto Number

That is the bottom. 

I have no filters on.

No levels selected, it is pure brand new module.

The summary is set to MAX

clipboard_image_0.png

Highlighted
Master Anaplanner/Community Boss

Re: Auto Number

In the configure tab for the list, set a top level item, then you will have the MAX at the bottom

David

Highlighted
Regular Contributor

Re: Auto Number

Aha, i have a maximum now..

Sorry, i am quite poorly and brain is on 25%....

How do i now refer to that in my creation module?

 

thanks for this, its so simple but so is breathing usually    🙂

 

Much thanks again, it really is appreciated

Highlighted
Master Anaplanner/Community Boss

Re: Auto Number

HI @DeveloperCYT,

Try this, You don't need to set up any top level items.

Create a module with this list as dimension and create line items and put the formula as per SS.

Auto Number.PNG

 Now you can refer the 'Max' line item to proceed further.

Sample:

Auto Number 1.PNG

 As 4 is my latest entry, I have to capture '4' in a non-dimensional line item.

 

Auto Number 2.PNG

 I hope your problem is resolved. Let me know if you have any concerns.

Regards,
Kavin.

 

Regards,
Kavin.