im planning to create an apps that will help to distribute time table for teacher.
anyone can guide step by step to do this.
let says teacher,subject,class,time.
1st to create a time table according to teacher and subject
then when teacher are retired,transfer,medical leave the time table can be rearrange.
for daily substitute other teacher will help fill in the class according to their availability.
how can the apps inform substitute teacher which class to go and what time using sms,email,watsap or telgram
Hi,
Perhaps you should have two separate tables, one main timetable, plus a daily table. Every day, run a bot that will add the relevant timetable rows to the daily table, with an additional column for the date. Once the rows are in the daily table you can make changes to which teacher is assigned to which lesson on that day. Maybe you should run this a week in advance (the date in the bot should be TODAY()+7 etc), so you have access to make changes in advance.
You can then use the data to sum up the total hours/lessons that each teacher has worked.
Additionally, you can add school holidays to either the daily table, or on another table, and have the bot that runs daily skip the run if there’s a school holiday on the selected date.
1 Like
You can set up an automation to either run when an update (change) is recorded on the timetable or daily, with a condition if the Teacher is not the same as the main timetable, then send an email/SMS to the teacher.
It’s probably best to have another table for the Teacher’s contact details, and the Teacher column on the timetables should be REF to the Teachers’ table.
1 Like