Conditional Parameter

Hello,

I hope everyone is doing well.

I have a query regarding Anaplan. I have several system modules where I have created unique IDs, each with a different length.

In the user experience (UX) part, it's the UX user who chooses the name of the file to import. Then, the ID becomes the File Name + ID. For example, if the ID is UI8293 and the file name is FILE 1, then the resulting ID would be FILE1UI8293.

Now, what I want to achieve is to add a condition to block the user if the name they choose, combined with the ID length, exceeds 60 characters.

How can I implement this?

Accepted answers

HimanshuRaj

Hi Ilyas, in your source module where you are creating File Name + ID code, create a Number format line item and apply formula → IF LENGTH(File Name + ID code) > 60 THEN 1 ELSE 0. Use this as conditional formatting in new UX to highlight the row in red as length has exceeded 60 characters

https://help.anaplan.com/conditional-formatting-077b0f84-a07a-47b7-afc3-894792119257

Best

All comments

HimanshuRaj

@ILYAS You can highlight the row with a warning that combined characters has exceeded 60 characters and use DCA restrictions to not let them do future actions unless this has been resolved

Best

ILYAS

Hello @HimanshuRaj , should i do it in the UX part? or in the module? I'm sorry i started anaplan just recently so i'm still new to it.
should i change the parameter in the Import Action in the UX? or the card configuration where the UX user put the name of his file.

HimanshuRaj

https://help.anaplan.com/conditional-formatting-077b0f84-a07a-47b7-afc3-894792119257

Best

ILYAS

Thank you @HimanshuRaj, i will do so, but how about showing a message to the UX user saying that the ID is to long, please use a different ID less than ( 60 - ID length)

SriNitya

ILYAS
You can mention please use a different ID less than ( 60 - ID length) on a text card as an instruction in UX

1636583

Dikshant

You can create a new line item (Error message) and make it text format and write a condition

IF LENGTH(Unique Code) . 60 THEN "ID is too long, please use a different ID less than 60 characters" ELSE BLANK

and show it in the same grid in NUX.

Quick Links

Can you help?

Unanswered questions

Prevent end users deleting a list item when using Worksheet in UX.
Hi, I have a worksheet for end users to enter new hires into, for which the list item which persist across versions. I am having an issue where the end user can delete a list item using the grid functionality because the Current Version value is blank, but I want to prevent them deleting them (as data will be lost from…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…