Viewing Daily Attendance for teachers

lavertya — Thu, 26 Sep 2024 10:59:00 GMT

Hello,

How do other schools allow their teachers to view the daily attendance for the whole building?

We used to have a customization that showed attendance in the daily bulletin (in real time), but that is no longer supported.

I was just wondering what other schools use in order to view attendance in real time for staff? Is this an additional plugin? If so, what is it called?

Thank You

Re: Viewing Daily Attendance for teachers

mikerubin21 — Tue, 15 Oct 2024 13:35:24 GMT

I would love to be able to see this as well. Has anyone provided you with an answer/solution?

Re: Viewing Daily Attendance for teachers

lavertya — Tue, 15 Oct 2024 13:39:01 GMT

Good Morning,

I had to reach out to local districts and see what html code was used. For me, it shows entire district attendance and I haven't figured out how to separate it yet, but it's better than nothing. (Luckily, we are a small one building district!)

This is what I got:

<tr>

<td class="bold">Student</td>

<td class="bold">Current Grade</td>

<td class="bold">Attendance Date</td>

<td class="bold">Comment</td>

</tr>

~[tlist_sql;

SELECT

s.lastfirst,

s.grade_level,

to_date(att.att_date,'MM/DD/YY'),

ac.att_code,

att.att_comment,

case when attt.time_in is null then '0' else to_char(attt.time_in) end timein, case when attt.time_out is null then '0' else

to_char(attt.time_out) end timeout

FROM attendance att

INNER JOIN attendance_code ac ON att.attendance_codeid = ac.ID

left outer JOIN attendance_time attt on attt.attendanceid = att.id

INNER JOIN students s on att.studentid = s.id
JOIN schools sch on att.schoolid = sch.school_number

WHERE att.att_date = '~[bulletindate;0]'

AND att.yearid = ~(curyearid)

AND att.att_mode_code = 'ATT_ModeDaily'

AND ac.att_code is not null

ORDER BY sch.name, s.grade_level, s.lastfirst,att.Att_Date;alternatecolor]

<td>~(s.lastfirst;t)</td>

<td>~(s.grade_level;l)</td>

<td>~(att.att_comment;t) </td>

<td>~(timein;l;if.test=0;then;else=~(timein;l;format=time)) </td>

<td>~(timeout;l;if.test=0;then;else=~(timeout;l;format=time)) </td> </tr> [/tlist_sql] </table>

topic Viewing Daily Attendance for teachers in Community Forum

Viewing Daily Attendance for teachers

Re: Viewing Daily Attendance for teachers

Re: Viewing Daily Attendance for teachers