Forum Discussion

GauravSharma3's avatar
GauravSharma3
Qrew Commander
8 years ago

Need to combine multiple time cards in a single entry for the correct calculation.

Hi team, We have an application where one associate fills multiple timecards for a day. Now, I want to create one timecard which will show the total hours of all the time cards. It is because of to...
App builders
Ask about Quickbase functionality
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
Can you state your current relevant tables and their relationships?
  • GauravSharma3's avatar
    GauravSharma3
    Qrew Commander
    8 years ago
    Hi Mark,

    Thank you for your reply.

    I have two tables:

    1. Associates
    2. Time cards

    one associate has many time cards.

    The associates' table has their rate and pays type (Hourly and Daily) and based on that time cards calculate the rate as per the hours worked.

    Do let me know if you need any further information.

    Thanks,

    Gaurav.