How to bulk add hours worked by employees on a project

[Lorenzo_Caporal]

Hi everyone, I am new to this platform and I don’t know if this question was already asked by someone else in the past.
In my app, I have three tables: Employees, Projects, and HoursWorked. The table Employees contains all the employees’ data, the table Projects contains all the projects’ data, and the table HoursWorked contains the hours worked by every employee on each project. Both the Employees and the Projects tables are parents of the HoursWorked table (the employee’s ID and the project’s ID are “Ref” in the HoursWorked table)
I would like to let my users select a list of employees from the Employees table and add the number of hours worked on a project to the HoursWorked table. The users should be able to specify the date, the number of hours worked, and the project (these fields have to be the same across all the employees selected).
Thanks in advance for your attention.

[TyAlevizos · Accepted solution]

Hi Lorenzo, not sure if you were able to figure this out. This idea of bulk additions that also supports “selection” or “parameters” comes up from time to time, so we took a moment to build a working example here:

Add rows to another table WITH parameterized input Tips & Tricks 💡

This pattern comes up more and more, so I thought I’d build a simple example. We already know that you can copy rows using the “add rows to another table” action. But sometimes we want our end user audience to provide some input first. The attached app shows a simple way to do this. At its most basic, the design has an “extra” table whose only real purpose is to allow data entry of a single row of info. This info could then be used when calling the “Copy” action. So… in our fictitious example…

Hope this helps!

[Lorenzo_Caporal]

Thank you very much!