Hey there, I created one field called "# of Hours" and I wanted to use this field a multiple times for each employee. How can I do that? The employee field is a multi-select field and I need to the "# of Hours"- Field to show up for every employee. How can I implement this? Thanks a lot.
A multi select field, is one when you can choose many choices in the same field on the same record.
As for your question, when you create a field in QuickBase the field will appear on all records.
However, perhaps you are really trying to ask how you create a child table where 1 employee has many hour records, such as each child hours record would represent a different day worked?
The "employee" field is a multiselect field, where I can choose multiple employees for one task.
For example we have 3 employees working on the task "logistics". And now I want to assign the "# of Hours" field for each employee because not every selected employee is working same hours on one task. Hope I could describe it better now.
The usual setup is that you would have three tables, Tasks, Employees, and a middle join table called Employee Task Assignments.
1 Task has Many Task Assignments.
1 Employee has Many Task Assignments.
and on the middle Task Assignments table would be selecting the employee, the task and entering how many hours they worked.
So either you are confused as to which field you're populating on the form compare to which field is actually in the relationship or else you should delete that relationship rebuild it.
Each timecard should only be for a single employee.
What I am saying is that you can have an embedded Report Link report on the Task Record, showing the child Time cards, and set it to be editable in form properties. Then you can do all your data entry on that grid edit report and not have to add the time cards one by one.