# Applying condition to make new table

**URL:** <https://community.glideapps.com/t/applying-condition-to-make-new-table/71543>\
**Category:** Ask for Help\
**Created:** [March 9, 2024, 1:39pm UTC](https://community.glideapps.com/t/applying-condition-to-make-new-table/71543 "2024-03-09T13:39:50Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![DR123](https://avatars.discourse-cdn.com/v4/letter/d/ee59a6/32.png) [@DR123](https://community.glideapps.com/u/DR123)\
**Post date:** [March 9, 2024, 1:39pm UTC](https://community.glideapps.com/t/applying-condition-to-make-new-table/71543/1 "2024-03-09T13:39:50Z")

</div>

Hi

I need to compare my “student” and “Presence” tables and show the unmatched data in “Absence” table.

in simple term, need to update the “Absence” table based on “Student” and “Presence” tables

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [March 9, 2024, 3:11pm UTC](https://community.glideapps.com/t/applying-condition-to-make-new-table/71543/2 "2024-03-09T15:11:10Z")

</div>

Why do you have 3 tables though? How do you want to present the table on the frontend?

---

<div class="post-metadata">

**Author:** ![DR123](https://avatars.discourse-cdn.com/v4/letter/d/ee59a6/32.png) [@DR123](https://community.glideapps.com/u/DR123)\
**Post date:** [March 10, 2024, 5:24am UTC](https://community.glideapps.com/t/applying-condition-to-make-new-table/71543/3 "2024-03-10T05:24:56Z")

</div>

this is the process in a nut shell,

1. I will upload the student name list
2. I will upload the list of student who are present in particular day
3. I need to compare the two tables or two sheets and display the absent students in that day.

when it comes to frontend, I need to display all the data regarding with particular absent student. Not only the name, but also all the columns that are included in “Student” table

is there any way to do so.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [March 10, 2024, 5:44am UTC](https://community.glideapps.com/t/applying-condition-to-make-new-table/71543/4 "2024-03-10T05:44:15Z")

</div>

> [@DR123](#):
>
> I need to compare the two tables or two sheets and display the absent students in that day.

To do this, create a relation in the first table that matches the Students in the first table with the Students in the second table. The relation will be empty for any students that don’t exist in the second table (ie. those that are absent).

---

<div class="post-metadata">

**Author:** ![DR123](https://avatars.discourse-cdn.com/v4/letter/d/ee59a6/32.png) [@DR123](https://community.glideapps.com/u/DR123)\
**Post date:** [March 10, 2024, 7:06am UTC](https://community.glideapps.com/t/applying-condition-to-make-new-table/71543/5 "2024-03-10T07:06:58Z")

</div>

OK I got the idea. but how it possible with appsheet. Since I’m a beginner of this, it is much difficult to engage with this.  
can you plz guide me!

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [March 10, 2024, 9:14am UTC](https://community.glideapps.com/t/applying-condition-to-make-new-table/71543/6 "2024-03-10T09:14:17Z")

</div>

Are you developing with Appsheet or Glide? This is a Glide forum.