Forums

Please write a review for the extension you are using on the Joomla extensions directory before posting a new question as we are being spammed by many negative reviews.

Thank you for your support!

Model options filtering in dropdown menu

MTUG 16 Jun, 2020

Hi im trying to create a dropdown menu that shows menu items imported from my database just like the demo.

My problem is the dropdown menu items are views multipletimes, see the following screenshot.
https://prnt.sc/t0qpmt

i guess it takes every single item without any filtering at all. it shows 6 items labeld MR because there is 6 MR projects in the database.

my admin settings:
https://prnt.sc/t0qrem

Thanks in advance!

Max_admin 16 Jun, 2020

what does the debug show the results of the Read data action ?

Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?

healyhatman 16 Jun, 2020

Instead of columnname in the select try DISTINCT columnname

MTUG 17 Jun, 2020

Here is a screen shot of the debug
https://prnt.sc/t178x2

MTUG 17 Jun, 2020

Hi healyhatman,
I cant find where to select DISTINCT columnname
here is screenshot of my dropdown menu settingshttps://prnt.sc/t17b90

Max_admin 17 Jun, 2020

I suggest that you update to the v7 RC1, there is a change to the Model options, now its called "Dynamic options", also the "modalitet" field is not unique, so you should not use it for the option value, or later records will override the earlier ones!

Please read the update notes on the blog here before updating:
http://www.chronoengine.com/blog

Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?

This topic is locked and no more replies can be posted.

2Checkout.com

2CheckOut.com Inc. (Ohio, USA) is an authorized retailer for goods and services provided by ChronoEngine.com