[Skip to main content](#vessel-content) # DB Driven custom field? ## - **[icomex](/forum/user/4967-icomex "View icomex's Profile")** - [![icomex's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4967.png)](/forum/user/4967-icomex "View icomex's Profile") Topic Author - [ Offline](/forum/user/4967-icomex) Less More - Posts: 149 - Thank you received: 6 - - 8 years 8 months ago [\#288445](#288445) by [icomex](/forum/user/4967-icomex "View icomex's Profile") *[DB Driven custom field?](/forum/31-development/893896-db-driven-custom-field#288445 "-- HikaShop version -- : 3.3 -- Joomla version -- : 3.8.5 -- PHP version -- : 7.1.14 I don't think this is currently included, but I'm thinking about updating a customer's very old, custom online order system using Hikashop as it's skeleton. The old system's product definitions included several fields that were populated by lookup values from large, simple indexes (stored in database tables of their own). Hikashop's simple dropdown field types require us to enter each value, which is perfectly understandable. However, if Hikashop has incorporated Joomla form fields, there is one which looks up a pair of values from a database. Is there any way to create a new "field type" for use in Hikashop's custom fields interface which uses JFormFieldSQL? If not, maybe it could use a lookup list from a document written in XML or preferably JSON? I fear I'm looking at the beginning of a really massive headache, here.")* was created by *[icomex](/forum/user/4967-icomex "View icomex's Profile")* -- HikaShop version -- : 3.3 -- Joomla version -- : 3.8.5 -- PHP version -- : 7.1.14 I don't think this is currently included, but I'm thinking about updating a customer's very old, custom online order system using Hikashop as it's skeleton. The old system's product definitions included several fields that were populated by lookup values from large, simple indexes (stored in database tables of their own). Hikashop's simple dropdown field types require us to enter each value, which is perfectly understandable. However, if Hikashop has incorporated Joomla form fields, there is one which looks up a pair of values from a database. Is there any way to create a new "field type" for use in Hikashop's custom fields interface which uses JFormFieldSQL? If not, maybe it could use a lookup list from a document written in XML or preferably JSON? I fear I'm looking at the beginning of a really massive headache, here. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMxLWRldmVsb3BtZW50Lzg5Mzg5Ni1kYi1kcml2ZW4tY3VzdG9tLWZpZWxkP3RtcGw9bWFya2Rvd24=) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86541 - Thank you received: 14304 - - 8 years 8 months ago [\#288457](#288457) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[DB Driven custom field?](/forum/31-development/893896-db-driven-custom-field#288457 "-- HikaShop version -- : 3.3 -- Joomla version -- : 3.8.5 -- PHP version -- : 7.1.14 I don't think this is currently included, but I'm thinking about updating a customer's very old, custom online order system using Hikashop as it's skeleton. The old system's product definitions included several fields that were populated by lookup values from large, simple indexes (stored in database tables of their own). Hikashop's simple dropdown field types require us to enter each value, which is perfectly understandable. However, if Hikashop has incorporated Joomla form fields, there is one which looks up a pair of values from a database. Is there any way to create a new "field type" for use in Hikashop's custom fields interface which uses JFormFieldSQL? If not, maybe it could use a lookup list from a document written in XML or preferably JSON? I fear I'm looking at the beginning of a really massive headache, here.")* Hi, We actually looked at trying to support the Joomla custom field types as HikaShop custom fields but that was too much complex and not meant for that. Instead it's much easier to create new types of custom fields for HikaShop when needed. You would need to create a hikashop plugin and implement the onFieldsLoad trigger: [ www.hikashop.com/support/documentation/6...entation.html#fields](https://www.hikashop.com/support/documentation/62-hikashop-developer-documentation.html#fields) You can see a complete example with the plugins/hikashop/datepickerfield/ plugin. This plugin actually adds the "advanced date picker" type to custom fields. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMxLWRldmVsb3BtZW50Lzg5Mzg5Ni1kYi1kcml2ZW4tY3VzdG9tLWZpZWxkP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[icomex](/forum/user/4967-icomex "View icomex's Profile")** - [![icomex's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4967.png)](/forum/user/4967-icomex "View icomex's Profile") Topic Author - [ Offline](/forum/user/4967-icomex) Less More - Posts: 149 - Thank you received: 6 - - 8 years 8 months ago [\#288549](#288549) by [icomex](/forum/user/4967-icomex "View icomex's Profile") Replied by *[icomex](/forum/user/4967-icomex "View icomex's Profile")* on topic *[DB Driven custom field?](/forum/31-development/893896-db-driven-custom-field#288549 "-- HikaShop version -- : 3.3 -- Joomla version -- : 3.8.5 -- PHP version -- : 7.1.14 I don't think this is currently included, but I'm thinking about updating a customer's very old, custom online order system using Hikashop as it's skeleton. The old system's product definitions included several fields that were populated by lookup values from large, simple indexes (stored in database tables of their own). Hikashop's simple dropdown field types require us to enter each value, which is perfectly understandable. However, if Hikashop has incorporated Joomla form fields, there is one which looks up a pair of values from a database. Is there any way to create a new "field type" for use in Hikashop's custom fields interface which uses JFormFieldSQL? If not, maybe it could use a lookup list from a document written in XML or preferably JSON? I fear I'm looking at the beginning of a really massive headache, here.")* Cool! Thank you for the lead. If I can make it work gracefully, I'll post it back to you here. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMxLWRldmVsb3BtZW50Lzg5Mzg5Ni1kYi1kcml2ZW4tY3VzdG9tLWZpZWxkP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & 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.041 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)