I would like to be able to add members to a list but have the code fill in automatically. is this possible?
@CarlosRod
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:
Hope that helps!
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
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!
Hi Is there a way to hide the cards under the "Models" section once connected, as I would like the users to see only the links to the apps? Thank you
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…