Add multiple employees time to a single time card

  • 1
  • 2
  • Question
  • Updated 1 year ago
  • In Progress
I would like to create a "time card" table and form that allows me to enter a project, task, and then choose the employees from a connected table.  Easy enough, but the trick is that I would like to be able to choose an additional employee on another line in the same form, that would have its own hours assigned but who's record would otherwise contain the same project info as the first employee selection.  The idea is for a foreman in the field to be able to open the "enter time card" form and enter the daily time for a bunch of employees at once, each of whom might have different hours.  Help!
Photo of Brandon Porter

Brandon Porter

  • 160 Points 100 badge 2x thumb

Posted 1 year ago

  • 1
  • 2
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,486 Points 50k badge 2x thumb
No problem.

You have a relationship where 1 Forman has many Time cards.  So that is good.
Next you need to have a relationship where 1 Time card has Many employees.  They can be then shown in an embedded report in grid edit mode where the foreman can enter the employee names and the time all on that one form.

You can also use the Copy Master detail wizard helper to make a button to copy the Forman's Time Card as it is likely that the Foreman often has a similar crew to a previous day, so that would copy the Foreman, and the crew on that time card in one click.
Photo of Brandon Porter

Brandon Porter

  • 160 Points 100 badge 2x thumb
Are you referring to a grid edit report embedded into the form?  How do I do that?
Photo of Brandon Porter

Brandon Porter

  • 160 Points 100 badge 2x thumb
Also, I need this to be accessible via the web app on a mobile phone....
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,486 Points 50k badge 2x thumb
Yes, Grid edit on a form.  You can allow an embedded report to be editable on the form by checking the "editable" check box on the form properties for the report link field of the embedded time entries.

As for use on a mobile phone, there are two interfaces available, the regular desktop version and the mobile and you can switch back and forth on a phone.

But I don't believe that there is Grid Edit available on the mobile version.  So you will need to try it out and decide which would work best for your users.  it may also depend on how large a phone they have, like is it an iPhone 4 or a massive phablet size phone, or something in between,  or a small tablet.