Multiple Select on Table Join dropdown?

[nbradshaw]

Here is my scenario:

I would like to keep a list of devices (hundreds) in a separate table - so that I don't have to add them all to the Fabrik Back End (it gets very sluggish when you add a tone of options on the back end-understandably). But if I do a table join, I do not get an option to do a multiple select - and I need this feature.

What is the best approach to this? Are these options/devices stored in a table within the fabrik component that I can just add them their, instead of the Fabrik Back End?

Many thanks!

2.0.3b

[cheesegrits]

While we don't advise poking around in the fabrik metadata tables ... yes, you could edit the fabrik_elements table directly, and modify sub_values, sub_labels and sub_initial_select for your dropdown element. Should be obvious from the existing data what format you need to use for those columns.

Of course, if everything then blows up and rips a hole in the Fabrik of Space and Time ... that's your problem, not mine. :)

-- hugh

[nbradshaw]

Thanks hugh!

I found the table...and added my devices there..it works great!

Thanks!

[rob]

another solution is to make a database join element pointing to your devices table, and put it in its own group with the repeat group option on