Can I take data of an embedded report link (spreadsheet in quickbase - task table) and use it in another table?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

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.

Thank u!

Photo of Dilan

Dilan

  • 0 Points

Posted 3 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 62,438 Points 50k badge 2x thumb
Can you describe your tables and their relationships. ie which are the One in which are the Many in the relationships.
Photo of Dilan

Dilan

  • 0 Points
There is a table "Tasks" which is related to "Timecards"
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              
                                            Hours                             Hours
    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?
Thanks!
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,438 Points 50k badge 2x thumb
Can you tell me what the source is for the employee names in the TimeCards?  Do you have a table of employees along with their rates?  If not, then that is what you need to do.  They will need to be chosen from a drop down list driven by a relationship.  Then you can pull in the hourly rate off a relationship lookup field down to those time card entry child table entries.
Photo of Dilan

Dilan

  • 0 Points
Yes, I have also a Employee Table with the rate - Sorry forgot to mention. But how can I take those values and add it into the Expense Table in the Field Labour Costs?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,438 Points 50k badge 2x thumb
Can you give me the names of all your tables and how they are currently related?  I particularly want to know if that entry for Employee X in your post above is a separate entry into a table.

Where do those employee names come from now?  Are they User fields or multiple choice fields now?
Photo of Dilan

Dilan

  • 0 Points
Yes they come from User-fields. It is a key-field.
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!
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,438 Points 50k badge 2x thumb
If you have a relationship between employees and timecards, you should be able to lookup the employee rate down to the time card record.  Then it will be available there to do your calculation.