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

How to use Client ID and Client Secret for API request directly?
Hi all, The Client ID and Client Secret are available, intended for uploading and downloading files. Could anyone advise how to use these credentials DIRECTLY to make API requests? Thank you!
New UX Filtering for Hierarchy sibling
I have A6 as the parent list and two sibling lists: A6.5 and A7. The A7 list includes an attribute that maps to A6.5. In the UX, the user will select A6.5 using a content selector, and the grid (dimensioned by A7) should display only the A7 items associated with that selected A6.5. Since the selector is a page context and…
A reminder of Bulk Copy - Current year to Prior year version for YoY analysis
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…