AnsweredAssumed Answered

FMP 5.5  TimeCard and JobTime Sum of Summary

Question asked by davidanders on Oct 13, 2008
Latest reply on Oct 14, 2008 by davidanders

Title

FMP 5.5  TimeCard and JobTime Sum of Summary

Post

FileMaker Pro version 5.5  and  Filemaker Server ver 5.5 on Macintosh.
A TimeCard database is duplicated for each employee (contractors).
It contains a number of repeating fields
User. . . . .  . . . . . . . . . . . . . . . . . . . . . . . . DayName (date)  (five repetitions)
Date  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . DayStart  (time)  (five repetitions)
UserDateCalc. . . . . . . . . . . . . . . . . . . . . .DayEnd  (time)  (five repetitions)
===================================================
Job1Name. . Job1TimeSum. . . . . . . .  Job1Time (time)  (five repetitions)
Job2Name. . Job2TimeSum. . . . . . . .  Job2Time (time)  (five repetitions)
Job3Name. . Job3TimeSum. . . . . . . .  Job3Time (time)  (five repetitions)
Job4Name. . Job4TimeSum. . . . . . . .  Job4Time (time)  (five repetitions)
Job5Name. . Job5TimeSum. . . . . . . .  Job5Time (time)  (five repetitions)

The Job#TimeSum sums the time entries for that user in that payperiod on that line.

A new record is created for each payperiod (two weeks in the real DB)
JobNames will not be constant, it will change from one job to another on some payperiods

A TimeCardSum DB is related to the TimeCard by a script that creates a new record
and pastes the UserDateCalc for relating the two records.  The script then creates four
additional new records for Job2, Job3, Job4, and Job5 (if theyy are not blank)

The individual TimeCard JobTimeSums need to be summed for the Total JobTime for all Users.
This TotalTime for a Job would be related to a Jobs database for billing purposes (QuickBooks
manually entered)

 

What would be the best approach?  Another Database for JobsTime Total?
I hope this is clear enough for you to offer suggestions.
Thank you.












Outcomes