# Database Organization

**URL:** <https://community.glideapps.com/t/database-organization/61085>\
**Category:** Ask for Help\
**Created:** [April 28, 2023, 6:07am UTC](https://community.glideapps.com/t/database-organization/61085 "2023-04-28T06:07:10Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Oliv3r](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/oliv3r/32/58221_2.png) [@Oliv3r](https://community.glideapps.com/u/Oliv3r)\
**Post date:** [April 28, 2023, 6:07am UTC](https://community.glideapps.com/t/database-organization/61085/1 "2023-04-28T06:07:10Z")

</div>

I am a teacher. I want to create an attendance tracker, but I am unsure about the best way to organize the database. In terms of simplicity, speed and efficiency, do I want to organize by…?

1. Organize by date (With a list of students and their status absent or present). And then create a new date object everyday.

or

1. Organize by student (with a new column for each date and the student status absent or present in each date column)

Thanks for your advice and assistance, greatly appreciated.

---

<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:** [April 28, 2023, 7:07am UTC](https://community.glideapps.com/t/database-organization/61085/2 "2023-04-28T07:07:34Z")

</div>

The date is a position… a student is an object… now you need to answer yourself… what are you tracking … position or objects? If both… then 2X of data… if one of these… then depends of what is less

---

<div class="post-metadata">

**Author:** ![Oliv3r](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/oliv3r/32/58221_2.png) [@Oliv3r](https://community.glideapps.com/u/Oliv3r)\
**Post date:** [April 28, 2023, 8:21am UTC](https://community.glideapps.com/t/database-organization/61085/3 "2023-04-28T08:21:18Z")

</div>

Thanks for the advice Uzo. I’ll try the by student organization method.

---

<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:** [April 28, 2023, 8:25am UTC](https://community.glideapps.com/t/database-organization/61085/4 "2023-04-28T08:25:20Z")

</div>

The Next piece of advice… try to put all data in one place… do not care that it will take more columns… find as many variables that both share… and rest… create separate columns… make it one feed… it will be much easier to deal with it.

---

<div class="post-metadata">

**Author:** ![Oliv3r](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/oliv3r/32/58221_2.png) [@Oliv3r](https://community.glideapps.com/u/Oliv3r)\
**Post date:** [April 28, 2023, 8:39am UTC](https://community.glideapps.com/t/database-organization/61085/5 "2023-04-28T08:39:19Z")

</div>

Thanks.