Need some helps with my app to extract attendance record based on a date choice component. I’ve spent the past 2 days but no result.
I have a tab with 4 buttons. Each button submits attendance for a class. In the form has a date component, and choice component for each students to select Present, Absent or Late. Hence, the data sheet will have a column for each student and the date in the row. In addition, there is a seperate sheet for each button.
What I try to achieve is in a new tab, I can select a date from a choice component, then a list comes out to show all the students in the class and their attendance on that particular day.
Much appreciate if anyone can give me some clues?