Formula Help
Hello! We use quickbase to track legal agreements we issue. We have a field "Type of Agreement" that we populate with the agreement we issued. We would like to track how many hours we spend overall a...
Forum Discussion
Kirstynn,
I would build this:
Your table of Agreement Types is a Parent to the Agreement Table. You then build a Summary Field in the relationship between the two tables. You then know how many hours have been logged on the Agreements for each Agreement Type. Your report would be built in the Agreement Type table.
As you delve into new Legal Matters, adding additional records to the Agreement Type table will automatically feed into your reports.
MarkShnier__You
Qrew Legend
Qrew LegendJust to tag on to Don's post above, there are two numbers that you probably want. One is the Standard hours for each Contract Type that would be loaded in the Agreement Types table and looked up down to Agreements. Then you might want to create a child table in agreements where the staff can enter their actual hours spent.
Then you would summarize those actual hours up to Agreements and you would be able to compare that. Standard time vs the actual time.