Applying condition to make new table

Ask for Help
1

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

2

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

3

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.

4

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).

5

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!

1 Like
6

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

1 Like