Yes. DNN Platform is a free, open-source CMS under the MIT License.

What is the tech stack for DNN?

DNN runs on ASP.NET (.NET Framework 4.8+) with Microsoft SQL Server (2017+ or Azure SQL).

DNN Platform is community-led and a member project of the .NET Foundation.

What’s the difference between DNN and Evoq?

DNN Platform is the open-source core that's been wildly popular and adopted for over 20 years. Evoq is a commercial offering maintained by DNN Software (IgniteTech) that builds on DNN.

DNN Forums

Ask questions about your website to get help learning DNN and help resolve issues.

Action Forms Basic Help

22 Replies

2 Subscribed to this topic

30 Subscribed to this forum

Sort:

Author

Messages

Justin15

New Around Here

Posts: 19

9/3/2020 8:39 PM

Trying to create a dropdown with checkboxes that will allow new users to pick the role. I am having a hard time understanding how to use boolean expressions and making the dropdown menu work correctly. Very new to this so a couple more examples would be helpful!

Tycho de Waard (SU)

Veteran Member

Posts: 838

Helpful Replier

New Poster

9/4/2020 3:38 AM

I would choose Advanced SQL query as a source for a dropdown.

SELECT RoleName
FROM dbo.Roles

Justin15

New Around Here

Posts: 19

9/4/2020 8:34 PM

Thank you this has helped me make progress i have never used SQL (I have jumped in head first) and after finding the SQL Console i was able to make this work. I do still have one issue i do not understand yet. The drop down has nothing listed but if you click the box the role will pop up then disappear and unclick the box. I also did figure out using the WHERE will allow you to pick what roles to be displayed.

Joe Craig

Veteran Member

Posts: 1246

MVP

9/4/2020 11:33 PM

It would help to see you SQL query and also a screen shot of the configuration of the dropdown.

Justin15

New Around Here

Posts: 19

9/5/2020 6:32 PM

Joe Craig

Veteran Member

Posts: 1246

MVP

9/6/2020 7:58 PM

I think that the two LinkTo entries are wrong. Try setting them to nothing and see if that helps. (And ... I'm doing this from memory so I could be wrong.)

Tycho de Waard (SU)

Veteran Member

Posts: 838

Helpful Replier

New Poster

9/7/2020 3:13 AM

I think Joe is right. If I try:
SELECT RoleName
From Roles
WHERE RoleName IN ('registered users', 'subscribers')

this populates the dropdown correctly. So, without LinkTo fields.

Now, what may come in handy is to adjust the SQL to:
SELECT RoleName, RoleID
From Roles
WHERE RoleName IN ('registered users', 'subscribers')

The first part of the select is what is the name in the dropdown. The second is the value, in case you need the RoleID somewhere else. So, it's the same is if you would use the datasource items and fill them like registered users|2 for instance.

Justin15

New Around Here

Posts: 19

9/7/2020 5:56 PM

Thank you guys tons its working correctly now that i deleted the LinkTo and wrote the SQL as instructed. I still have the issue of the roles not showing up in the drop down menu, after i changed the theme you can see them. Thats clearly the EasyDNN theme and Action Form not working together well. Thanks a ton!!!!

Justin15

New Around Here

Posts: 19

9/7/2020 6:14 PM

Was able to change the font color in the dropdown by: Style Wizard->Theme->Open Action->Edit Style->Fonts->Content->Color

Tycho de Waard (SU)

Veteran Member

Posts: 838

Helpful Replier

New Poster

9/8/2020 4:03 AM

Posted By Justin15 on 07 Sep 2020 05:56 PM
Thank you guys tons its working correctly now that i deleted the LinkTo and wrote the SQL as instructed. I still have the issue of the roles not showing up in the drop down menu, after i changed the theme you can see them. Thats clearly the EasyDNN theme and Action Form not working together well. Thanks a ton!!!!

I never experienced collissions between EDN and DNN Sharp modules but both of them offer great support.

These Forums are for the discussion of the open source CMS DNN platform and ecosystem.

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

If you have (suspected) security issues, please DO NOT post them in the forums but instead follow the official DNN security policy.
No Advertising. This includes the promotion of commercial and non-commercial products or services which are not directly related to DNN.
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.
Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
No Flaming or Trolling.
No Profanity, Racism, or Prejudice.
Site Moderators have the final word on approving / removing a thread or post or comment.
English language posting only, please.

Would you like to help us?

Awesome! Simply post in the forums using the link below and we'll get you started.

Get Involved