Greetings to you!
I am trying to migrate a form I built using DataSprings Dynamic Form few years ago (with DNN 5). I used "Host >> Lists" to create many Lists to feed as the entries for many DropDown lists used in the form. For example: List of Registration Options, List of items with Parent-Child relationships (for use in 'Dependent Lists'), etc. Now in DNN 9 the "Host >> Lists" feature is totally removed; as such, there is no way for me to easily create Lists for use with DropDown lists in the Forms.
For example: In the Form, I have a DropDown list named: "Select your Community Center" with a list of "Community Centers" shown based on a SQL query:
Example 1: (simple list):
select Text as QuestionOption, Text as QuestionOptionValue from Lists where ListName= 'Community Centers' ORDER BY QuestionOption
Example 2: Parent-Child relationship:
select Text as QuestionOption, value as QuestionOptionValue from Lists where ListName= 'R05_Ret_Reg_Rate' AND ParentID = '$(Master_Reg_Option)' ORDER BY QuestionOption
In the absence of Host >> Lists feature in DNN, how can I create a Table called Lists or NewLists to provide a similar functionality of earlier "Host >> Lists"?
I think we need columns like:
Item Id: <unique id>
Item Text: <Label or visible text to be used as an Option in the Dropdown list, Checkbox list, RadioButons list, etc.>
Item Value: <the 'value' associated with the Label / visible Text: example: Sunday (SUN), Monday (MON), Tuesday (TUE), etc.
Parent Item Id: <Parent Id, if applicable>
One advantage of using Form and List to create such "Lists" is any authorized user (not necessarily a Host or Admin) can maintain the List (adding, changing, deleting the entries in a List using the browser interface).
Any help (any pointer to a detailed example) is greatly appreciated.