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

Expand all | Collapse all

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

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

    Silver
    Contributor
    Posted 02-24-2018 08:48
    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 calculate of the actual pay of those time cards.

    If we pay one associate on hourly basis then, then there is no problem to calculate the rate if they fill multiple time cards or a single time card.

    Problem is when we pay associate on daily basis then if they fill 3 time cards of today like one is 5 hours, 2 hours and 1 hours and their daily rate is $100 then, system calculate rate $300 for today because for some reason we want to pay full rate whether they work for 3 hours or 8 hours.

    Hope the above explanation clears everything.

    Please let me know if you need any further information.

    Thanks,

    Gaurav


  • 2.  RE: Need to combine multiple time cards in a single entry for the correct calculation.

    Silver
    Contributor
    Posted 02-26-2018 06:27
    Any update?


  • 3.  RE: Need to combine multiple time cards in a single entry for the correct calculation.

    Posted 02-26-2018 12:24
    Can you state your current relevant tables and their relationships?


  • 4.  RE: Need to combine multiple time cards in a single entry for the correct calculation.

    Silver
    Contributor
    Posted 02-26-2018 12:43
    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.


  • 5.  RE: Need to combine multiple time cards in a single entry for the correct calculation.

    Posted 02-26-2018 15:09
    You will need to have a table called Employee Dates where the Key field is a concatenation of the [Record ID# of Employee] and the [Date]. 

    List("-", ToText([Record ID# of Employee], ToText([Date])) 

     If you like you can actually create the formula field and make it the Key field by using the API_SetKeyField&fid=10 API typed into the URL bar.

    Then set up an Action to ensure that for every time entry, the action will fire if the Key field does not exists already for that Employee and date.

    I do that by making a field Key field exists? with a formula value of true and look that up down to Time Entries, and fire the Acton of the Ket does not exists.

    Then you will be able to make summary fields up to that Employee Dates to have the data available to know how many entries there were that date.




     


  • 6.  RE: Need to combine multiple time cards in a single entry for the correct calculation.

    Silver
    Contributor
    Posted 02-27-2018 11:44
    As per your suggestion, I have created a new table called Employee Dates and set up a formula field which shows the combination of Employee Record ID# and Date and made it as a key field.

    Do I need to create any relationship with the newly created table?

    Thanks,

    Gaurav


  • 7.  RE: Need to combine multiple time cards in a single entry for the correct calculation.

    Posted 02-27-2018 12:12
    Yes, , you need to create a similar concatented field in time cards and make a relationship to employee dates. Then you can do any summary fields you need.

    You will also have to initially populate the employee dates table by making a summary report on timecards and copying the records over to the employee dates table.


  • 8.  RE: Need to combine multiple time cards in a single entry for the correct calculation.

    Silver
    Contributor
    Posted 02-27-2018 15:54
    Mark, as I have already made the new formula field as a key field which shows the combined text of Employee Record ID# and the date. but, I can't copy the records over to the employee dates table as there are some duplicates records for a day.


  • 9.  RE: Need to combine multiple time cards in a single entry for the correct calculation.

    Posted 02-27-2018 15:58
    Right, hence my suggestion to use a summary report on that concatenated field. :)