Hi All,
I'm building a stock management application and I would like to do some dynamic calculation.
I have Attached my PHPGRID
http://i57.tinypic.com/1sxhcy.png
As you can see I have 4 Columns
– Qty Selected
– Qty Available
– Qty in Bin
– Qty Reserved
I Would like to do an automatic calculation between those 4 columns.
I want that when the user chose an amount that will be deducted from the amount in Bin and the same time be able to know how many are reserved and how many are available.
I am very confused by this feature
Thank you for your help.
cordially
If your columns are editable, you can do it using JS callback function on blur event.
Refer faq: How to populate other column, based on previous columns?
You can also manage the calculation just before insert / update in database. For that you will need to use custom event handler functions which gives you control to change the query values before execution.
Refer demo code; demos/editing/custom-events.php (this is supported in full package)
Hello Abu, talking about this feature, i want something similar, at the moment of capture the field, other field is filled with a calculation based in the capture, before save.
I thought see an example in the demos, but now i don't find it, can you tell me what demo is? or show me how do this???