Hello,
is it possible in Appsheet to record the working hours of an employee in one process of several projects?
For example, on one day the employee works 3 hours on construction site 1, 3 hours on construction site B, 3 hours on construction site C. Total: 9 hours. So I would like to record all 3 construction sites with one entry.
1 Like
Hello - Yes you can achieve this in multiple ways. One approach is to have:
- Employee table - list of employees
- Project table - list of projects
- Hours Table - list of hours worked
- projectHours table - list of hours contributed to projects
The ‘Hours’ table will have the child ‘ProjectHours’ table that is set as ‘a part of the’ parent ‘Hours’ table. When you access the ‘Hours’ form to input hours, you will be able to add multiple child ‘projectHours’ records in the same form. You can then use formulas to calculate the total hours from each child ‘projectHours’ to total the total hours on the ‘hours’ table.
You would also then have a ‘Project’ table that the ‘projectHours’ table is using as a reference for to list all projects.
And lastly you would probably need an ‘employee’ table to list all employees to use as a reference as well.
Thank you for the answer! I’m new to Appsheet.. I hope I can somehow realize this
If you have questions, don’t hesitate to ask!
To be honest, I didn’t quite understand this: The ‘Hours’ table will have the child ‘ProjectHours’ table that is set as ‘a part of the’ parent ‘Hours’ table. When you access the ‘Hours’ form to input hours, you will be able to add multiple child ‘projectHours’ records in the same form.
Here is a sample app walkthough video that hopefully explains better.
Hello,
thank you very much! That helped me a lot! A video says more than 100 sentences. 
I will design the app like this and then carry out the analysis with Google Looker Studio.
To describe my task again: every week I have to type 20 handwritten weekly reports
from employees into the computer and assign the working hours to the respective projects.
At the end of the month I then need the total hours of the employees for the wages.
I will only use Appsheet as a desktop app. That means the employee has nothing to do with the app. That’s what the boss wants…
Thank you again!
1 Like
Good luck!
Hello,
I have some problems with the app linking. Have you already deleted the example app? Could you perhaps send it to me?
Lou
Hey Lou -
Sorry I did already delete the example app. I am happy to try to answer any question you might have. Or I can put together the example again really quick if you are not sure what is going wrong.
Hello,
I don’t know what the problem is, unfortunately it just doesn’t work. If I could look at your example app, then maybe I’ll understand it. I’ve only been using Appsheet for a short time. I still have a lot to learn
I can share the app with you if you direct message me your email address
Thank you very much! That will definitely help me.
My email is (PII Removed by Staff)
Shared
Thank you very much!