# How to create order history in free app
**URL:** https://community.glideapps.com/t/how-to-create-order-history-in-free-app/31365
**Category:** Ask for Help
**Created:** [September 4, 2021, 10:02am UTC](https://community.glideapps.com/t/how-to-create-order-history-in-free-app/31365 "2021-09-04T10:02:41Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@Manikandan\_R](https://community.glideapps.com/u/Manikandan_R)
#### Post date: [September 4, 2021, 10:02am UTC](https://community.glideapps.com/t/how-to-create-order-history-in-free-app/31365/1 "2021-09-04T10:02:42Z")
I need solution to display order history tab for each user.it should list only order related to that particular user.i have a phone number as required field when placing the order.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [September 4, 2021, 10:37am UTC](https://community.glideapps.com/t/how-to-create-order-history-in-free-app/31365/2 "2021-09-04T10:37:58Z")
So you don’t store their emails in the orders sheet right?
I imagine you can use a relation from the user profiles table to the orders table using the phone number as the connector and display that relation in an inline list.
---
### Author:  [@Manikandan\_R](https://community.glideapps.com/u/Manikandan_R)
#### Post date: [September 4, 2021, 1:54pm UTC](https://community.glideapps.com/t/how-to-create-order-history-in-free-app/31365/3 "2021-09-04T13:54:31Z")
Still not getting this order history
Attached is what my tabs are
Now I’m getting email in my table
Now I need order history for that particular user.
I don’t know which field to be relate.i tried meals type with email but nothing comes in the relation column.
Need help on this.!
[IMG\_20210904\_191919|666x500](https://community.glideapps.com/uploads/short-url/7sqdI7IJkBhDdy4J01ziAWDVCzi.jpeg)
!
 
---
### Author:  [@Manikandan\_R](https://community.glideapps.com/u/Manikandan_R)
#### Post date: [September 4, 2021, 5:11pm UTC](https://community.glideapps.com/t/how-to-create-order-history-in-free-app/31365/4 "2021-09-04T17:11:27Z")
Hi
Forgot to make email as row owner, required output came.thanks
---
### Author:  [@Manikandan\_R](https://community.glideapps.com/u/Manikandan_R)
#### Post date: [September 28, 2021, 6:52pm UTC](https://community.glideapps.com/t/how-to-create-order-history-in-free-app/31365/5 "2021-09-28T18:52:22Z")
@ThinhDinh order history is working but I need this in some format.
I have a tab as order history displaying orders showing in tiles,meals type, phone number,date and time.
Now I need to change the format as displaying all the orders of a particular date into one.
Today date
Yesterday date
So on…
How to achieve this?
---
### Author:  [@kyleheney](https://community.glideapps.com/u/kyleheney)
#### Post date: [September 28, 2021, 7:21pm UTC](https://community.glideapps.com/t/how-to-create-order-history-in-free-app/31365/6 "2021-09-28T19:21:17Z")
Filter your list by date “is within today” , etc.
For yesterday, etc, use a Math column to get the value for Date - 1 (where Date is your order date), then filter your list using that “yesterday” result.
---
### Author:  [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)
#### Post date: [January 17, 2024, 4:50pm UTC](https://community.glideapps.com/t/how-to-create-order-history-in-free-app/31365/7 "2024-01-17T16:50:22Z")