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

Isha
Isha
edited October 22 in Modeling

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!

😀

Best Answers

  • AjayM
    AjayM
    edited October 22 Answer ✓

    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
    Dikshant
    edited October 22 Answer ✓

    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.

Answers

  • Isha
    Isha
    edited October 22

    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
    Isha

    Hi @ Dikshant,

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

    😀

Categories