CALCULATED FIELD AppGini Pro V 5.81

Got something cool to share with AppGini users? Feel free to post it here!
Post Reply
User avatar
ronwill
Veteran Member
Posts: 228
Joined: 2015-08-08 10:12
Location: Cheltenham UK +Weatherford USA

CALCULATED FIELD AppGini Pro V 5.81

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
solution1.jpg (109.3 KiB) Viewed 2800 times
solution2.jpg
solution2.jpg (106.64 KiB) Viewed 2800 times
solution3.jpg
solution3.jpg (43.58 KiB) Viewed 2800 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

User avatar
a.gneady
Site Admin
Posts: 1281
Joined: 2012-09-27 14:46
Contact:

Re: CALCULATED FIELD AppGini Pro V 5.81

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.
:idea: 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.

Post Reply