Recording time spent on a job by multiple people

AppSheet AppSheet Q&A
1

New (hopefully better) version of an existing app which basically has three tables: Teams, Jobs & Employees.

Each day multiple teams of between 1 and 6 people are created using entries from the Employees table.

Each day there are multiple jobs created each of which are assigned one of the teams.
(So there is a relationship between the Teams and the Jobs)

Question:
I want to show each team member in the Job detail view and to be able to assign the number of hours each team member spent on that job.

(Ultimately I’d like to add up the hours for each team member for each day)

How would be the best way to go about that?

2

To achieve this in AppSheet, you need to structure your relationships properly and ensure that hours worked by each employee can be recorded.
There are some guard to achieve that

3

hi

Add 1 topic at a time to get to know employees. Both the practice and the employees are improving.

run
run1920×1080 264 KB