Add Product Names (without codes) to a Numbered Product List via UX Page

Hi All,

I'm a bit stuck and needed help here.

I have a numbered list of products and user now want to add a subset of products under this list, specifically to a new subset called "Subset - X," which doesn't have codes. The users would like to create new products in "Subset - X" via the UX page and as model builders we need to ensure that no duplicate product names are entered into the list.

Any suggestions would be greatly appreciated!

Accepted answers

AjayM

Hi @Isha ,

If duplicate names are not allowed, may I know why you have products as a numbered list at first place?

With numbered list, you can't validate and avoid duplicate names, during creation of the list items. While you are offering a form action to let users add items to the product list, you may need a second action/button that will validate the overall entries, and delete the items with duplicate names:

1. You can design whether to delete the oldest duplicate item or the most recent duplicate item (deleting latest item is recommended since oldest item may have some data against it already)
2. Alternatively, you can highlight those duplicate items on UX page with conditional formatting, and let users pick and choose which duplicate ones they would like to delete, with the help of a boolean selector and a delete action.

Cheers!

Dikshant

Here is the detailed solution of the problem statement mentioned above:

Create an Index list and add a list item "1."
Build a module named INP01 Input Project Name, add a text line item called Add Project Name.
Create a line item in the same module CF Project Name.
Set up a system module named SYS01 Project Details with a line item called Project Exists (Summary: Any).
Use the following formula for the Project Exists line item:
- Project list.Display Name = INP01 Input Project Name.Add Project Name
For the CF Project Name line item in the SYS01 Project Details module, use this formula:
- IF SYS01 Project Details.Project Exists[SELECT: Project list.All Projects] THEN 0 ELSE 1
After publishing, use this CF for the Add Project Name line item on the NUX Page.
Create a process containing two actions:
- The first action will add the project if the CF equals 1, marking the required subsets as TRUE.
- The second action will clear the values from the Add Project Detail line item.
Finally, publish the process to the NUX.

All comments

AjayM

Hi @Isha ,

If duplicate names are not allowed, may I know why you have products as a numbered list at first place?

Dikshant

Here is the detailed solution of the problem statement mentioned above:

Create an Index list and add a list item "1."
Build a module named INP01 Input Project Name, add a text line item called Add Project Name.
Create a line item in the same module CF Project Name.
Set up a system module named SYS01 Project Details with a line item called Project Exists (Summary: Any).
Use the following formula for the Project Exists line item:
- Project list.Display Name = INP01 Input Project Name.Add Project Name
For the CF Project Name line item in the SYS01 Project Details module, use this formula:
- IF SYS01 Project Details.Project Exists[SELECT: Project list.All Projects] THEN 0 ELSE 1
After publishing, use this CF for the Add Project Name line item on the NUX Page.
Create a process containing two actions:
- The first action will add the project if the CF equals 1, marking the required subsets as TRUE.
- The second action will clear the values from the Add Project Detail line item.
Finally, publish the process to the NUX.

Isha

Hi @AjayM,

,Thank you for your response and Valid inputs!

We currently have a numbered list of products in the model that uses codes. However, we now need to add new products to this list that do not have codes. The rest of the products in the list use codes but the new 'subset - X' contains only a few items and they do not have codes.
Your suggestion to highlight duplicate items using conditional formatting worked well.

Isha

Hi @ Dikshant,

Perfect! This worked out great!
Thank you so much for your detailed and clear explanation.

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
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.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385