Got something cool to share with AppGini users? Feel free to post it here!
-
ronwill
- Veteran Member
- Posts: 228
- Joined: 2015-08-08 10:12
- Location: Cheltenham UK +Weatherford USA
Post
by ronwill » 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:
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 2815 times
- solution2.jpg (106.64 KiB) Viewed 2815 times
- solution3.jpg (43.58 KiB) Viewed 2815 times
Hope it helps someone!
Cheers, Ron
Ron - AppGini Pro V 5.81 Rev 1094
Gloucestershire, UK
Top
Ron - Gloucestershire, UK: AppGini Pro V 23.15 Rev 1484 - LOVING IT!
Plugins: Mass Update + Search Page Maker + Summary Reports + Calendar + Messages
Bizzworxx: AppGiniHelper + Inline Detail View
Alejandro Landini: To-Do List + MPI + TV Field Editor
Other: Udemy Course
-
a.gneady
- Site Admin
- Posts: 1287
- Joined: 2012-09-27 14:46
-
Contact:
Post
by a.gneady » 2019-10-30 10:22
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.
AppGini plugins to add more power to your apps:
- DataTalk is an innovative AppGini plugin based on ChatGPT that allows you to interact with your AppGini database using natural language questions, without writing any SQL. Check the demo video
- Mass Update plugin: Update multiple records at once and improve your workflow efficiency.
- Check our other plugins and get a generous discount of up to 30% when buying 2 or more plugins.