show me a screenshot of the sheet… you mean is not showing orders or is counting all orders into one order?
Which one
Orders app
Dashboard app
is the same sheet for both apps?
Yes
I will share the app
so take a screenshot from Glide editor of that sheet…
or invite me to Zoom:
structureartdigital@gmail.com
You can check it now.it is copyable.
it shows only items that have today’s date… that what you put in the filter
But check the quantity.its should show only 4 but it’s showing the previous count too.thats my concern.
Do you want me to order.
Check it it showing 14 packets.but i orders today as 4+3 packets.it should show 7 packets.
you need to create one more column to show only the today order quantity
Tell me what’s needs to be done
in the orders sheet, you don’t have a timestamp column when the order was created, so you can’t separate these orders by date… add a timestamp column there… and an IF-ELSE column to get quantity if the date is today… so you can sum that column
I have a date column the date in which the order created.what is timestamp column?
Any example
yes, the timestamp is the date that the record is created, there are no dates in ORDERS sheet…
I see the date column… is that a timestamp?
so now create a if ele column to check if order is today
Yes that date column is timestamp column.
ok… you need to get just a date, no time… use the math column to extract month… day… year for the time stamp and for today’s date… so you can compare these values without time…
and use template column to combine these values
