215 Posts
cubist
10 years ago
2
Topic

Wasn't sure where this question best belongs... Content types or Search Types

To illustrate my question, let's say a client wants to create quotes for their customers (using a content type).

There are lots of parts to a quote system, but it seems the crux of the project is:

1) Using a content type to build a list of parts

2) However, if the parts list is 8000 long (in a separate dB table), then the client would need to use a Field X / Search combo -- right? 

    -- Where they can add a part to their list (for the quote) by searching the parts table (by SKU, or other)

    -- Then add another, and keep adding them

Am I on the right path here ...?

Thx much!

Get a VIP membership
572 Posts
_jrmo
10 years ago
1
Level 1

Hi Cubist,

I would approach this by using a Dynamic Select field and a Field X combo. The Dynamic Select field can be set up to retrieve the list of 8000 part numbers from your table. You could then use a Field X field to allow people to select multiple parts. 

I would then use some javascript in a template override in order to transform the output of the Dynamic Select field to be an autocomplete input box. So the user can start typing their part name, and the javascript will do the rest. See here:

http://api.jqueryui.com/autocomplete/

I hope this helps,

_jrmo

4229 Posts
Kadministrator
10 years ago
0
Level 2

If you have jquery chosen active on the page (as it is the case with +default joomla 3 templates) you already have autocomplete feature included with selects. If not you can jsut add chosen to your template like

JHtml::_('behavior.framework', true);
JHtml::_('formbehavior.chosen', 'select');
Get a VIP membership