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
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
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
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
This topic is locked and no more replies can be posted.