CALCULATED FIELD AppGini Pro V 5.81
Posted: 2019-10-28 20:22
EXAMPLE using Calculated Field with lookup example instead of earlier hooks solution found here: http://bigprof.com/appgini/help/advance
[This has been repeated from a separate board topic I started, to show my example under Tips & Tricks]
Under the new CALCULATED FIELD (from AppGini V5.81), it is a quicker and easier solution to the hooks method as it does not require any edit to hooks file. I recommend upgrading to latest version, it just gets better and better!
CODE:
IMAGES: itemname + itemprice (auto fill) are lookup fields from PRODUCTS table
Hope it helps someone!
Cheers, Ron
Ron - AppGini Pro V 5.81 Rev 1094
Gloucestershire, UK
Top
[This has been repeated from a separate board topic I started, to show my example under Tips & Tricks]
Under the new CALCULATED FIELD (from AppGini V5.81), it is a quicker and easier solution to the hooks method as it does not require any edit to hooks file. I recommend upgrading to latest version, it just gets better and better!
CODE:
Code: Select all
SELECT `products`.`itemprice` * `order`.`qtyitem`
FROM `order`
LEFT JOIN `products` ON `products`.`id`=`order`.`itemname`
WHERE `order`.`id`='%ID%'- solution1.jpg (109.3 KiB) Viewed 3405 times
- solution2.jpg (106.64 KiB) Viewed 3405 times
- solution3.jpg (43.58 KiB) Viewed 3405 times
Cheers, Ron
Ron - AppGini Pro V 5.81 Rev 1094
Gloucestershire, UK
Top