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 and have determined how long each type of agreement takes. I need a formula to take the Type of Agreement field and read it and know if its (ex.) MNDA it should show 3.75 hours. Can someone help?
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.
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.
