[Skip to main content](#vessel-content)

#   Filter Single Dropdown -&gt; Values ?

##

- **[gerryna09](/forum/user/52735-gerryna09 "View gerryna09's Profile")**
- [![gerryna09's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/52735-gerryna09 "View gerryna09's Profile") Topic Author
- [ Offline](/forum/user/52735-gerryna09)

Less More

- Posts: 152
- Thank you received: 11
-
-

5 years 2 months ago [\#335642](#335642) by [gerryna09](/forum/user/52735-gerryna09 "View gerryna09's Profile")  *[Filter Single Dropdown -&gt; Values ?](/forum/45-filters-search/903181-filter-single-dropdown-values#335642 "-- url of the page with the problem -- : demo.hikashop.com -- HikaShop version -- : 4.4.3 -- Joomla version -- : 3.10 -- PHP version -- : 7.4.14 -- Browser(s) name and version -- : Chrome  Custom Fields Table-&gt;product Label-&gt;Km Field type-&gt;Text  Filter Name-&gt;Km Type-&gt;Single Dropdown Apply on-&gt;Custom Fields-&gt;Km  Is there a way to automatically have the values ​​present in the Custom Fiels Km ??")* was created by *[gerryna09](/forum/user/52735-gerryna09 "View gerryna09's Profile")*

-- url of the page with the problem -- : demo.hikashop.com
-- HikaShop version -- : 4.4.3
-- Joomla version -- : 3.10
-- PHP version -- : 7.4.14
-- Browser(s) name and version -- : Chrome

**Custom Fields**
Table-&gt;product Label-&gt;Km Field type-&gt;Text

**Filter**
Name-&gt;Km Type-&gt;Single Dropdown Apply on-&gt;Custom Fields-&gt;Km

Is there a way to automatically have the values ​​present in the Custom Fiels Km ??

[ ![value.jpg](/forum/attachment/53533) ](/forum/attachment/53533 "value.jpg")

- [ ![value.jpg](/forum/attachment/53533) ](/forum/attachment/53533 "value.jpg") [ ](/forum/attachment/53533?download=1 "value.jpg")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzkwMzE4MS1maWx0ZXItc2luZ2xlLWRyb3Bkb3duLXZhbHVlcz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Philip](/forum/user/34318-philip "View Philip's Profile")**
- [![Philip's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/34318-philip "View Philip's Profile")
- [ Offline](/forum/user/34318-philip)

Less More

- Posts: 4820
- Thank you received: 652
-
-

5 years 2 months ago -  5 years 2 months ago [\#335648](#335648) by [Philip](/forum/user/34318-philip "View Philip's Profile")  Replied by *[Philip](/forum/user/34318-philip "View Philip's Profile")* on topic *[Filter Single Dropdown -&gt; Values ?](/forum/45-filters-search/903181-filter-single-dropdown-values#335648 "-- url of the page with the problem -- : demo.hikashop.com -- HikaShop version -- : 4.4.3 -- Joomla version -- : 3.10 -- PHP version -- : 7.4.14 -- Browser(s) name and version -- : Chrome  Custom Fields Table-&gt;product Label-&gt;Km Field type-&gt;Text  Filter Name-&gt;Km Type-&gt;Single Dropdown Apply on-&gt;Custom Fields-&gt;Km  Is there a way to automatically have the values ​​present in the Custom Fiels Km ??")*

Hello,

Your question is relevant, so much so that we have planned to add a feature on this subject.
Quite soon, in a future release, it will be possible to populate your custom field value with a Query request.
This will allow to get dynamically value from Database to your custom field.

We think to release it before the end of September.

Regards

Last edit: 5 years 2 months ago by [Philip](/forum/user/34318-philip "View Philip's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzkwMzE4MS1maWx0ZXItc2luZ2xlLWRyb3Bkb3duLXZhbHVlcz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[gerryna09](/forum/user/52735-gerryna09 "View gerryna09's Profile")**
- [![gerryna09's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/52735-gerryna09 "View gerryna09's Profile") Topic Author
- [ Offline](/forum/user/52735-gerryna09)

Less More

- Posts: 152
- Thank you received: 11
-
-

5 years 2 months ago [\#335671](#335671) by [gerryna09](/forum/user/52735-gerryna09 "View gerryna09's Profile")  Replied by *[gerryna09](/forum/user/52735-gerryna09 "View gerryna09's Profile")* on topic *[Filter Single Dropdown -&gt; Values ?](/forum/45-filters-search/903181-filter-single-dropdown-values#335671 "-- url of the page with the problem -- : demo.hikashop.com -- HikaShop version -- : 4.4.3 -- Joomla version -- : 3.10 -- PHP version -- : 7.4.14 -- Browser(s) name and version -- : Chrome  Custom Fields Table-&gt;product Label-&gt;Km Field type-&gt;Text  Filter Name-&gt;Km Type-&gt;Single Dropdown Apply on-&gt;Custom Fields-&gt;Km  Is there a way to automatically have the values ​​present in the Custom Fiels Km ??")*

I am happy with this answer ![;-)](/media/kunena/emoticons/24.png ";-)")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzkwMzE4MS1maWx0ZXItc2luZ2xlLWRyb3Bkb3duLXZhbHVlcz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86576
- Thank you received: 14320
-
-

5 years 2 months ago [\#335680](#335680) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Filter Single Dropdown -&gt; Values ?](/forum/45-filters-search/903181-filter-single-dropdown-values#335680 "-- url of the page with the problem -- : demo.hikashop.com -- HikaShop version -- : 4.4.3 -- Joomla version -- : 3.10 -- PHP version -- : 7.4.14 -- Browser(s) name and version -- : Chrome  Custom Fields Table-&gt;product Label-&gt;Km Field type-&gt;Text  Filter Name-&gt;Km Type-&gt;Single Dropdown Apply on-&gt;Custom Fields-&gt;Km  Is there a way to automatically have the values ​​present in the Custom Fiels Km ??")*

Hi,

Philippe made a mistake here.
We did work on a feature to allow custom fields's values to be filled automatically with a MySQL query.
However, this won't help for your case since you're talking about filter getting the values of the fields, not filling the field values.

Actually, filters already automatically use the values of custom fields, but only it you have values entered in the custom field, and that's only possible with custom fields of the type "radio", "checkbox", "single dropdown" and "multiple dropdown".

So in your case, the solution would be the change the type of your custom field to "single dropdown" and enter in the "values" area of your custom field all the possible distances you want for your products so that you can then select among them when you edit the products in your backend. Then, if you leave the "values" of your filter empty, it will automatically use the values of your custom field.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzkwMzE4MS1maWx0ZXItc2luZ2xlLWRyb3Bkb3duLXZhbHVlcz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[gerryna09](/forum/user/52735-gerryna09 "View gerryna09's Profile")**
- [![gerryna09's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/52735-gerryna09 "View gerryna09's Profile") Topic Author
- [ Offline](/forum/user/52735-gerryna09)

Less More

- Posts: 152
- Thank you received: 11
-
-

5 years 2 months ago [\#335686](#335686) by [gerryna09](/forum/user/52735-gerryna09 "View gerryna09's Profile")  Replied by *[gerryna09](/forum/user/52735-gerryna09 "View gerryna09's Profile")* on topic *[Filter Single Dropdown -&gt; Values ?](/forum/45-filters-search/903181-filter-single-dropdown-values#335686 "-- url of the page with the problem -- : demo.hikashop.com -- HikaShop version -- : 4.4.3 -- Joomla version -- : 3.10 -- PHP version -- : 7.4.14 -- Browser(s) name and version -- : Chrome  Custom Fields Table-&gt;product Label-&gt;Km Field type-&gt;Text  Filter Name-&gt;Km Type-&gt;Single Dropdown Apply on-&gt;Custom Fields-&gt;Km  Is there a way to automatically have the values ​​present in the Custom Fiels Km ??")*

Hi Nicolas, it is clear to me that I have to use custom fields of the type "radio", "checkbox", "single dropdown" and "multiple dropdown".

But unfortunately I have a field in which I will have to enter the YEAR

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzkwMzE4MS1maWx0ZXItc2luZ2xlLWRyb3Bkb3duLXZhbHVlcz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86576
- Thank you received: 14320
-
-

5 years 2 months ago [\#335688](#335688) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Filter Single Dropdown -&gt; Values ?](/forum/45-filters-search/903181-filter-single-dropdown-values#335688 "-- url of the page with the problem -- : demo.hikashop.com -- HikaShop version -- : 4.4.3 -- Joomla version -- : 3.10 -- PHP version -- : 7.4.14 -- Browser(s) name and version -- : Chrome  Custom Fields Table-&gt;product Label-&gt;Km Field type-&gt;Text  Filter Name-&gt;Km Type-&gt;Single Dropdown Apply on-&gt;Custom Fields-&gt;Km  Is there a way to automatically have the values ​​present in the Custom Fiels Km ??")*

Hi,

Why is that a problem ? You could have a "single dropdown" custom field. Just enter the years that you need as values of the custom field. It should even let you type the year in the field to search for the value to select.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzkwMzE4MS1maWx0ZXItc2luZ2xlLWRyb3Bkb3duLXZhbHVlcz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[gerryna09](/forum/user/52735-gerryna09 "View gerryna09's Profile")**
- [![gerryna09's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/52735-gerryna09 "View gerryna09's Profile") Topic Author
- [ Offline](/forum/user/52735-gerryna09)

Less More

- Posts: 152
- Thank you received: 11
-
-

5 years 2 months ago [\#335711](#335711) by [gerryna09](/forum/user/52735-gerryna09 "View gerryna09's Profile")  Replied by *[gerryna09](/forum/user/52735-gerryna09 "View gerryna09's Profile")* on topic *[Filter Single Dropdown -&gt; Values ?](/forum/45-filters-search/903181-filter-single-dropdown-values#335711 "-- url of the page with the problem -- : demo.hikashop.com -- HikaShop version -- : 4.4.3 -- Joomla version -- : 3.10 -- PHP version -- : 7.4.14 -- Browser(s) name and version -- : Chrome  Custom Fields Table-&gt;product Label-&gt;Km Field type-&gt;Text  Filter Name-&gt;Km Type-&gt;Single Dropdown Apply on-&gt;Custom Fields-&gt;Km  Is there a way to automatically have the values ​​present in the Custom Fiels Km ??")*

The site needs to be updated by a publisher who will not have access to custom fields ;-(

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzkwMzE4MS1maWx0ZXItc2luZ2xlLWRyb3Bkb3duLXZhbHVlcz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86576
- Thank you received: 14320
-
-

5 years 2 months ago [\#335720](#335720) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Filter Single Dropdown -&gt; Values ?](/forum/45-filters-search/903181-filter-single-dropdown-values#335720 "-- url of the page with the problem -- : demo.hikashop.com -- HikaShop version -- : 4.4.3 -- Joomla version -- : 3.10 -- PHP version -- : 7.4.14 -- Browser(s) name and version -- : Chrome  Custom Fields Table-&gt;product Label-&gt;Km Field type-&gt;Text  Filter Name-&gt;Km Type-&gt;Single Dropdown Apply on-&gt;Custom Fields-&gt;Km  Is there a way to automatically have the values ​​present in the Custom Fiels Km ??")*

Hi,

But still, why can't you add all the reasonably possible years ?
For example, if you're selling cars or car parts, the possible years will be anything between 1950 and 2030. That's 80 values you can add in the custom field. If you're selling wine, it should be between 1900 and 2030 I guess, etc.
Or are your selling that you'll be selling anything older than that ? Why couldn't you enter all the values ?

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzkwMzE4MS1maWx0ZXItc2luZ2xlLWRyb3Bkb3duLXZhbHVlcz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[gerryna09](/forum/user/52735-gerryna09 "View gerryna09's Profile")**
- [![gerryna09's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/52735-gerryna09 "View gerryna09's Profile") Topic Author
- [ Offline](/forum/user/52735-gerryna09)

Less More

- Posts: 152
- Thank you received: 11
-
-

5 years 2 months ago -  5 years 2 months ago [\#335729](#335729) by [gerryna09](/forum/user/52735-gerryna09 "View gerryna09's Profile")  Replied by *[gerryna09](/forum/user/52735-gerryna09 "View gerryna09's Profile")* on topic *[Filter Single Dropdown -&gt; Values ?](/forum/45-filters-search/903181-filter-single-dropdown-values#335729 "-- url of the page with the problem -- : demo.hikashop.com -- HikaShop version -- : 4.4.3 -- Joomla version -- : 3.10 -- PHP version -- : 7.4.14 -- Browser(s) name and version -- : Chrome  Custom Fields Table-&gt;product Label-&gt;Km Field type-&gt;Text  Filter Name-&gt;Km Type-&gt;Single Dropdown Apply on-&gt;Custom Fields-&gt;Km  Is there a way to automatically have the values ​​present in the Custom Fiels Km ??")*

The solution is clear.
But I am lazy. I should enter a lot of dates ![:P](/media/kunena/emoticons/14.png ":P")
Thanks

Last edit: 5 years 2 months ago by [gerryna09](/forum/user/52735-gerryna09 "View gerryna09's Profile").

The following user(s) said Thank You: [Philip](/forum/user/34318-philip "View Philip's Profile")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzkwMzE4MS1maWx0ZXItc2luZ2xlLWRyb3Bkb3duLXZhbHVlcz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to?

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.074 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
