Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForm and ListForm and ListUsing Form & List Module as a replacement for "Lists" module now removed in DNN 9Using Form & List Module as a replacement for "Lists" module now removed in DNN 9
Previous
 
Next
New Post
6/3/2018 5:39 PM
 

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.

 
New Post
6/5/2018 1:53 PM
 
Perhaps you can try the 2sxc module (free) from here: https://2sxc.org/en/
Or: openform from Sacha: https://github.com/sachatrauwaen
 
New Post
6/6/2018 8:23 AM
 
Either use Form&List to create your data and forms or use any of the other forms modules.
Maybe even DataSprings Forms does include an editor in latest version?

Cheers from Germany,
Sebastian Leupold (Microsoft MVP)

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
6/6/2018 8:24 AM
 
PS:: There are plans to integrate LiquidForms from Evoq into DNN in the future, but there are no details atm.

Cheers from Germany,
Sebastian Leupold (Microsoft MVP)

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForm and ListForm and ListUsing Form & List Module as a replacement for "Lists" module now removed in DNN 9Using Form & List Module as a replacement for "Lists" module now removed in DNN 9


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.

Content Layout

Subscribe to DNN Digest

Subscribe to DNN Digest

DNN Digest is our monthly email newsletter. It highlights news and content from around the DNN ecosystem, such as new modules and themes, messages from leadership, blog posts and notable tweets. Keep your finger on the pulse of the ecosystem by subscribing.  

What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out