Custom SQL Lookup Field?

  • Posts: 195
  • Thank you received: 5
  • Hikashop Business
10 years 7 months ago #151852

I would like to add a custom field for customers that would be a look-up from an existing SQL table - where the data (in the SQL table) is managed by an external source.

Ideally this field would allow me to create the SQL to fetch the list to be used for selection (as well as group the display of the list).

We're presently using the Community Builder CB Query Field, but would really like to pull this field into the checkout process within HS.

Is there any way to create this (i.e. is there a plugin available somewhere, etc.)?

Please Log in or Create an account to join the conversation.

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
10 years 7 months ago #151881

Hi,

It is possible to create new kind of custom field in HikaShop using plugins.
The "custom field datepicker" is a new kind of custom field and is all managed by a plugin. The data is still stored in a column of the selected table but it is possible to store is in another place.

But there is no plugin available for that specific purpose (I don't know how it would be possible to create a very generic plugin for that).

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

Time to create page: 0.061 seconds
Powered by Kunena Forum