Hi
New to all this, but loving getting stuck in.
I need to filter results of items to be delivered on a particular day. On a Monday for example, a table would show me all the items I need; 125 x item1, 200 x item2 etc.
The items would be pulled from the 'customer_data' table, 'monday_order' fields. There are around 15 items, so a field for each is needed.
I can do this in Excel, but a bit unsure with php/mysql. I can make the fields, but the count/sum function, and populating the fields with the results is where I struggle.
I just need pointing in the right direction, so any help is appreciated. Please bear in mind I am not a master of coding.
Many thanks in advance.
SUM of total items on filtered days
Re: SUM of total items on filtered days
There is no programing needed, just type the date and hit enter in table view of customer_data' table
AppGini will filter the result based on that.
You can also follow this tutorial:
https://bigprof.com/appgini/tips-and-tu ... ers/part-1
For the calculating part check this tutorial:
http://bigprof.com/appgini/tips-and-tut ... eld-values
And if it is something like invoice, check the project invoice:
https://bigprof.com/appgini/download-sample-projects
AppGini will filter the result based on that.
You can also follow this tutorial:
https://bigprof.com/appgini/tips-and-tu ... ers/part-1
For the calculating part check this tutorial:
http://bigprof.com/appgini/tips-and-tut ... eld-values
And if it is something like invoice, check the project invoice:
https://bigprof.com/appgini/download-sample-projects
AppGini 22.14 - xampp 3.3.0 - PHP 7.4.30 - Summary reports - Calendar - Mass update - Messages - AppGiniHelper