I'm a teacher and I design a tool that allows teachers to design lessons and plan lessons. I'm new to programming and that's going to be a bit ambitious for me. I'm happy with what I've got so far, but there are some details I can not figure out. The idea is that this will be widely used, even for teachers with little technical knowledge. That's why it has to be "bulletproof".
Below is a copy of the spreadsheet so you can see the code and get an overview. What I mainly limit myself to is figuring out how to display the lessons in the unit summary so that they can be automatically updated and easily rearranged.
Each lesson has a tab and the unit summary contains data that has been validated to display the lessons in a drop-down menu based on another tab named "Sheet Name" that contains a script that retrieves all the lesson names. After selecting from the drop-down menu, the text will be replaced by a link to this tab. However, this script refers to the Sheet Name tab by line number. So, if you delete a lesson that is not the last one created, the unit summary will be confused and the lesson will appear in that row in the sheet name sheet. Any ideas on how to fix this? [this is mainly the script “UnitOverviewLinkGenerator.gs”, but because it’s important to see the other scripts too, I thought it made more sense to share rather than post just that script]
Also, I'd like to have the option to use the Google Drive Picker in the timetables where "Insert resource via link" to add a link to a Google Drive file. I've read a lot, but I think that's beyond what I can do.
If you have any thoughts, please post here or comment on the spreadsheet instead of making changes directly.
Thank you for any ideas or help you can provide!
Editable version of the table