CALCULATED FIELD AppGini Pro V 5.81

[ronwill]

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:

Code: Select all

SELECT `products`.`itemprice` * `order`.`qtyitem`
FROM `order`
LEFT JOIN `products` ON `products`.`id`=`order`.`itemname` 
WHERE `order`.`id`='%ID%'

IMAGES: itemname + itemprice (auto fill) are lookup fields from PRODUCTS table

solution1.jpg (109.3 KiB) Viewed 3391 times

solution2.jpg (106.64 KiB) Viewed 3391 times

solution3.jpg (43.58 KiB) Viewed 3391 times

Hope it helps someone!
Cheers, Ron
Ron - AppGini Pro V 5.81 Rev 1094
Gloucestershire, UK

Top

[a.gneady]

Thanks for sharing. We're so excited about the new calculated fields feature and will gradually implement it in many of the open source AppGini apps that we publish.