[Skip to main content](#vessel-content) # checkout - custom field from a different table ## - **[dan@buliga.co.uk](/forum/user/12181-dan-buliga-co-uk "View dan@buliga.co.uk's Profile")** - [![dan@buliga.co.uk's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/12181-dan-buliga-co-uk "View dan@buliga.co.uk's Profile") Topic Author - [ Offline](/forum/user/12181-dan-buliga-co-uk) Less More - Posts: 2 - Thank you received: 0 - - 12 years 8 months ago [\#144589](#144589) by [dan@buliga.co.uk](/forum/user/12181-dan-buliga-co-uk "View dan@buliga.co.uk's Profile") *[checkout - custom field from a different table](/forum/27-checkout/865992-checkout-custom-field-from-a-different-table#144589 "custom fields - "order" (table) in checkout conditioned by "product" (table) specifications "display limited" - how to select another custom field from a different table -- HikaShop version -- : 2.2.3 -- Joomla version -- : 2.5 Hi, I have this specific case which require: Multiple products/plans defined * Cleanse 1, Cleanse 2, Cleanse 3 Each product/plan has multiple variants * Cleanse 1 - 1 Day Cleanse - 2 Day Cleanse - 5 Day Cleanse * Cleanse 2 - 1 Day Cleanse - 2 Day Cleanse - 5 Day Cleanse and so on ... For each variant will correspond a specific number of deliveries * Cleanse 1 - 1 Day Cleanse - 1 delivery - 2 Day Cleanse - 2 deliveries - 5 Day Cleanse - 3 deliveries * Cleanse 2 - 1 Day Cleanse - 1 delivery - 2 Day Cleanse - 2 deliveries - 5 Day Cleanse - 3 deliveries On Checkout form, specific to each plan/variant, the user should have the possibility to specify each delivery date for the deliveries (for example if the user will go for Cleanse 1 - 2 Day Cleanse, he should be able to select two delivery days, one for each delivery) What I've done till now was to add a custom field to "product" table defined as a Single Drop-down with specific values (Number of deliveries - 1,2,3) and selected Front-end / Back-end which allowed me to go in Back-end and specify for each variant the specific "Number of deliveries" and at the same time the specified value was showed in the Front-end as "Specification - Number of Deliveries (value)". In order to allow the user to set specific dates for the delivery at the checkout form I need to use the "order" table custom fields. How could I make the link between the "product" table and "order table" because if I use the "order" table I can`t use the option "Display limited to" on the "product" table. Thank you")* was created by *[dan@buliga.co.uk](/forum/user/12181-dan-buliga-co-uk "View dan@buliga.co.uk's Profile")* custom fields - "order" (table) in checkout conditioned by "product" (table) specifications "display limited" - how to select another custom field from a different table -- HikaShop version -- : 2.2.3 -- Joomla version -- : 2.5 Hi, I have this specific case which require: Multiple products/plans defined * Cleanse 1, Cleanse 2, Cleanse 3 Each product/plan has multiple variants * Cleanse 1 - 1 Day Cleanse - 2 Day Cleanse - 5 Day Cleanse * Cleanse 2 - 1 Day Cleanse - 2 Day Cleanse - 5 Day Cleanse and so on ... For each variant will correspond a specific number of deliveries * Cleanse 1 - 1 Day Cleanse - 1 delivery - 2 Day Cleanse - 2 deliveries - 5 Day Cleanse - 3 deliveries * Cleanse 2 - 1 Day Cleanse - 1 delivery - 2 Day Cleanse - 2 deliveries - 5 Day Cleanse - 3 deliveries On Checkout form, specific to each plan/variant, the user should have the possibility to specify each delivery date for the deliveries (for example if the user will go for Cleanse 1 - 2 Day Cleanse, he should be able to select two delivery days, one for each delivery) What I've done till now was to add a custom field to "product" table defined as a Single Drop-down with specific values (Number of deliveries - 1,2,3) and selected Front-end / Back-end which allowed me to go in Back-end and specify for each variant the specific "Number of deliveries" and at the same time the specified value was showed in the Front-end as "Specification - Number of Deliveries (value)". In order to allow the user to set specific dates for the delivery at the checkout form I need to use the "order" table custom fields. How could I make the link between the "product" table and "order table" because if I use the "order" table I can`t use the option "Display limited to" on the "product" table. Thank you Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI3LWNoZWNrb3V0Lzg2NTk5Mi1jaGVja291dC1jdXN0b20tZmllbGQtZnJvbS1hLWRpZmZlcmVudC10YWJsZT90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")** - [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") - [ Offline](/forum/user/6861-mohamed-thelji) Less More - Posts: 12953 - Thank you received: 1778 - - - 12 years 8 months ago [\#144620](#144620) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[checkout - custom field from a different table](/forum/27-checkout/865992-checkout-custom-field-from-a-different-table#144620 "custom fields - "order" (table) in checkout conditioned by "product" (table) specifications "display limited" - how to select another custom field from a different table -- HikaShop version -- : 2.2.3 -- Joomla version -- : 2.5 Hi, I have this specific case which require: Multiple products/plans defined * Cleanse 1, Cleanse 2, Cleanse 3 Each product/plan has multiple variants * Cleanse 1 - 1 Day Cleanse - 2 Day Cleanse - 5 Day Cleanse * Cleanse 2 - 1 Day Cleanse - 2 Day Cleanse - 5 Day Cleanse and so on ... For each variant will correspond a specific number of deliveries * Cleanse 1 - 1 Day Cleanse - 1 delivery - 2 Day Cleanse - 2 deliveries - 5 Day Cleanse - 3 deliveries * Cleanse 2 - 1 Day Cleanse - 1 delivery - 2 Day Cleanse - 2 deliveries - 5 Day Cleanse - 3 deliveries On Checkout form, specific to each plan/variant, the user should have the possibility to specify each delivery date for the deliveries (for example if the user will go for Cleanse 1 - 2 Day Cleanse, he should be able to select two delivery days, one for each delivery) What I've done till now was to add a custom field to "product" table defined as a Single Drop-down with specific values (Number of deliveries - 1,2,3) and selected Front-end / Back-end which allowed me to go in Back-end and specify for each variant the specific "Number of deliveries" and at the same time the specified value was showed in the Front-end as "Specification - Number of Deliveries (value)". In order to allow the user to set specific dates for the delivery at the checkout form I need to use the "order" table custom fields. How could I make the link between the "product" table and "order table" because if I use the "order" table I can`t use the option "Display limited to" on the "product" table. Thank you")* Hi, A solution can be to display your 3 delivery dates through your checkout, but if you want the number of delivery date fields to be adapted to the number of delivery that you've selected through your product page, you'll have to edit the code of the files of your "checkout" view of your front-end template through "*Hikashop->Display->Views*". Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI3LWNoZWNrb3V0Lzg2NTk5Mi1jaGVja291dC1jdXN0b20tZmllbGQtZnJvbS1hLWRpZmZlcmVudC10YWJsZT90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[dan@buliga.co.uk](/forum/user/12181-dan-buliga-co-uk "View dan@buliga.co.uk's Profile")** - [![dan@buliga.co.uk's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/12181-dan-buliga-co-uk "View dan@buliga.co.uk's Profile") Topic Author - [ Offline](/forum/user/12181-dan-buliga-co-uk) Less More - Posts: 2 - Thank you received: 0 - - 12 years 8 months ago [\#144625](#144625) by [dan@buliga.co.uk](/forum/user/12181-dan-buliga-co-uk "View dan@buliga.co.uk's Profile") Replied by *[dan@buliga.co.uk](/forum/user/12181-dan-buliga-co-uk "View dan@buliga.co.uk's Profile")* on topic *[checkout - custom field from a different table](/forum/27-checkout/865992-checkout-custom-field-from-a-different-table#144625 "custom fields - "order" (table) in checkout conditioned by "product" (table) specifications "display limited" - how to select another custom field from a different table -- HikaShop version -- : 2.2.3 -- Joomla version -- : 2.5 Hi, I have this specific case which require: Multiple products/plans defined * Cleanse 1, Cleanse 2, Cleanse 3 Each product/plan has multiple variants * Cleanse 1 - 1 Day Cleanse - 2 Day Cleanse - 5 Day Cleanse * Cleanse 2 - 1 Day Cleanse - 2 Day Cleanse - 5 Day Cleanse and so on ... For each variant will correspond a specific number of deliveries * Cleanse 1 - 1 Day Cleanse - 1 delivery - 2 Day Cleanse - 2 deliveries - 5 Day Cleanse - 3 deliveries * Cleanse 2 - 1 Day Cleanse - 1 delivery - 2 Day Cleanse - 2 deliveries - 5 Day Cleanse - 3 deliveries On Checkout form, specific to each plan/variant, the user should have the possibility to specify each delivery date for the deliveries (for example if the user will go for Cleanse 1 - 2 Day Cleanse, he should be able to select two delivery days, one for each delivery) What I've done till now was to add a custom field to "product" table defined as a Single Drop-down with specific values (Number of deliveries - 1,2,3) and selected Front-end / Back-end which allowed me to go in Back-end and specify for each variant the specific "Number of deliveries" and at the same time the specified value was showed in the Front-end as "Specification - Number of Deliveries (value)". In order to allow the user to set specific dates for the delivery at the checkout form I need to use the "order" table custom fields. How could I make the link between the "product" table and "order table" because if I use the "order" table I can`t use the option "Display limited to" on the "product" table. Thank you")* So the first thing would be to define the three delivery dates in the checkout form and after that go and modify/adapt the code ? Could it be possible to give an example on how this should look ?? Thanks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI3LWNoZWNrb3V0Lzg2NTk5Mi1jaGVja291dC1jdXN0b20tZmllbGQtZnJvbS1hLWRpZmZlcmVudC10YWJsZT90bXBsPW1hcmtkb3du) or [Create an account](/register) 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: 86323 - Thank you received: 14283 - - 12 years 8 months ago [\#144808](#144808) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[checkout - custom field from a different table](/forum/27-checkout/865992-checkout-custom-field-from-a-different-table#144808 "custom fields - "order" (table) in checkout conditioned by "product" (table) specifications "display limited" - how to select another custom field from a different table -- HikaShop version -- : 2.2.3 -- Joomla version -- : 2.5 Hi, I have this specific case which require: Multiple products/plans defined * Cleanse 1, Cleanse 2, Cleanse 3 Each product/plan has multiple variants * Cleanse 1 - 1 Day Cleanse - 2 Day Cleanse - 5 Day Cleanse * Cleanse 2 - 1 Day Cleanse - 2 Day Cleanse - 5 Day Cleanse and so on ... For each variant will correspond a specific number of deliveries * Cleanse 1 - 1 Day Cleanse - 1 delivery - 2 Day Cleanse - 2 deliveries - 5 Day Cleanse - 3 deliveries * Cleanse 2 - 1 Day Cleanse - 1 delivery - 2 Day Cleanse - 2 deliveries - 5 Day Cleanse - 3 deliveries On Checkout form, specific to each plan/variant, the user should have the possibility to specify each delivery date for the deliveries (for example if the user will go for Cleanse 1 - 2 Day Cleanse, he should be able to select two delivery days, one for each delivery) What I've done till now was to add a custom field to "product" table defined as a Single Drop-down with specific values (Number of deliveries - 1,2,3) and selected Front-end / Back-end which allowed me to go in Back-end and specify for each variant the specific "Number of deliveries" and at the same time the specified value was showed in the Front-end as "Specification - Number of Deliveries (value)". In order to allow the user to set specific dates for the delivery at the checkout form I need to use the "order" table custom fields. How could I make the link between the "product" table and "order table" because if I use the "order" table I can`t use the option "Display limited to" on the "product" table. Thank you")* Hi, We won't be able to help you with that project. I would recommend to contact our partners for a quote on the project: [ polishedgeek.com/](https://polishedgeek.com/) [ tcp-innovation.fr/](http://tcp-innovation.fr/) [ www.makedifferent.fr/](http://www.makedifferent.fr/) Or to find a developer via joomlancers.com or resources.joomla.org Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI3LWNoZWNrb3V0Lzg2NTk5Mi1jaGVja291dC1jdXN0b20tZmllbGQtZnJvbS1hLWRpZmZlcmVudC10YWJsZT90bXBsPW1hcmtkb3du) or [Create an account](/register) 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.061 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)