I have implemented one spreadsheet which contains time cards related to tasks into an embedded report link. Is it possible to get certain fields related to another table?
For instance, "Number of Hours for Logistics" of the spreadsheet should be shown up in the expense table to calculate labor costs.
Tasks - contains different Tasks for one Project. For example "Material Distribution" .
Timecards - should be based on a spreadsheet with following form:
Task Name Material Distribution Pins
Employee X 2 5
Employee Y 5 3
And now the big question is - Is it possible to take the Number of Hours in Total for Employee X and Y and use it in an Expense Table, where the Hours are multiplied with the Hourly Costs from each Employee.
Expenses Table Hourly Costs Total Labor Costs
Employee X 24 (2+5) = 7 *24 = 168
Employee Y 33 (5+3) = 8 * 33 = 264
Can I link values from an embedded spreadsheet with other tables?
Where do those employee names come from now? Are they User fields or multiple choice fields now?
My tables are
Projects Tasks Timecards Expenses Employees
Projects is related with every table in both ways
Tasks is related to Projects, Timecards and Employees
Timecards is related to Tasks, Projects, Expenses, Employees
Expenses related to Timecards, Employees, Projects
Employees related to Task, Timecards, Projects, Expenses
All in all they are all related in both ways to each other!