Managing contracts and extensions

Hi @Marisa_Pettit1,

So I imagine a 3-table setup being the best starting place for you:

• Companies
• Contracts :: Each Company can have multiple Contracts
• Terms :: Each Contract has at least 1 Term, but possibly many

Terms could be labeled with a “Type” as either “Original” or “Extension”.
This should be workable with the Gantt Chart, I think.

Here’s a quick and dirty example:

Hi @Marisa_Pettit1 - suggestion for the base structure here is:

• 3 tables - Customers, Contracts, Contract Periods
• A contract belongs to a customer
• A contract period belongs to a contract

Something like this:

Your PO, budget details might, in fact, be against the contract period (although this depends upon how you set up your contracts)

Haha! These two solutions are so close, it must be the right answer :winking_face:

lol… glad to know I’m in good company with the way I approached this problem :winking_face:

I’m thumbs-upping every message in this thread.

Thank you so much! I’m about to try this out and will let you all know how it goes.

So, I’ve made some progress, but I’m now thinking that maybe the Gantt app isn’t the best route to go. Thoughts?

I think in an ideal situation the outcome would be similar to the Org Chart maybe, so that the hierarchy is clearly evident. If I’m on the right track with that line of thinking, the original contract would be at the top and then the extensions of the contract would fall underneath. If so, then how should I set up the self-linking linked record field to make this manageable? Or do you have suggestions on a different/better approach?

@Marisa_Pettit1
If you are wanting to carry on discussion about how best to structure your data, can you give more detail about what you want to see and why?

I ask because creating same-table references for contracts in order to use an Org Chart style hierarchy is a very different data structure than using the Contract << Terms setup suggested by @JonathanBowen and myself.

It’s understandable that the Gantt chart app itself may not fit your needs, since it’s likely meant to be used with shorter time scales than, say, a year per “chunk”.

But I’m not sure exactly what your vision is for the functionality and who needs to view this data, for what purpose they need to view it, and what they need to be able to do with the data in addition to viewing it. That may make a difference in terms of what “App” might be the best choice, if any is needed at all. Often, just a good Grouping or nested Grouping in a Grid view is sufficient:

Can you give us more detail about what you need to see, how you want to input data, how you want to interact, or how you need others to see/interact with your base?