# How to deal with this

**URL:** <https://community.glideapps.com/t/how-to-deal-with-this/39083>\
**Category:** Ask for Help\
**Created:** [February 28, 2022, 6:47pm UTC](https://community.glideapps.com/t/how-to-deal-with-this/39083 "2022-02-28T18:47:36Z")\
**Posts on this page:** 20\
**Page:** 2

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [March 1, 2022, 6:20pm UTC](https://community.glideapps.com/t/how-to-deal-with-this/39083/21 "2022-03-01T18:20:09Z")

</div>

show me a screenshot of the sheet… you mean is not showing orders or is counting all orders into one order?

---

<div class="post-metadata">

**Author:** ![Manikandan\_R](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manikandan_r/32/43482_2.png) [@Manikandan\_R](https://community.glideapps.com/u/Manikandan_R)\
**Post date:** [March 1, 2022, 6:20pm UTC](https://community.glideapps.com/t/how-to-deal-with-this/39083/22 "2022-03-01T18:20:45Z")

</div>

Which one

Orders app  
Dashboard app

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [March 1, 2022, 6:25pm UTC](https://community.glideapps.com/t/how-to-deal-with-this/39083/23 "2022-03-01T18:25:20Z")

</div>

is the same sheet for both apps?

---

<div class="post-metadata">

**Author:** ![Manikandan\_R](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manikandan_r/32/43482_2.png) [@Manikandan\_R](https://community.glideapps.com/u/Manikandan_R)\
**Post date:** [March 1, 2022, 6:25pm UTC](https://community.glideapps.com/t/how-to-deal-with-this/39083/24 "2022-03-01T18:25:34Z")

</div>

Yes

---

<div class="post-metadata">

**Author:** ![Manikandan\_R](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manikandan_r/32/43482_2.png) [@Manikandan\_R](https://community.glideapps.com/u/Manikandan_R)\
**Post date:** [March 1, 2022, 6:26pm UTC](https://community.glideapps.com/t/how-to-deal-with-this/39083/25 "2022-03-01T18:26:03Z")

</div>

I will share the app

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [March 1, 2022, 6:26pm UTC](https://community.glideapps.com/t/how-to-deal-with-this/39083/26 "2022-03-01T18:26:05Z")

</div>

so take a screenshot from Glide editor of that sheet…  
or invite me to Zoom:  
[structureartdigital@gmail.com](mailto:structureartdigital@gmail.com)

---

<div class="post-metadata">

**Author:** ![Manikandan\_R](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manikandan_r/32/43482_2.png) [@Manikandan\_R](https://community.glideapps.com/u/Manikandan_R)\
**Post date:** [March 1, 2022, 6:27pm UTC](https://community.glideapps.com/t/how-to-deal-with-this/39083/27 "2022-03-01T18:27:17Z")

</div>

You can check it now.it is copyable.

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [March 1, 2022, 6:30pm UTC](https://community.glideapps.com/t/how-to-deal-with-this/39083/28 "2022-03-01T18:30:33Z")

</div>

it shows only items that have today’s date… that what you put in the filter

---

<div class="post-metadata">

**Author:** ![Manikandan\_R](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manikandan_r/32/43482_2.png) [@Manikandan\_R](https://community.glideapps.com/u/Manikandan_R)\
**Post date:** [March 1, 2022, 6:31pm UTC](https://community.glideapps.com/t/how-to-deal-with-this/39083/29 "2022-03-01T18:31:34Z")

</div>

But check the quantity.its should show only 4 but it’s showing the previous count too.thats my concern.

---

<div class="post-metadata">

**Author:** ![Manikandan\_R](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manikandan_r/32/43482_2.png) [@Manikandan\_R](https://community.glideapps.com/u/Manikandan_R)\
**Post date:** [March 1, 2022, 6:33pm UTC](https://community.glideapps.com/t/how-to-deal-with-this/39083/30 "2022-03-01T18:33:07Z")

</div>

Do you want me to order.

---

<div class="post-metadata">

**Author:** ![Manikandan\_R](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manikandan_r/32/43482_2.png) [@Manikandan\_R](https://community.glideapps.com/u/Manikandan_R)\
**Post date:** [March 1, 2022, 6:34pm UTC](https://community.glideapps.com/t/how-to-deal-with-this/39083/31 "2022-03-01T18:34:39Z")

</div>

Check it it showing 14 packets.but i orders today as 4+3 packets.it should show 7 packets.

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [March 1, 2022, 6:35pm UTC](https://community.glideapps.com/t/how-to-deal-with-this/39083/32 "2022-03-01T18:35:32Z")

</div>

you need to create one more column to show only the today order quantity

---

<div class="post-metadata">

**Author:** ![Manikandan\_R](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manikandan_r/32/43482_2.png) [@Manikandan\_R](https://community.glideapps.com/u/Manikandan_R)\
**Post date:** [March 1, 2022, 6:36pm UTC](https://community.glideapps.com/t/how-to-deal-with-this/39083/33 "2022-03-01T18:36:05Z")

</div>

Tell me what’s needs to be done

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [March 1, 2022, 6:38pm UTC](https://community.glideapps.com/t/how-to-deal-with-this/39083/34 "2022-03-01T18:38:02Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Manikandan\_R](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manikandan_r/32/43482_2.png) [@Manikandan\_R](https://community.glideapps.com/u/Manikandan_R)\
**Post date:** [March 1, 2022, 6:40pm UTC](https://community.glideapps.com/t/how-to-deal-with-this/39083/35 "2022-03-01T18:40:30Z")

</div>

I have a date column the date in which the order created.what is timestamp column?  
Any example

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [March 1, 2022, 6:42pm UTC](https://community.glideapps.com/t/how-to-deal-with-this/39083/36 "2022-03-01T18:42:04Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Manikandan\_R](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manikandan_r/32/43482_2.png) [@Manikandan\_R](https://community.glideapps.com/u/Manikandan_R)\
**Post date:** [March 1, 2022, 6:44pm UTC](https://community.glideapps.com/t/how-to-deal-with-this/39083/37 "2022-03-01T18:44:37Z")

</div>

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/a/5acc1acb5bf004e6099bce19a3a3f03608d1dd97.png)  
check this.

---

<div class="post-metadata">

**Author:** ![Manikandan\_R](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manikandan_r/32/43482_2.png) [@Manikandan\_R](https://community.glideapps.com/u/Manikandan_R)\
**Post date:** [March 1, 2022, 6:47pm UTC](https://community.glideapps.com/t/how-to-deal-with-this/39083/38 "2022-03-01T18:47:42Z")

</div>

Yes that date column is timestamp column.

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [March 1, 2022, 6:50pm UTC](https://community.glideapps.com/t/how-to-deal-with-this/39083/39 "2022-03-01T18:50:27Z")

</div>

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…

 ![Screen Shot 2022-03-01 at 1.55.37 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/4/a4be1d6388e5aa5d5eacbc0cec24b18cb2e280ca.png)

and use template column to combine these values

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [March 1, 2022, 6:58pm UTC](https://community.glideapps.com/t/how-to-deal-with-this/39083/40 "2022-03-01T18:58:30Z")

</div>

or you can do that in google sheets using the to\_text formula… much faster! only 1 column is needed to do that 😉  
or use a Glide template column… it will convert to text… so you can have just date

 ![Screen Shot 2022-03-01 at 2.11.14 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/7/e7d49f6ddd0a4986a3fafa2fb24bbcd3b937273b.png)

[Previous page](https://community.glideapps.com/t/how-to-deal-with-this/39083.md?page=1)

[Next page](https://community.glideapps.com/t/how-to-deal-with-this/39083.md?page=3)
