I have what I feel like should be a normal activity but I am not seeing any good tools to accomplish this in DNN. I could use some advice on how others might approach this task.
I need to create a "New Products" page. The page contains lists of products divided by category. Along with these lists, there is some other info on the page, an intro paragraph, a concluding paragraph, and a variable number of linked images. Sometimes there can be 10 separate lists on each page and there are about 10 of these created per month. If the lists are created as stand alone data objects, it is going to quickly become problematic to manage from a data standpoint. For this reason I wish to encapsulate all of the information related to this page into a single data object.
The problem I am running into here is that the product lists need to be grouped with the title of the section in which they are contained and there can be 'N' lists. In data, this breaks down to a minimum of two fields, a delimited list of productIds and a title. These fields need to be connected, or there must be some way to programatically determine that the list title is associated with the products. I have tested with XMod Pro and the newest version of 2SexyContent but neither has the ability to create groups of fields as described.
Somewhat linked to this, neither of these modules allow a variable number of fields in the data entry/content entry form. By this I mean that if you need to create a list of items, you must do it with a single text field that holds a list of delimited keys that can be parsed. You cannot specify a "Product Key" field in the data entry form and then click to add another, there are a fixed number of fields. Since there is the lack of ability to use anything but a fixed number of fields, it naturally follows that there wouldn't be the notion of a field group as it wouldn't be necessary since each field present would be well defined and known before the data was created.
Call me crazy, but this sounds like normal activity when dealing with data. Has anyone dealt with this and what was the solution?