# Keep track of delivered items **URL:** \ **Category:** Ask for Help\ **Created:** [November 25, 2021, 10:31pm UTC](https://community.glideapps.com/t/keep-track-of-delivered-items/35060 "2021-11-25T22:31:12Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![Alessandro\_P](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alessandro_p/32/35095_2.png) [@Alessandro\_P](https://community.glideapps.com/u/Alessandro_P)\ **Post date:** [November 25, 2021, 10:31pm UTC](https://community.glideapps.com/t/keep-track-of-delivered-items/35060/1 "2021-11-25T22:31:12Z")
Hello, I want to keep track of all of the items that I regularly ship in various locations in Europe. I send these boxes daily and at the end of the day, I want to see a list with all of the locations I have sent my items and how many items per country. Here you have a screenshot of my excel file. Thank you in advance ![screenshot](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/f/dfeaf573b2dfb6313c947d64b9fd3c1a65657221.png) ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [November 25, 2021, 11:00pm UTC](https://community.glideapps.com/t/keep-track-of-delivered-items/35060/2 "2021-11-25T23:00:23Z")
Hi @Alessandro_P , it seems it’s your first time posting in the forum, so first and foremost welcome to the community forum 🙂 A few ideas that might help: - Unless you regularly work in the Google spreadsheet, I would store the data of your app in a Glide Table (you could create your app from a Google Sheet just in case). - Possible layout for your app: one tab for your list of items grouped per day, possibly a second tab with a chart+table of number of items sent per country (it’s unclear to me in your description if you would need this rollup per day or otherwise). - What is to happen when you change weeks? Do you empty your chart or do you need to keep a record? - Ask yourself if you will be adding items (boxes sent) directly in the table or through your app. - Possible structure of your “Boxes” table (whether in Google Sheets or Glide Data Editor): box\_name (text column), box\_description (optional, text column), box\_ID (optional but might be useful to uniquely identify your boxes), box\_shipping\_country (text column), box\_shipping\_city (text column), box\_shipping\_date (date/time column) - Possible structure of your “Choices” table if you decide to add items through your app: locations (text column) with a list of location - To extract the number of boxes, you will need to become familiar with [relations](https://docs.glideapps.com/all/reference/data-editor/computed-columns/relation-column) and [rollups](https://docs.glideapps.com/all/reference/data-editor/computed-columns/rollup). I think that should get your started. Make sure you structure your tables well (whether in Google Sheets or Glide). > **[Organizing your spreadsheet](https://docs.glideapps.com/all/courses/quick-starts/getting-started/organizing-your-spreadsheet)** > > How to set up your spreadsheet properly to make sure Glide recognizes the data correctly. ---
**Author:** ![Alessandro\_P](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alessandro_p/32/35095_2.png) [@Alessandro\_P](https://community.glideapps.com/u/Alessandro_P)\ **Post date:** [November 25, 2021, 11:40pm UTC](https://community.glideapps.com/t/keep-track-of-delivered-items/35060/3 "2021-11-25T23:40:01Z")
Hi Nathan, thank you for your time. As you understood, it is my first time in the forum and one of the first times using glide. I will explain the situation a little better: I have to deliver boxes every day in differnt countries in Europe. As you can see in the excel screenshot, I have a section for each day. For each day, I need to know how many boxes I have delivered in that country divided by city, so it would be something like: ITALY: - Rome: 2 boxes - Milan: 5 boxes TOTAL BOXES DELIVERED TODAY IN ITALY: 7 If on the same day I deliver in France, I need the same information as the ones for Italian deliveries and then, another column which tells me the overall deliveries in a day, so Italy + France + other countries. This has to happen everyday and when the following weeks starts, I need a blank sheet to write on, in order to have the prevoius deliveries stored and divided from the next ones ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [November 25, 2021, 11:51pm UTC](https://community.glideapps.com/t/keep-track-of-delivered-items/35060/4 "2021-11-25T23:51:49Z")
Monday+Milan → 2 Do you plan 1. to write “2” in your table? 2. or do you plan to submit 2 records of shipment (destination\_city, destination\_country, date, box\_unique\_name) and then your table calculates that there were 2 shipments to Milan on Monday?