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

Different Subsets of Parent Lists in Input & Output Modules
I have 2 lists used in modelling, In Input module I'm using subset of territories from Country List and subset of Regions from Flat list. But in Output module,Its reversed, I'm using subset of regions from Country list and subset of territories from flat list.How to derive the numbers from input to output module. I do have…
Is there a way to turn off the Show Comments Summary panel in UX pages with Comments?
This shows all comments across all data to all users with access to the UX page. This is not appropriate for any UX which might contain security access sensitive data. Comments on grids and cards ARE security dependent. That works fine. But anyone with access to the page can open this Summary Panel and see ALL comments…
Are there any plans to support actions to rename or delete native Versions?
If anyone is aware of idea exchange ideas that are currently being evaluated by the product team, if you don't mind linking them here, would love to give them an upvote. Thanks!