fill code automatically

I would like to be able to add members to a list but have the code fill in automatically. is this possible?

Accepted answers

All comments

Great question. The answer is yes, but it's not super intuitive. Here's how I achieved the same feature, you might try this or modify it to suit your need:

The code has to be unique, so we need a way to reliably create a new code.
Create a system module for the list that you will be adding and add a line item that parses the existing codes for their numeric value. So, for instance if the code is "CODE001" we want to extract the "001" and convert it to a number, in this case a one (1).
Create a dimensionless module that grabs the MAX of that number.
When your user creates a new list item, use an action, not a form. So in this case add a line item to your dimensionless module that allows the user to create as many new items as they want. This would be an editable, numerical value. I'll call this "n". You may have to add the USER dimension on this one if you have a lot of interest in creating new items.
Create a list that has as the maximum number of list items a user might want to create.
Add a line item in that list that has a list value starting with one (1), then two (2), etc.
Add a line item that populates the the first "n" list items with the new codes starting with the MAX value you obtained earlier. Add the list value you created above. Concatenate any text you wish to that number to generate your code. Just make sure the numerical value of the code is easily parsed out.
Create a saved view that filters out all the blank list items. So if the user creates 5 new list items, then your saved view should only show five list items.
Use the saved view to create the new list items in your target list.

Hope that helps!

alexpavel

@CarlosRod

Not sure what is in detail in your entire use case.

However, the CODE property of an element from a list cannot be automatically filled-in. The CODE can be updated only via an import action or manually into the list.

The only Anaplan object that has auto-incremental functionalities is the "numbered list" type.

When you have a combination of unique properties, Anaplan can automatically create a new item in the numbered list with its internal ID (that is not the element's Code).

The numbered list internal id can be referenced with the function NAME(Item(#numbered list)) that returns a numeric sequence like #1, #2, #3...etc... that potentially can be used to update the CODE property.

If you need to generate a CODE and you need to update the CODE via an import action, having the NAME, then you can use the @JaredDolich suggestion or you can also rely on Numbered List internal ID's...what suits you 🙂

Hope it helps

Alex

Achal

Hi Carlos,

Yes, it is possible in the Number list

you need to create 2 line-items 1 is Boolean formatted and 2nd one is number or text formatted

- In Boolean formatted, you need to check how many members you have written

Ex:- ISNOTBLANK(Line-Item name)

- In the number formatted Line item, you need to use the RANK function, (RANK function basically evaluates a set of values and assigns sequential rankings)

Ex:- IF Boolean THEN RANK(1, ASCENDING, SEQUENTIAL) ELSE 0

(I want to create in Text formatted that's why I use TEXT())

Now,

you need to do mapping in your number list with your module, to create an import button in Dashboard

Hope it will help!

Thanks,

Achal Jain

Quick Links

Can you help?

Unanswered questions

Add list members to a selective access list
Hi, I am working on a solution where the User should only have access to write/edit the list members that they add from an Action on the frontend. This action adds another list member to a selective access list. The problem is, in order to run the action, you need access to the entire list, so you would see all list…
Dimensionality Issue
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
Formula to return Connection details...
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?