Long loading cascadingdropdown elements

intmarine

New Member
Hello

I have built some pages based on a Fabrik framework built by Jean-Francois Questiaux <info@betterliving.be> for my project. All props to him, and anything negative is due to my amateur-hour guidance of a different otherwise competent, but first-time Fabrik programmer who built these pages.

On the linked page (<http://www.dcinemacompliance.com/index.php?option=com_fabrik&view=form&formid=46>), half-way down, there are 2 matrix named ?Survey Loudspeakers? and ?Survey Amplifiers?. These refer back to one large database of items that refer to Equipment Type and Manufactures and Model Numbers. Obviously, the matrix is made of a series of dropdown and cascadingdropdown elements.

The problem is that each of the 24 elements ? all which contain the same elements and options, and are searching the same things ? go looking and looking one after the other. It takes a ton of time. ?and looks silly.

Is there a more efficient way to achieve the same goal of filling in the pull-down options. If that?s the way it goes, the so be it. Just thought I would check.

Thanks.
 
I would use only one dbjoin per item:
use the "or concat label" to show e.g. Manufactures + Model Numbers in the dropdown, (something like {thistable}.your-man-column,'-',{thistable}.your-model-column)
enable the "Advanced Format (WIP)" which will show a "search field" on top of the dropdown values (start typing the manufacture and the dropdown will show only those models)
I think this "Advanced Format" is not included in the official Fabrik3.2.3, you have to update from GitHub
 
We are in need of some funding.
More details.

Thank you.

Members online

Back
Top