{gdata title=|Missing screencast| app=|none|}
How to Access
Select Components → Contact Enhanced → Custom Values from the drop-down menu on the back-end of your Joomla! installation. This option is only available if you have a SQL Form Field type.
The Form Fields Manager screen allows you to create advanced Form Fields using the SQL Form Field type, which displays a Select dropdown with values from the database. Some users might want to add the values to a new database table, that's why we've created the Custom Values;
Text: The text the user will see in the dropdown select list (required);
Type: You can enter any value to help you to keep things organized;
Category: You can use this field as you wish; You can enter a value or select one from the list; IMPORTANT: This is not necessary related to the Contact Enhanced Categories;
SQL Field Examples:
SELECT CONCAT('Product: ', p.product_sku ,' Order#: ', o.order_number ,' Total: ',o.order_total) AS text, CONCAT('Product:',p.virtuemart_product_id,' - ', p.product_sku ,' :: Order ID:', o.virtuemart_order_id ,' Date: ', FROM_UNIXTIME(o.created_on) ,', Status: ', os.order_status_name) AS value FROM #__virtuemart_orders AS o INNER JOIN #__virtuemart_order_items AS oi ON o.virtuemart_order_id = oi.virtuemart_order_id INNER JOIN #__virtuemart_products AS p ON p.virtuemart_product_id = oi.virtuemart_product_id INNER JOIN #__virtuemart_orderstates AS os ON o.order_status = os.order_status_code WHERE o.virtuemart_user_id ={user_id}
Copyright © 2018 IdealExtensions.com. All Rights Reserved.