Comparing lists and value return

[oskar_hamerski]

Hi, I am new here and I am not doing well with lists.

I have two lists. 1) Student list 2) Attendance list.
The attendance list has as many records as the students.

There are names in the student list.
On the attendance list, there are numbers (which mean 0= present, 2= absent, 1= late).

When I press the button I would like to get a new list of present students.

I have tried to do like this:

But I can’t manage it…
Can anyone help?

[Still-learning (1-2-3-4...)]

Do not use for each item list block, it will give duplicate values… try like this, there by you can extract present, absent as wll as late also

[sugarlesscreator]

Or
You can use spinner to select attendance
Like this

Spinner properties

Block

[Still-learning (1-2-3-4...)]

if you are using ghsheet then it will be very convenient to use

Ref here

METRIC RAT AI2 - Use gviz to get and query google sheet data