0

I have a requirement for my app that essentially uses cascading drop downs to get a rating value.  So the first dropdown has 19 different asset option, once that is chosen the next dropdown would have between 1 and 5 unique sets of category options depending on the asset chosen.  Next, depending on the asset and category a unique set of sub-category options would be available to choose.  Then, based off those 3 choices a rating can be assigned.   Is there a good way to do this in Mendix?  Can you create a data table or insert an excel table into Mendix to search for unique items to populate dropdown lists?  If I were doing this in C# or Java I would essentially look through an excel table all the total options and after a selection is made then go find the options that match my current choices.  I was given an excel table with all 259 unique combinations of asset, category and sub-category so don't really want to create a bunch of entities on an admin page or something as I would have to do that for all of the testing and production environments.

asked 2024-12-11

1 answers