+3Hello! 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?
+15Kirstynn,
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.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
