Skip to main content
Question

Create Missing Timecards Between Two Dates

  • August 16, 2023
  • 0 replies
  • 94 views
Forum|alt.badge.img+6

I can't see the forest for the trees on this one,

Anyway, we have a requirement to strictly maintain timecards on a weekly basis for several reasons, however, compliance is the crux of all timecard requirements.

Each timecard (parent table) is created by the user, also the timecard owner. Once created, they manage charge codes (child table).

I can discern the number of missing timecards for the current year through Today() with a basic formula (# required timecards) - (# initiated or completed) = missing timecards.

I want my weekly routine in pipelines to create missing week-ending timecards against each employee. 

I have 70 plus pipelines, so I'm sure I can build the brunt of the requirement, but I cannot figure out how to squeeze out the missing week-ending dates for each missing timecard for the current year through today.



------------------------------
Thank you so much,
Chuck
------------------------------
Thank you so much, v/r, Chuck
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+24

    Can you clarify if you need one time card created for every day or is the time card for every week, per employee? 

    Also, how far back do you want to go to create these missing time cards. Are you just trying to make sure the current week is up-to-date or you're trying to fix the whole years worth of history!



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement