Google Sheets Script Creator

General information for the website: Google sheet for attendance
Description of requirements/features: We use a good sheet for attendance in a small club and I want to “jazz it up” a bit.

Here is a link to the current sheet https://docs.google.com/spreadsheets/d/114yU-9qOIDq-Fq9Numckzk8IANNsi_Cao91ipucZuTk/edit?usp=sharing


Here is what I want


- Is it possible to get the sheet name from the setup file e.g if I change in the setup sheet the same of the group then that sheet also renames itself (Maybe like this ? https://productforums.google.com/forum/#!topic/docs/DzexKVCOWQs )

- Is it possible to Either A) Hide the old days from users who are member of an email group OR have a look at the tab called Copy of Group 1, could we make it so that when users enter data in here it pushes it through to the group 1 sheet for the correct day?

If you click group 1 and scroll all the way to end I want the Emergency, Sick, medical etc… To count only 1 if it is entered in a day E.G If on the 02/02/2015 a student misses 5 lessons with code E E E E E E (6 lessons) then it should say at the end count as 1 instead of currently 6

Is it possible for when a student reaches the 1st, 2nd and no exam warning (set on the setup sheet) that a person is emailed say say “STUDENT XXXXX has reached the 1st warning””

Extra notes: