I have been messing around with Sharepoint lately and wanted to start a new project. I am an HR administrator for an American company in Germany. Our employees are required to call us if they cannot make it to the shift because of sickness, so my team can inform their managers accordingly. We are using excel sheets right now where we collect all calls and then send mails to the managers manually once the big swing of calls stops. One of the main problems is that we all work on separate sheets and need to combine them once we are ready to send the mails out to the supervisors. We also want to automate the emailing process. I visited another branch and saw that the HR Admins had a Sharepoint where they pretty much just needed to type in the personal id and duration of absence which triggered a workflow pulling all necessary data like name, department, manager and so on and send emails automatically out their respective managers. Sadly the colleagues could not provide us any help because that was a project from their local IT and the person who set up the Sharepoint left the company. If I recall correctly the Sharepoint utilized 2 lists. One containing the actual absence record created after each call by entering the personal id and absence duration into a form and one list with an employee report updated manually once every few weeks.
I would appreciate any help or links to tutorials. Also sorry for any mistakes, english is obviously not my first language.